Show us you table data
Show your PHP code as well
-Original Message-
From: Justin Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:06 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] multiple entries in database
I have worked my problem down to the mysql database.
I have a table like so:
Field
Type
Attributes
Null
Default
Extra
username
varchar(16)
No
commID
int(9)
No
auto_increment
commState
char(2)
No
commCity
varchar(25)
No
commZip
int(5)
No
0
commName
varchar(255)
No
commID is primaryKey.
when I do an insert to this table without giving the ID a value inside
the insert statement it duplicates the entry or increments another blank
entry.
the insert statement is not in a loop or recursive function.
I have found out that if I take out the auto_increment that it adds it
just fine if the ID value is added to the statement..without the ID
value it enters the ID as '0'.
I have another insert statement with another table that is doing the
exact same thing.
I'm kinda new and kinda not..so..any help is appreciated..
Justin Hall
JD Media
www.jdmedia.net
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php