PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$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'"));
$query_user=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
$fetch_user=mysql_fetch_object($query_user);
$query_air=mysql_query("SELECT * FROM airport WHERE location='$fetch_user->location' LIMIT 1");
$fetch_air=mysql_fetch_object($query_air);
$query_user=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
$fetch_user=mysql_fetch_object($query_user);
$query_air=mysql_query("SELECT * FROM airport WHERE location='$fetch_user->location' LIMIT 1");
$fetch_air=mysql_fetch_object($query_air);
and thsoe don't get no errors.
Ok, maybe try storing the mysql_query() result in a variable than storing the mysql_fetch_object() in another variable?
function fetch_object($query) {
$result = mysql_query($query) or die(mysql_error().': '.$query);
$obj = mysql_fetch_object($result);
if ( false===$obj ) {
die("no result for '$query'");
}
return $obj;
}
$owned_air1 = fetch_object("SELECT id FROM airport WHERE location='Liverpool' AND username='$username'");
$owned_air2 = fetch_object("SELECT id FROM airport WHERE location='Manchester' AND username='$username'");
$owned_air3 = fetch_object("SELECT id FROM airport WHERE location='New York' AND username='$username'");
$owned_air4 = fetch_object("SELECT id FROM airport WHERE location='Compton' AND username='$username'");
$owned_air5 = fetch_object("SELECT id FROM airport WHERE location='Amsterdam' AND username='$username'");
$owned_air6 = fetch_object("SELECT id FROM airport WHERE location='Hong Kong' AND username='$username'");