i would like to be able to use a bit from the main admin page,
could some one please post the code to the bit where it says how many entrys there are in the guestbook ie:
Wednesday, 13. August 2003 01:33
Thank you for stopping by my site. Here you can leave your mark. Guestbook
Total Records: 5 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?
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