Re: [PHP] auto_increment $value

2003-03-10 Thread John Taylor-Johnston
Sounds better. Thanks Jimmy Brake wrote: > hmm > > > i could be misunderstanding but > > select max(your_autoincrment_column) from your_table -- John Taylor-Johnston - "If it's not open-source, it's Murphy's Law." ' '

RE: [PHP] auto_increment $value

2003-03-10 Thread Michael Roger C. Bianan
10, 2003 1:41 PM To: Eddie Lien Cc: [EMAIL PROTECTED] Subject: Re: [PHP] auto_increment $value Necessary, or at least cleaner, if there are less than 5 records in your database. > Why don't you just use "select * from table order by id DESC limit 0,5"? > > I

Re: [PHP] auto_increment $value

2003-03-10 Thread John Taylor-Johnston
Necessary, or at least cleaner, if there are less than 5 records in your database. > Why don't you just use "select * from table order by id DESC limit 0,5"? > > I don't see any necessary to get the auto_increment value. > > Anyone know how to get the auto_increment $value out of a mysql table.

Re: [PHP] auto_increment $value

2003-03-09 Thread John Taylor-Johnston
I'll have a look at that too. Thanks! What do you make of this: My browser is all snuffed up! It dodnint wwork aniwore! http://ccl.flsh.usherbrooke.ca/tools/ Choose Greid. Works ok. Choose JDaxell and the stops working after 184. Even with: Too much HTML or too much in one . I'll have to ge

Re: [PHP] auto_increment $value

2003-03-09 Thread John Taylor-Johnston
$news = mysql_query("SHOW TABLE STATUS FROM ".$db2." LIKE '$table2'"); while ($table_status = mysql_fetch_array($news)) { $autoindex = $table_status['Auto_increment']; } Got it. Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

Re: [PHP] auto_increment $value

2003-03-09 Thread - Edwin
Hello, John Taylor-Johnston <[EMAIL PROTECTED]> wrote: > Anyone know how to get the auto_increment $value out of a mysql > table. > I'm thinking it is in mysql_fetch_array but don't see how to > get it. What do you exactly mean by "get the auto_increment $value"? Perhaps, you're looking for t