INSERT INTO problem

wit

Ok.. i cant seem to figure out why some of my sql info isnt inserting.. heres the code i have for opening my db:

  $server = mysql_connect($host,$user,$pass);
  mysql_select_db($db,$server);

$result=mysql_query("SELECT * FROM photos",$server);
$urlresult = mysql_query("SELECT * FROM urls",$server); /*//#//*/
$res=mysql_num_rows($result);
$urres = mysql_num_rows($urlresult); /*//#//*/
$picid=$res+1;
$urlid = $urres + 1;  /*//#//*/
mysql_query("INSERT INTO photos(albumid, picid, url, title, description) VALUES ('$album', '$picid', '$img1_name', '$title', '$description');",$server);
mysql_query("INSERT INTO urls(id, urlid, ahref1, ebaylink, ahref2, ebaydesc, ahref3) VALUES ( 'null', '$urlid' '$ahref1', '$ebaylink', '$ahref2', '$ebaydesc', '$ahref3' );",$server); /*//#//*/

Now this part is the only part that wont insert:

mysql_query("INSERT INTO urls(id, urlid, ahref1, ebaylink, ahref2, ebaydesc, ahref3) VALUES ( 'null', '$urlid' '$ahref1', '$ebaylink', '$ahref2', '$ebaydesc', '$ahref3' );",$server); /*//#//*/

The rest works fine but that bit wont insert... I dont get any errors or anything.. it acts normally as if all went OK but when i check my db i find nothing was added.

wit

tha_mink

Make it easier on yourself...variables for queries make it a little easier to debug. And use the "or die(mysql_error())" bit so mysql spits the errors back for you.

Why not just do...

$server = mysql_connect($host,$user,$pass);
mysql_select_db($db,$server);

//now we're connected and will be for the rest of the script
$query = "INSERT INTO urls(id, urlid, ahref1, ebaylink, ahref2, ebaydesc, ahref3) VALUES (null, '$urlid', '$ahref1', '$ebaylink', '$ahref2', '$ebaydesc', '$ahref3')";
mysql_query($query) or die(mysql_error());

mysql_close($server);
//  now we're not connected anymore

The error was in your 'null'. You don't need to quote it.

wit

Sweet thanks..

I changed my code a bit.. i fixed the quotes on the null but when i did the terms in a variable and the or die i got an error again.. it turns out i had a comma missing in the VALUES .. if ya look you can see it.. there supposed to be a comma after 'ahref1' but theres not.. thanks for your help...

wit

Ryan_Sanders

Hey, I am having trouble fixing my code.

<?php 
$db = mysql_connect("host","user","password"); 
mysql_select_db("database"); 
$blah = "INSERT INTO e_roster (name, height, weight, finisher, trademark, location, biography, record, desc) VALUES ('$name','$height','$weight','$finisher','$trademark','$location','$biography','$record','$desc')";
mysql_query($blah) or die(mysql_error());
echo "Thank you! Information entered."; 
mysql_close($server);
?>

You have an error in your SQL syntax near 'desc) VALUES ('sfdf','sdf','sdf','sdf','sdf','sdfsd','sdf','0-0','sdf')' at line 1

That is my error.
All of the sdf's is what i put in that field for testing.

-__________________
NEVERMIND I FIXED IT!