Jump to content

Archived

This topic is now archived and is closed to further replies.

simcoweb

nOOb alert! WHY oh WHY is this giving me an error?

Recommended Posts

Simple. Trying to create a table. Looked at this code 'til i'm ready to puke. Compared with other ones i've done that work fine. Perhaps another set of eyes can set me straight.

[code]<?php
include 'config.php';
// Make connect to DB first
mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die("Where is the dang database");

// Now we create the tables and rows
mysql_query("CREATE TABLE members(
business VARCHAR(255) NOT NULL,
name VARCHAR(30) NOT NULL PRIMARY KEY,
title VARCHAR(30) NOT NULL,
phone VARCHAR(30) NOT NULL,
email VARCHAR(30) NOT NULL,
url VARCHAR(30) NOT NULL,
details VARCHAR(30) NOT NULL,
category VARCHAR(30) NOT NULL") or die(mysql_error());

echo "Table Was Created Successfully!";

?>[/code]

Error I get:

[quote]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 '' at line 9[/quote]


Hellllllllllllllllllp meeeeeeeeeeeeeeeeeeeeee.......  :P

Share this post


Link to post
Share on other sites
[code]<?php
include 'config.php';
// Make connect to DB first
mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die("Where is the dang database");

// Now we create the tables and rows
mysql_query("CREATE TABLE members(
business VARCHAR(255) NOT NULL,
name VARCHAR(30) NOT NULL PRIMARY KEY,
title VARCHAR(30) NOT NULL,
phone VARCHAR(30) NOT NULL,
email VARCHAR(30) NOT NULL,
url VARCHAR(30) NOT NULL,
details VARCHAR(30) NOT NULL,
category VARCHAR(30) NOT NULL)") or die(mysql_error());

echo "Table Was Created Successfully!";

?>[/code]

Share this post


Link to post
Share on other sites
Prismatic beat me to it, but if you can't find the difference....

You are missing a closing bracket at the red spot:

category VARCHAR(30) NOT NUL[color=red]L)"[/color]) or die(mysql_error());

Share this post


Link to post
Share on other sites
Well son-of-a-biscuit-maker. Thanks for being the other set of 'eyes'!  ::)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.