Actually, it's more of an order problem:
I fixed the SQL already.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 4:47 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] CREATE TABLE problem
I have had similar
] CREATE TABLE problem
ok im making this page and every single time i try to execute it, it
tells me it was not successful. the database name, user,pw,and local
host are all correct. i have no idea what do do, and i have 2 more
tables besides this one i wanted to create but this was kind of my
To: [EMAIL PROTECTED]
Subject: [PHP-DB] CREATE TABLE problem
ok im making this page and every single time i try to execute it, it tells
me it was not successful. the database name, user,pw,and local host are all
correct. i have no idea what do do, and i have 2 more tables besides this
one i wanted
Regarding...
-- $query = CREATE TABLE staff (
-- staffid INT(3) NOT NULL AUTO_INCREMENT UNSIGNED,
-- name VARCHAR(255) NOT NULL,
-- login VARCHAR(10) NOT NULL,
-- password VARCHAR(8) NOT NULL,
-- picaddy VARCHAR(255) NOT NULL,
-- email VARCHAR(255) NOT NULL,
-- staffbio TEXT NOT NULL,
--
hmm ... I have unsigned auto_increment fields in all my tables that use
unique field IDs...
But i use very long counter fields as it's pretty big tables I have (or
gonna be once I get them finished)...
FWIW
Rene
Fate would have it, that on Thu, 22 Jan 2004 08:47:01 -,
[EMAIL PROTECTED]
ok im making this page and every single time i try to execute it, it tells me it was
not successful. the database name, user,pw,and local host are all correct. i have no
idea what do do, and i have 2 more tables besides this one i wanted to create but this
was kind of my template for it and i
mysql_db_query ($dbname,$query,$link) or die(myself_error());
will help you more than your if/then statement.. change that, and check out
the error message.
On Wed January 21 2004 2:33 pm, js wrote:
ok im making this page and every single time i try to execute it, it tells
me it was not
ok i did the mysql_error DIE thing, and now it tells me this:
You have an error in your SQL syntax near 'UNSIGNED, name VARCHAR(255) NOT NULL, login
VARCHAR(10) NOT NULL, password' at line 2
i have no idea what it means. i dont think any of those are taken or reserved by PHP
or mySQL. any
js wrote:
You have an error in your SQL syntax near 'UNSIGNED,
name VARCHAR(255) NOT NULL, login VARCHAR(10) NOT NULL,
password' at line 2
Print (echo) out your entire query. You have a syntax error before the
point the error message mentions.
--
---John Holmes...
Amazon Wishlist: