On Tue, Jul 20, 2010 at 9:58 PM, 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="x";
> $dbname="smed";
> my
'unsigned' is part of your data type which must be before the 'not
null' Your closing ) needs to be at the very end. There is no reason t
have the unique id since the primary key is unique.
First you need the column name 'patid' then the data type 'INT UNSIGNED'
then the other column options
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="x";
> $dbname="smed";
>
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="x";
$dbname="smed";
mysql_connect(localhost, $dbuser, $dbpassword);
mysql_select_db($dbnam
