It seems you want something like
select * from table
limit 1,1
for the first query and then...
select * from table
limit 2,1
You might also want to add "order by" as well to assure the proper order
each query.
HTH,
Ron
[EMAIL PROTECTED] wrote:
> Now Ben did simplify the problem correctly as well I think:
> - Run program, fetches a name. Processes and exits.
> - Run program again, same SQL but gets the NEXT name. Processes and exits.
>
> Thanks,
> Sam D
---------------------------------------------------------------------
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
