mySQL/PHP Table Creation

In telnet I am creating tables in my mySQL database, I type this and get the result:


mysql> create table tsrdatabase (
-> name char(25),
-> from char(25),
-> mail char(25),
-> going_to char(25),
-> date_going char(25),
-> notes char(50)
-> );
ERROR 1064: You have an error in your SQL syntax near 'from char(25),
mail char(25),
going_to char(25),
date_going char(25),
notes char' at line 3

please help, thanks.


------------------
================
-Khill, www.tsrealm.com

from is a SQL reserve word. replace from with something else and you should be through.

Hope you get your job done....



------------------
Anish Modi
Infotech World
India