Re: Using the same result set twice
| From: | Daniel Convissor | Date: | Tue, 21 Nov 2000 16:59:58 +0000 |
| Subject: | Re: Using the same result set twice | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-26473@lists.php.net to get a copy of this message | ||
Hey Chris:
Chris Lott wrote:
>
> I have a page where at the top I need to display results from a query, then
> further down I need to use the results again. Why can I only seem to "use"
> the result set once?
The result index pointer is set to the last record because you looped through
it. Before you want to use the results again, you need to set the index
pointer to the beginning. Do so like this:
mysql_data_seek($subcats,0);
Enjoy,
--Dan
--
PHP scripts that make your job easier
http://www.analysisandsolutions.com/code/
SQL Solution | Layout Solution | Form Solution
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409