[RESOLVED] Combine These Queries

[slindstr]

Hey everyone,

 I was hoping to get some help combining this into one query (I'm still fairly new to mysql):

$query = "SELECT user_id FROM listings WHERE listing_id='$listing_id'";
$result = mysql_query($query);
$temp = mysql_fetch_array($result, MYSQL_NUM);

if(stripslashes($temp[0]) == $user_id)
{ 
  $query = "INSERT INTO ".
	             "listing_details(listing_id, doors, transmission, mileage, drive_type, ".
				                 "engine_size, body_style, fuel_type, exterior_color) ".
				 "VALUES('$listing_id', '$doors', '$transmission', '$mileage', '$drive_type', ".
				        "'$engine_size', '$body_style', '$fuel_type', '$exterior_color') ";
$result = mysql_query($query);
}

Thanks
Steve

[bradgrafelman]

Unless you have PHP5 installed and can use the [man]MySQLi[/man] implementation, you can't do multiple queries at once.

[slindstr]

Thanks a lot - I was going crazy trying to figure out the cryptic error messages mySQL was giving me.

Steve