1) Connect to the MySQL Server
2) Select Database
3) Issue Query
[code:1:98451b1271]
// database configuration
$host = "localhost";
$user = "xxxxxx";
$pass = "xxxxx";
$db = "xxxxxxxx";
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$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);
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
[/code:1:98451b1271]
