If you're using MySQL, change to this:
staffid int(3) unsigned not null auto_increment,
The order of the attribute description is important in MySQL.
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 6:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] CR
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 si
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] wrot
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,
-- created
I have had similar problems before. I have just created your table in
MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED.
Doesn't mention this in the manual though.
Neil Morgan
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 22:34
To: [EMA
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: www.amazon.c
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 su
