RE: [PHP] Auto Increment Problems....

-Original Message- >From: Georgie Casey [mailto:[EMAIL PROTECTED]] >Apart from this looking ugly, it poses another problem. In my PHP script >where I can add new rows, I query the table, checking how many rows in the >table altogether and set the new id as the next number, but this doesnt

[PHP] Auto Increment Problems....

rite, my primary key column ("id") is set to auto_increment as usual which is very handy. But when I delete a row, the auto_increment just keeps incrementing and there's this 'hole' left where I deleted the row! Apart from this looking ugly, it poses another problem. In my PHP script where I can