[SOLVED] Simple query won't work

[Mutley]

Is there any reason why this won't work?

 

<?php

$sql_three = "
	INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '15', '0', '1', '0', '1'); 
	INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '29', '0', '1', '0', '3'); 
	INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '34', '0', '1', '0', '5')
";
mysql_query($sql_three);

?>

 

It only puzzles me because when I echo the SQL or copy the code and paste it into phpMyAdmin it works flawlessly.

 

Thanks,

Nick.

[BlueSkyIS]

resource mysql_query ( string query [, resource link_identifier] )

mysql_query() sends an unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.

[Gamic]

<?php

$sql_three[]= "INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '15', '0', '1', '0', '1');";
$sql_three[]= "INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '29', '0', '1', '0', '3');";
$sql_three[]= "INSERT INTO `own` (own_id, user_id, prod_id, damage, loadout, market_id, slot) VALUES ('', '$user_id', '34', '0', '1', '0', '5');";

foreach ($sql_three as $key=>$value){
mysql_query($value);
}
?>