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…

30,000 Mb And Unlimited Bandwidth Only $3.75/mo.


Go Daddy $6.95 .com sale 468x60

Powered By: BigInfo.org