[PHP-DB] Re: Auto Increment Problems....

2002-07-30 Thread Joel Boonstra
[straying OT, but...] Instead of incrementing to find the next row to count them, you dont have to set the ID if it is auto increment. MySQL will do it for you (and i think it might fill the holes too). Also, to get the num. of rows just do this - $get_rows = mysql_query(SELECT * FROM

[PHP-DB] Re: Auto Increment Problems....

2002-07-29 Thread Adam Royle
Firstly, don't cross post unless the question *really* has to do with both (in this case, it should be just db). Secondly, your id field should only be used as a reference to a row (not showing order of record). Auto increments are exactly that, the rdbms will take care of creating the