Codezwiz >> Forums >> Request a Script >> flash mx to mysql database

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 and go to the search link