|  | Posted by -Lost on 06/13/95 11:53 
"ClickToWalk" <admin@clicktowalk.com> wrote in message news:44bfb933$1_4@mk-nntp-2.news.uk.tiscali.com...
 
 > This is a bit of code that I have used to successfully echo all the available records -
 > with gaps where records are missing - but what modifications do I need to make to it so
 > that only one row is returned from the recordset, determined by $id.
 
 You could throw an if clause in checking the number of rows returned (mysql_num_rows) or
 even possibly check with mysql_affected_rows (assuming an INSERT, DELETE, or UPDATE).
 
 You could also LIMIT your results and output those three rows [previous, current, next].
 
 Lastly, your query function could do the same as the above, but then also check to see if
 they are valid results.  This you could add to your existing code...
 
 -Lost
  Navigation: [Reply to this message] |