Welcome to WebmasterWorld Guest from 54.145.167.92

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Building a table for a blog.

   
9:59 pm on Apr 16, 2012 (gmt 0)



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
12:19 am on Apr 17, 2012 (gmt 0)

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



Try replacing this:

print "no TABLE created. You have problems in the system already, backtrack and debug!";


With this:


print "no TABLE created. You have problems in the system already, backtrack and debug!";
echo "\n" . mysql_error();


This will provide you with information as to why the query is failing. Then you will have to rewrite your query to fix the issue. If you need help, post the error that results from changing this code.
7:27 am on Apr 17, 2012 (gmt 0)



Error:
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 'int(11) NOT NULL AUTO_INCREMENT, title varchar(88) NOT NULL, ' at line 2
8:47 am on Apr 17, 2012 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



doesn't look like you've named your first column.
4:49 pm on Apr 17, 2012 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Also there's a trailing comma after (id), <--
6:23 pm on Apr 17, 2012 (gmt 0)



GOT IT! Thanks ALL for your help.

<?php

require_once "connect_to_mysql.php";

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

$result = "CREATE TABLE blog_sections (
id 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!";
echo "\n" . mysql_error();
}
exit();
?>