RE: [PHP-DB] CREATE TABLE problem
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] 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 template for it and i cant even get it to work. im still really bad with this kind of stuff so any help i could get from you is really appreciated. thanks. here is the code: Untitled Document -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] CREATE TABLE problem
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 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: [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 to create but this was kind of my template for it and i cant even get it to work. im still really bad with this kind of stuff so any help i could get from you is really appreciated. thanks. here is the code: Untitled Document -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php