https://proxy2.de/forum/posts/list/2.php JForum - http://www.jforum.net
could some one please post the code to the bit where it says how many entrys there are in the guestbook ie:

[quote]Wednesday, 13. August 2003 01:33
Thank you for stopping by my site. Here you can leave your mark. Guestbook
[u][b]Total Records: 5[/b][/u] Records Viewed Per Page: 10

what i mean is i tried to use:
SELECT `id`
FROM `book_data`
WHERE 1
ORDER BY `id` DESC LIMIT 1

but my problem is i have deleted a few entrys from my guestbook and my id should be 4 but it reads 17?????

id
17
4
3
2
1


how do i change the autoincroment bit: where it says the next one is 18?


[/quote]Statements Value
Format dynamic
Rows 5
Row length ø 248
Row size ø 658 Bytes
Next Autoindex 18
Creation Aug 13, 2003 at 01:27 AM
Last update Aug 13, 2003 at 01:27 AM


please help
thanks jason

please email me with any ideas jason-fletcher@ntlworld.com]]> https://proxy2.de/forum/posts/preList/2248/5844.php https://proxy2.de/forum/posts/preList/2248/5844.php GMT