syntax error

[zmola]

$link = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);

mysql_db_query($db_name, "insert into table (ticket, message, timestamp) VALUES($ticket, '".addslashes($message)."', $now)", $link);

You have an error in your SQL syntax near ')' at line 1

where please? the mysql_db_query is in a function. $link and $db_name are global and defined outside that function.

ps: nobody in newbies now so i post here. hope that's okay :😄:

[Traduim]

You may get a hint by copying the SQL query inside a die() command.

mysql_db_query($db_name, "insert into table (ticket, message, timestamp) VALUES($ticket, '".addslashes($message)."', $now)", $link) or die("insert into table (ticket, message, timestamp) VALUES($ticket, '".addslashes($message)."', $now)");

It may be an error in some variable.

[zmola]

die gives "You have an error in your SQL syntax near ')' at line 1"

i omitted "die(mysql_error())" from above post coz line was long already.

[Traduim]

I meant to add all the query inside die() to see what you are really sending to MySQL. If, for instance, $now is null, you will have a SQL syntax error. mysql_error() is fine to locate errors, but sometime you need to see all the SQL string to see where exactly the error is.

[zmola]

oops ::sorry:: i misunderstood. all the stuff i pass to the function is not there.

insert into table (ticket, message, timestamp) VALUES('','',)

foo. i see the 'error' so now to figure out why my stuff is not there...

[zmola]

foo1.php

include("foo2.php");

$ticket = CreateTicket($tsubj, $tname, $temail, $tcat, $tphone, $tpri);

foo2.php

$link = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);

function CreateTicket($subject, $name, $email, $cat, $phone, $pri=2) {
	global $link, $db_name;

if ($subject == "")
	$subject = "[No Subject]";

            // blah blah blah
}

doing as suggested above using die gives:

insert into table (subject, name, email, cat, phone, status, ID, priority) VALUES ('[No Subject]', '', '', '', '', 'open', 171428, )

why please? what am i missing?

[The_Chancer]

Just noticed, you are trying to input into 8 different columns, ie
subject, name, email, cat, phone, status, ID, priority
But only 7 values ie
'[No Subject]', '', '', '', '', 'open', 171428

using the

insert into table (subject, name, email, cat, phone, status, ID, priority) VALUES ('[No Subject]', '', '', '', '', 'open', 171428,'')

might work a little better...

[zmola]

mysql_db_query($db_name, "insert into table (subject, name, email, cat, phone, status, ID, priority) VALUES ('".addslashes($subject)."', '$name', '$email', '$cat', '$phone', 'open', $ID, $pri)", $link) 
or die("insert into table (subject, name, email, cat, phone, status, ID, priority) VALUES ('".addslashes($subject)."', '$name', '$email', '$cat', '$phone', 'open', $ID, $pri)");

the die gives:

insert into table (subject, name, email, cat, phone, status, ID, priority) VALUES ('[No Subject]', '', '', '', '', 'open', 171428, )

there's a , after 171428 so i think that's where the 8th thing is supposed to go.

anyone see why my stuff doesn't show up?

[zmola]

i figured it out :😄: