[PHP-DB] Resource id #2

2001-10-28 Thread Andrew Duck
I am trying to select a message from a table in a database. the message will will be in column 'msg' and will be in same row as id='0'. I need that msg put to the screen. With the code below I get the error: Resource id #2 Can someone please explain how I can fix this.. Thankyou in advance. ?

[PHP-DB] MySQL Query

2001-10-26 Thread Andrew Duck
Error SQL-query : CREATE TABLE mail ( from int(32) NOT NULL default '0', to int(32) NOT NULL default '0', subject varchar(80) NOT NULL default '', message text NOT NULL ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'from int(32) NOT NULL default '0', to