query event error

[bugsybunny]

hey all, im having some troubles adding an event,

heres the error:

QUERY 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 'unix_timestamp(),'TEST')' at line 1

Query was INSERT INTO gangevents VALUES ('',,unix_timestamp(),'TEST')

heres the query:

$db->query("INSERT INTO gangevents VALUES ('',{$ir['gangID']},unix_timestamp(),'TEST')",$c);

now i really cant see what im doing wrong !! Any help or sarcastic comments are welcome!

[Dave]

Re: query event error

If your using mccodes $ir['gangID'] should infact be $ir['gang'], But the error is being caused due to $ir['gangID'] not existing :)

[bugsybunny]

Re: query event error

o my! thank you ! so simple! :-D