flash mx search to mysql

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 [URL=http://www.nigtspotz.com]nightspotz.com[/URL] and go to the search link

Also in #PHP _↴