RE: [PHP-DB] RE: auto_increment

2007-04-17 Thread Ron Piggott
; From: Buesching, Logan J [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 17, 2007 8:17 AM > To: [EMAIL PROTECTED]; PHP DB > Subject: [PHP-DB] RE: auto_increment > > One of two things comes to my mind: > > 1.) auto_increment *might* have to be AUTO_INCREMENT, as that is ho

[PHP-DB] RE: auto_increment

2007-04-16 Thread Buesching, Logan J
One of two things comes to my mind: 1.) auto_increment *might* have to be AUTO_INCREMENT, as that is how the manual states it and *some* things in MySQL are case-sensitive (such as table names). 2.) Make sure you have satisfied the following (From the MySQL manual): -- You cannot reset the counte

[PHP-DB] Re: auto_increment

2007-04-14 Thread David Robley
Ron Piggott wrote: > Does anyone see anything wrong with the $query syntax? Ron > > mysql_connect(localhost,$username,$password); > @mysql_select_db($database) or die( "Unable to select database"); > $query="ALTER TABLE sessions auto_increment = '1'"; > mysql_query($query); > mysql_close(); The