Mysql Creating Tables

[hearn]

Can someone tell me what i'm doing wrong, i can't get mysql to create a members databse table for me, here's my entire script:

<?php
$link = mysql_connect("localhost", "person", "password")
or exit("Could not connect");

mysql_select_db("members")
	or die("Could not select databse");

$members_defs = "username TEXT NOT NULL";
$members_defs.= "password VARCHAR(20) BINARY NOT NULL";
$members_defs.= "email VARCHAR(150) NOT NULL";
$members_defs.= "website VARCHAR(150) NOT NULL";
$members_defs.= "country VARCHAR(100) NOT NULL";

mysql_query("CREATE TABLE members ($members_defs)") or die("Cannot create table");

mysql_close($link);

?>

[[deleted]]

Put a comma between each column that you are creating..

Hope that helps...

Matt Wade
codewalkers.com

[Anon]

<?php
$link = mysql_connect(\"localhost\", \"root\", \"password\")
or exit(\"Could not connect\");

mysql_select_db(\"members\")
or die(\"Could not select databse\");

$members_defs = \"username TEXT NOT NULL,\";
$members_defs.= \"password VARCHAR(20) BINARY NOT NULL,\";
$members_defs.= \"email VARCHAR(150) NOT NULL,\";
$members_defs.= \"website VARCHAR(150) NOT NULL,\";
$members_defs.= \"country VARCHAR(100) NOT NULL\";

mysql_query(\"CREATE TABLE members ($members_defs);\") or die(\"Cannot create table\");

mysql_close($link);
?>