I will explain myself a bit more: I wrote my own session handler function so I could use session files. I have been able to specify a directory for session files as well as their life expectancy is +- 90 minutes, not to exceed 99 minutes from inactivity. My purpose in setting auto_increment back to 1 is that I won't exceed the auto_increment maximum integer value and that the table is maintenance free when I am able to get this working with a cron. I have noticed that when putting a script onto a cron sometimes requires minor tweaking from how it runs when called on the web. I am able to change the value to 1 using the original syntax I posted to the list --- not with the cron. I changed AUTO_INCREMENT to be in capital letters and will see if this works tomorrow when the cron runs. I have been using the session_regenerate_id(); command to keep the logins secure with session variables controlling which account is being accessed. There are a few other things running in the background to help protect the sessions. It is feasible that when a user accessed their account they use 10 to 15 entries in the mySQL table. I just want to keep bringing the auto_increment field back to 1 because of this. Am I making sense? I am trying to get ready for a marketing campaign for a home based business I have started so I may eventually quit my day job do when I have a passion for (caring for people.) Ron On Tue, 2007-04-17 at 08:20 -0400, Michael Keyser wrote: > You could also use phpMyAdmin if no one else has mentioned it. It's > pretty simplistic and is a collaboration of PHP scripts specifically for > maintaining MySQL databases. I think you should check it out: > > http://www.phpmyadmin.net > > -----Original Message----- > From: Buesching, Logan J [mailto:ljbuesch@xxxxxxxxxx] > Sent: Tuesday, April 17, 2007 8:17 AM > To: ron.php@xxxxxxxxxxxxxxxxxx; PHP DB > Subject: 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 (such as > table names). > > 2.) Make sure you have satisfied the following (From the MySQL manual): > -- > You cannot reset the counter to a value less than or equal to any that > have already been used. For MyISAM, if the value is less than or equal > to the maximum value currently in the AUTO_INCREMENT column, the value > is reset to the current maximum plus one. For InnoDB, you can use ALTER > TABLE ... AUTO_INCREMENT = value as of MySQL 5.0.3, but if the value is > less than the current maximum value in the column, no error message is > given and the current sequence value is not changed. > -- > > If neither of these help, the actual error message may be of use. > > -Logan > > -----Original Message----- > From: Ron Piggott [mailto:ron.php@xxxxxxxxxxxxxxxxxx] > Sent: Friday, April 13, 2007 10:04 PM > To: PHP DB > Subject: auto_increment > > 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(); >
