database creation issues

[Phalon]

I'm new to sql so this might be obvious to you

<?php
$connid = @mysql_connect ('localhost' , 'masc' , 'glumph');
if ($connid == false)
 { print "Server connection failed";  }
else
 { print "Server connected!"; }
$query="CREATE TABLE meminfo(
userid INT IDENTITY(1,1) NOT NULL,
username CHAR(20) NULL,
password CHAR(20) NULL)";

$result=mysql_query ($query) or die("ERROR: " .mysql_error());;

$query="INSERT INTO meminfo(username,password)
VALUES('Paul', 'Kloos')";

$result=mysql_query($query) or die("ERROR: " .mysql_error());;

$query="SELECT *";

$result=mysql_query($query) or die("ERROR: " .mysql_error());

echo $result;
?>

and the error is

Server connected!ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY(1,1) NOT NULL, username CHAR(20) NULL, password CHAR(20) NULL)' at line 2

and what i got from my php info from the server i'm on is
Client API version 4.1.7

so, i don't know what to do, i'm just using examples i found on this htmlgoodies

[NogDog]

I am not aware of any IDENTITY() attribute for integers in MySQL.

[Phalon]

Next we use IDENTITY which tells the DBMS that this is our Primary Key.Now, the (1,1) means that we want to start with the number 1 and we want to increment each new ID number by 1.

this is from the sql tutorial at htmlgoodies.com http://www.htmlgoodies.com/primers/d...le.php/3478061

[NogDog]

$query="CREATE TABLE meminfo(
userid INT PRIMARY KEY AUTO_INCREMENT,
username CHAR(20) NULL,
`password` CHAR(20) NULL) AUTO_INCREMENT=1"; 

Also, I would suggest that username and password should be NOT NULL. Lastly, "password" is a reserved word in MySQL, so you'll need to back-tick it in your queries when being used as a column name.

[Phalon]

Actually now I'm getting

Server connected!ERROR: No database selected

well the fact that i'm clueless about this one shows what a noob i am.

$query="SELECT * FROM meminfo"; 

this is the code i'm trying. but to stop some of these stupid questions, can someone direct me to a good mysql tutorial because I don't want to bother you guys too much.

[chazzy]

after you connect, you need to select your database using the php command

mysql_select_db($database_name); 

Also, the link you posted is for a MS Access tutorial. You need mysql tutorials.

How about this one:
http://www.freewebmasterhelp.com/tutorials/phpmysql/