olm75
12-07-2004, 10:14 PM
ok can u show me how to search the mysql database i would greatly appreciate it cuz im pulling my hair out over here...im using flash mx and PHP....
here' the the query but i dont know how to put it in a script:
$query_searchRS = sprintf("SELECT city, `state`, `area code`, `venue type`, `music type`, `age group`, venues.city FROM venues WHERE `venue name` = '%s' AND venues.`state` AND venues.`area code` AND venues.email AND venues.website AND venues.`venue type` AND venues.`music type` AND venues.`age group` ORDER BY `venue name` ASC", $colname_searchRS);
can u show me how to wright the rest of the script plz..(and please explain like i am very slow lol...)..
here is the .fla......
and there is an example on my site nightspotz.com (http://www.nigtspotz.com) and go to the search link
here' the the query but i dont know how to put it in a script:
$query_searchRS = sprintf("SELECT city, `state`, `area code`, `venue type`, `music type`, `age group`, venues.city FROM venues WHERE `venue name` = '%s' AND venues.`state` AND venues.`area code` AND venues.email AND venues.website AND venues.`venue type` AND venues.`music type` AND venues.`age group` ORDER BY `venue name` ASC", $colname_searchRS);
can u show me how to wright the rest of the script plz..(and please explain like i am very slow lol...)..
here is the .fla......
and there is an example on my site nightspotz.com (http://www.nigtspotz.com) and go to the search link