Building a table for a blog.... Not Connecting

[Scotty13]

I'm trying to build a blog_sections_table in phpMyAdmin / MySQL and getting...
Success in database CONNECTION.....
no TABLE created. You have problems in the system already, backtrack and debug!

Here's my table, what 'am I missing?

<?php

require_once "connect_to_mysql.php";

print "Success in database CONNECTION.....<br />";

$result = "CREATE TABLE blog_sections (
int(11) NOT NULL AUTO_INCREMENT,
title varchar(88) NOT NULL,
ordered 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 'section.php' 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!";
}
exit();
?>

Thanks, Scott

 

[thewebhosting]

Enter following code in your script after "print "no TABLE created. You have problems in the system already, backtrack and debug!";";

echo "\n" . mysql_error();

It will show you exact error message in your SQL query to know why it is failing.

 

[Scotty13]

Thanks, that works for me. S

 

[cPanelTristan]

Hello,

What error did you receive when you enabled that option in your code?

Thanks!