insert error

malakolama

hi guys ,

i am newbie to both the site and PHP as well.. i've written this piece of code to authonticate a user but .. i've come across a problem...

Before i added any of the insert statements the code was working pretty fine , but since adding it it gives me an error -

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL"

my insert code goes like this...

$userdins ="insert into log (user_name,l_date,l_time,l_type,l_status)
values ('mihiri','logday','logtime','DBConnect','Success');" ;

$unamedins =mysql_query($userdins,$dbcnx);

the table type is INNODB.. fields are all variable character fields

any help is greatly appreciated..

thanks in advance
malakolama

lsp

i think the problem is because you havent inclosed the insert command in a mysql query command. this is an example from the web

mysql_query ("INSERT INTO birthdays (name, birthday) VALUES ('Peggy', 'June4')");

all you have to do is put

mysql_query("your insert query here");

and that should solve your problem.

TheDefender

Nah, he's already got that...

$userdins ="insert into log (user_name,l_date,l_time,l_type,l_status) 
values ('mihiri','logday','logtime','DBConnect','Success');" ; 
// Here's his query execution...
$unamedins =mysql_query($userdins,$dbcnx);

You have a rogue semi-colon (after your last close parenthesis) in your sql select definition. Also,add a die() to your query, and it should give you a more detailed output of the problem when problems occur...

$userdins ="insert into log (user_name,l_date,l_time,l_type,l_status) 
values ('mihiri','logday','logtime','DBConnect','Success')" ; 
$unamedins =mysql_query($userdins,$dbcnx) OR die(mysql_error());

malakolama

hi guys thanks so much for your replies but i am still getting "

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SQL:"

i have removed the semi colon and added the die statement annd now it goes like :

$userdins ="insert into log (user_name, l_date, l_time, l_type, l_status) values ('mihiri', 'logday', 'logtime', 'DBConnect', 'Success')" ;
$unamedins =mysql_query($userdins,$dbcnx)OR die(mysql_error());

any help is greatly appreciated.
thanks
mala

laserlight

You have a rogue semi-colon (after your last close parenthesis) in your sql select definition.

That's okay, it is normal SQL after all.

Try something like:

$userdins = "INSERT INTO `log`
	(`user_name`, `l_date`, `l_time`, `l_type`, `l_status`)
	VALUES('mihiri', 'logday', 'logtime', 'DBConnect', 'Success')";
$unamedins = mysql_query($userdins, $dbcnx)
	OR die(mysql_error());

It may be possible that 'log' is a reserved word.

malakolama

guys i finally found the damn error ..... it wasnt any of it.. guess... what... there was a ")" missing in the next insert command .. LOL.. stupid me..

thanks a heap for all your responses guys...

Mala