PHP Code:
<?php
//Build Database
include('../dbconnect.php');
//Members Table
mysql_query("CREATE TABLE members(
memberID INT NOT NULL,
username VARCHAR(30),
PRIMARY KEY(username),
email VARCHAR(30),
password VARCHAR(30),
clan BOOL,
gender BOOL,
age INT
)")
//Error if table does not get created
or die(mysql_error());
echo "Members Table Created!";
//News Table
mysql_query("CREATE TABLE news(
newsID INT NOT NULL,
PRIMARY KEY(newsID),
title_news VARCHAR(30)'
body_news VARCHAR(30),
author_news VARCHAR(30),
date_news INT
)")
//Error if table does not get created
or die(mysql_error());
echo "News Table Created!";
?>
there is my database creation code however in the browser it comes up with error message..
Members Table Created! 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 '' body_news VARCHAR(30), author_news VARCHAR(30), date_news INT )' at line 4
any ideas plz... |
