[COLOR=#ff0000]I have this Table, forum_posts (forum I’m building).
[/COLOR]<?php
require_once “connect_to_mysql.php”;// Tell ourselves on screen if we have connected
print “Success in database CONNECTION…<br />”;
$result = "create table IF NOT EXISTS forum_posts (
id int(11) NOT NULL AUTO_INCREMENT,
post_author varchar(24) NOT NULL,
post_author_id int(11) NOT NULL,
otid int(11) NOT NULL,
date_time datetime NOT NULL default ‘0000-00-00 00:00:00’,
replyButton int(11) NOT NULL,
type enum(‘a’,‘b’) NOT NULL default,
view_count int(11) NOT NULL,
section_title varchar(88) NOT NULL,
section_id int(11) NOT NULL,
thread_title varchar(64) NOT NULL,
thread_id enum(‘a’,‘b’) NOT NULL default ‘a’,
post_body text NOT NULL,
post_title int(11) NOT NULL,
all_responses int(11) NOT NULL,
forum_section_title int(11) NOT NULL,
forum_section_id int(11) NOT NULL,
this_id enum(‘a’,‘b’) NOT NULL default ‘a’,
tktedmembers_id int(11) NOT NULL,
PRIMARY KEY (id)
) ";
if (mysql_query($result)){
print “Success in TABLE creation!..
<br /><br /><b>That completes the table setup, now delete the file <br />
named ‘forum_posts’ and you are ready to move on. Let us go!</b>”;
} else {
print “no TABLE created. You have problems in the system already, backtrack and debug!”;
echo "
" . mysql_error();
echo mysql_error();
}
exit();
?>
[COLOR=#ff0000]I get this error when testing in IE…
[/COLOR]Success in database CONNECTION…
no TABLE created. You have problems in the system already, backtrack and debug! 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 ’ view_count int(11) NOT NULL, section_title varchar(88) NOT NULL, ’ at line 8. 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 ’ view_count int(11) NOT NULL, section_title varchar(88) NOT NULL, ’ at line 8.
Please Help!
Scotty13
