PHP queries
Posted: Wed Oct 30, 2002 12:20 pm
I can't get the $result query to work. i keep getting a parse error. something to do with the quotes i think. can someone please help me?
$newartist = mysql_query("SELECT Distinct City, Genre_Select FROM Musicians_Network WHERE Date_Created > curdate()-7", $db);
if ($myfirstrow = mysql_fetch_array($newartist)) {
do {
$result = mysql_query("SELECT Contact FROM Musicians_Network WHERE (City = ". $myfirstrow['City'] ." or Genre_Select = ".
$myfirstrow['Genre_Select']) ." and Updates = 'Yes'",$db);
}while ($myrow = mysql_fetch_array($newartist));
$newartist = mysql_query("SELECT Distinct City, Genre_Select FROM Musicians_Network WHERE Date_Created > curdate()-7", $db);
if ($myfirstrow = mysql_fetch_array($newartist)) {
do {
$result = mysql_query("SELECT Contact FROM Musicians_Network WHERE (City = ". $myfirstrow['City'] ." or Genre_Select = ".
$myfirstrow['Genre_Select']) ." and Updates = 'Yes'",$db);
}while ($myrow = mysql_fetch_array($newartist));