List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:July 20 2010 4:41pm
Subject:Re: newb problem
View as plain text  
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

newb problemdennis skinner20 Jul
  • Re: newb problemWm Mussatto20 Jul
  • Re: newb problemChris W20 Jul
  • Re: newb problemjayabharath21 Jul