this works, i found the error
<?php
$linkID = @mysql_connect(localhost, "", "") or die(mysql_error());
mysql_select_db("chronicyouth", $linkID) or die(mysql_error());
$resultID = ("CREATE TABLE posts(
id int(10) NOT NULL auto_increment,
date date NOT NULL default,
name varchar(26) NOT NULL default,
email varchar(100) NOT NULL default,
homepage varchar(100) NOT NULL default,
body text NOT NULL,
PRIMARY KEY (id)
), $linkID") or die(mysql_error());
if ($resultID != FALSE)
{
print "The query was successfully executed.";
}
else
{
print "The Query was not successfully executed.";
}
mysql_close($linkID);
?>
), $linkID") or die(mysql_error());
was
)", $linkID) or die(mysql_error());
double quotes needed to be moved.
now, one more problem. it says that it succeeds. but, i can't find it in the database. :p