On Tue, July 20, 2010 09:28, dennis skinner wrote: > > > > > > Hello I am a new mysql user. Can anyone tell me why this does not > create a table? > > < ?php (the spaces before the question mark are not in the > code) > $dbuser="smeduser"; > $dbpassword="xxxxx"; > $dbname="smed"; > mysql_connect(localhost, $dbuser, $dbpassword); > mysql_select_db($dbname) or die("unable to select database"); > $query="create table patnotes(patid int(9) not null unsigned, patnote > int(6) not null unsigned auto_increment, > parentid int not null unsigned, appuserid varchar(40) not null, subject > varchar(100) not null, > body longtext not null), > primary key(patnote), > unique id(patnote)"; > mysql_query($query); > mysql_close(); > then the closing question mark and carat on this line this > does not build a file and I am wondering what syntax I am missing here > thanks dennis First question: Does smeduser have table creation privilages in this database? ------ William R. Mussatto Systems Engineer http://www.csz.com 909-920-9154
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org