Re: walking through database one record at a time with form s.
| From: | Curt Zirzow | Date: | Wed, 23 Jul 2003 16:33:34 +0000 |
| Subject: | Re: walking through database one record at a time with form s. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-156483@lists.php.net to get a copy of this message | ||
* Thus wrote Luis Lebron (llebron@sigmatech.com):
> The trick is in using the MySQL 0limit statement.
>
> For the first record use:
>
> $sql = mysql_query("SELECT * FROM temp_table limit 0, 1");
>
> then increment the limit for the next record
>
> $sql = mysql_query("SELECT * FROM temp_table limit 1, 1");
of course if the ACCEPT and REJECT actions actually delete it he could
just use:
SELECT * FROM temp_table limit 1
But this is Off-Topic, so ignore what I just said...
Curt
--
"I used to think I was indecisive, but now I'm not so sure."