Hi, Newbie here so please bear with me. I am running MySQL 3.23.22 with PHP4.01 on WinNT client / Linux host, everything is working okay and I'm just getting to grips with some basic database handling. Although I can use mysql_query to get a list of records using "Select * from `mydata`" - for what we are looknig at, we also need a basic Next/Prev stepping capability on a record per record basis. I realise this can be done just grabbing all records and then moving through the rows, but we are also looknig at picking up each record individually. I have had some success using "count(*)" to get the last record, then stepping through with "limit $x,1" in the select, where $x is decremented / incremented based on which button is pressed. I cannot seem to find any simply "read next" or "read previous" type command though. Is the way I am going about it "right" or is there a more simple/logical method? My main concern is that, with the key being auto-increment, as records are added and removed from the database, as simple +1/-1 may fall over. -Colin
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
