Thanks, Mark, for the syntax. I had actually played around enough to
figure it out already and got it to work the way that I wanted to. I
guess when I asked the question, I wasn't fully aware of what I was
wanting. The LAST_INSERT_ID wasn't a major issue. I ended up using the
following code:
$new_increment = date('Ym') * 10000 + 1;
$query = mysql_query( "ALTER TABLE `$calls` AUTO_INCREMENT =
$new_increment" );
if ( !$query ) {
die( "Couldn't Alter Table!" );
}
else {
echo "Successfully updated AUTO_INCREMENT: $new_increment\n";
}
After a few tests, it seems to be working properly. I've gone ahead and
setup a cron job to take care of this once a month.
Thanks again,
Jason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
