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

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.)


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:[EMAIL PROTECTED] 
> Sent: Tuesday, April 17, 2007 8:17 AM
> 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 (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:[EMAIL PROTECTED] 
> 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();

Reply via email to