mysql_fetch_object(): supplied argument is not a valid MySQL
Posted: Sun Feb 11, 2007 12:27 pm
how do I fix these so I don't get that error?
Code: Select all
$owned_air1 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='Liverpool' AND username='$username'"));
$owned_air2 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='Manchester' AND username='$username'"));
$owned_air3 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='New York' AND username='$username'"));
$owned_air4 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='Compton' AND username='$username'"));
$owned_air5 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='Amsterdam' AND username='$username'"));
$owned_air6 = mysql_fetch_object(mysql_query("SELECT id FROM airport WHERE location='Hong Kong' AND username='$username'"));