strange error

fire_cracker

I am building a script to add links to my database. For some reason I keep getting a strange error with this line of code:

<center><a href="add.php">back</a></center>

I have no idea what the problem is? Here is the main part of the script that I am argueing with. Maybe I'm messing something up and don't realize it.

<?
if($submit)
{
mysql_connect(localhost,user,pass);
mysql_select_db(database);
mysql_query("INSERT INTO links VALUES(\"NULL\",\"$url\",\"$title\",\"$description\",\"$date\",\"$niche\",\"$type\");
?>
<center><a href="add.php">back</a></center>
<?
}

Thanks for the help everyone.

hp829

you forgot the closing quote on the mysql_query function. Just add a quote at the end like this:

mysql_query("INSERT INTO links VALUES(\"NULL\",\"$url\",\"$title\",\"$description\",\"$date\",\"$niche\",\"$type\")");

pjleonhardt

Try:

<?
if($submit)
{
mysql_connect(localhost,user,pass);
mysql_select_db(database);
mysql_query("INSERT INTO links VALUES('NULL', '$url', '$title', '$description', '$date', '$niche', '$type'");

//and you might as well do this in the php
echo "<center><a href=\"add.php\">back</a></center>";


}
?>

hth

fire_cracker

Thanks for the quick reply. It was indeed the closing tag on the sql statement. I hate how such a little tiny error can cause so much trouble lol. Then need to do some advanced error handling for dumb ppl like me

"SQL ERROR - Hey, Idiot, you forgot to close the mysql statement on line 45."

Much better then:
"Parse error in /www/something/page/index.php on line 45"