WampServer

I have around 525 books in my library database. When i delete say bookid 5, it screws up the records of the books number that shows below the table.

for example -
1,2,3,4 5(deleted)6,7,8,9,10 becomes
1,2,3,4, 6,7,8,9,10. So the tally shows i have records 1-10 instead of 1-9 on that page.

When i create a new record It creates a new ID but its like not right after 10 or so and its more like 12 and goes on 13,14,15..



Post Edited (01-15-07 20:30)

I don't see anything wrong here because you implemented your code as ID and ID never change, and I think you mean the counter number; in that case, you should change your code as well as db setup. If you just want to know the total records, you might want to use the count() function instead.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)