Hi all,

I appear to be having probs with this piece of coding below:

1. CREATE TABLE sessions (
2. id varchar(32) NOT NULL default '',
3. userid int(11) NOT NULL default '0',
4. username varchar(25) NOT NULL default '',
5. mod int(1) NOT NULL default '0',
6. sessiondate datetime NOT NULL default '0000-00-00 00:00:00'
7. ) TYPE=MyISAM;

When I try to load it into the database it returns this error message.

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
'mod int(1) NOT NULL default '0'
session datetime NOT NULL default 0000-00-00 00:00:00
at line 5

Any help would be appreciated, thanks in advance

Geoff

This is the full text - can moderator please leave in forum - thanks Geoff

the word 'mod' clashes with a MySQL math function. You'll have to either rename the column to something else, or enclose it in backticks `mod` to help MySQl tell it apart from the function MOD(). Backticks ` live on the key underneath ESC on my keyboard, they are different from single quotes '

Thanks Oberon - that worked - you da man!