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

Scotty13

Member
May 21, 2010
20
0
51
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

Well-Known Member
May 9, 2008
1,199
1
68
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.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
41
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hello,

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

Thanks!