Creating table with MySql

[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);
?>

[lightning]

Hello,

You need to add commas after all of the members_defs statements except for the last one. Example:

$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";

I tested the script after adding the commas on my server and it worked.

• Jonathan Summers
  http://summers.dhs.org/jon/?request=contact