mysql error...

[digitalgod]

hey guys,

I keep getting a mysql error but I can't seem to find what it is...

here's my query

mysql_query("INSERT INTO " . $prefix . "news (headline,content,thumb,website1,website2,website3,desc1,desc2,desc3,date,when,where,type) VALUES('$headline','$content','$names[0]','$web1','$web2','$web3','$desc1','$desc2','$desc3','$today','$when','$where','$type')") or die(mysql_error());

and here's the error I'm getting when inserting values

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 'when,where,type) VALUES('just testing','this is just a test','cercle.jpg','','' at line 1

[wildteen88]

See if wrapping backticks (`) around your field names in your query. MySQL might be getting confused as your have used MySQL keywords as your field names in your news table. The following are mysql keywords:
- date
- where

So change the lower part of your query to this:
`date`, when, `where`, `type`

[digitalgod]

it's still giving me the exact same error...

[trq]

Post your current query.

[digitalgod]

here you go

mysql_query("INSERT INTO " . $prefix . "news (headline,content,thumb,website1,website2,website3,desc1,desc2,desc3,`date`, when, `where`, `type`) VALUES('$headline','$content','$names[0]','$web1','$web2','$web3','$desc1','$desc2','$desc3','$today','$when','$where','$type')") or die(mysql_error());

[trq]

Alright... you might need to print out your query for debugging. What does this output?

[code=php:0]
$sql = "INSERT INTO " . $prefix . "news (headline,content,thumb,website1,website2,website3,desc1,desc2,desc3,`date`, when, `where`, `type`) VALUES ('$headline','$content','$names[0]','$web1','$web2','$web3','$desc1','$desc2','$desc3','$today','$when','$where','$type')";
mysql_query($sql) or die(mysql_error()."SQL = ".$sql);
[/code]

[digitalgod]

Hi Thorpe

here's the ouput

SQL = INSERT INTO mtl_news (headline,content,thumb,website1,website2,website3,desc1,desc2,desc3,`date`, when, `where`, `type`) VALUES ('we\'re testing','this is just a test','cercle.jpg','','','','','','','2006-11-01','','','both')

I don't understand why it doesn't work. The table exists and all the rows as well

[trq]

Look at all those blank values. Do those fields support NULLs?

[digitalgod]

yeah they do, I just left all those fields blank for testing purposes. And anyways whenever there's a blank in a row, that row doesn't get displayed to the user

[digitalgod]

anyone?