If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
just a quick question  XML
Forum Index » General Discussion
Author Message
j4ymf
Newbie

Joined: 13/08/2003 02:35:33
Messages: 2
Offline

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
 
Forum Index » General Discussion
Go to:   
Based on the open source JForum