RE: [PHP-DB] RE: auto_increment

2007-04-17 Thread Ron Piggott
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 how the manual states it and *some* things in MySQL are case-sensitive

[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

[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 value