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:[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 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();
>