insert into troubles, i can't catch it

[dv6cougar]

 $query = "INSERT INTO main (title, by, time_set, news)";
						  $query .= "VALUES('$title',
						  					'$by',
											'$time',
											'$news')";
						 mysql_query($query);
						 echo "$query<br>";

it does print the query correctly, everything looks good to me, but it's not showing in teh database.... this is how i've been doing it on all my other database's and it's working fine, but not on this one for some odd reason.

any ideas? this is correlated with a form btw, but the values are passed correctly and teh database does connect corretly

thanks in advance

[hkucsis]

add a "die" statment may be helpful to find out the problem...

[xblue]

'by' is a reserved word.

http://www.mysql.com/doc/en/Reserved_words.html

[dv6cougar]

ah ok, i thought that might be my problem 🙂

thanks alot!