guestbook php error

sluimers

I got an error and I don't know what it means

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/goodname/www/www/guestbook.php on line 92
please notify that the script is not inserting entries

INSERT INTO guestbook(name, date, comments) VALUES('', SYSDATE(), '')

That means the my_sql tables are wrong right?
Well they look like this:

CREATE TABLE guestbook (
name varchar(50),
date varchar(40),
comments longtext,
id int(4) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY (id)
);

and this:

$insert = "INSERT INTO guestbook(name, date, comments) VALUES('$name', SYSDATE(), '$comments')";

$mysql_insert = mysql_query($insert, $mysql_link)
or die("please notify $my_email that the script is not inserting entries $name, $comments $insert");

So what's wrong with the codes??

barand

When you set $mysql_link with

$mysql_link = mysql_connect("host","user","pwd");

Check it's valid

if (!$mysql_link) echo "Connection error";

Also I'd recommend defining your date field to be type date or datetime and, while you're doing that, call it something different like date_signed, or something - saves a lot of hassle with queries if you avoid SQL reserved words and functions as field names.

sluimers

Thanks for the help, I got a new problem though, reload adds a new entry.