Newbie to mysql: Creating table error

[Dimerx]

I am currently having trouble setting up my frist database. As part of my hosting package I have phpMyadmin where I have setup a database.

I am trying to create a table for that database but getting a parse error on line 5 can anyone please help me
This is the code I am using:-
<?php
$dbs="XXXXX_Dimmembers";
$connection = @mysql_connect("mysql.XXXXXX","XXXXX","pwdXXXX") or die(mysql_error("Unable to connect"));
$dbb=@mysql_select_db($dbs,$connection) or die(mysql_error("Unable to connect to database"));
CREATE TABLE Auth_members (
userName VARCHAR(10) NOT NULL,
emailAdd VARCHAR(50) NOT NULL,
password VARCHAR(10) NOT NULL,
reGdate DATE NOT NULL,
regIp VARCHAR(15) NOT NULL,
paymPr INT(1) NOT NULL,
valMem INT(1) NOT NULL,
logDate datetime NOT NULL,
logiNip VARCHAR(15) NOT NULL,
loginnUmber INT(4) NOT NULL,
PRIMARY KEY(userName))
?>

[Xnuiem]

YOu cant put mysql commands directly into PHP. You have to wrap them.

http://www.php.net/mysql_query

[Dimerx]

Thanks