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 
Messages posted by: j4ymf
Forum Index » Profile for j4ymf » Messages posted by j4ymf
Author Message
please look at my problem

http://proxy2.de/forum/viewtopic.php?t=2248
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 » Profile for j4ymf » Messages posted by j4ymf
Go to:   
Based on the open source JForum