Re: start over on database read inorder to read from the beggining again
| From: | Jason Wong | Date: | Tue, 14 Aug 2001 04:39:50 +0000 |
| Subject: | Re: start over on database read inorder to read from the beggining again | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11322@lists.php.net to get a copy of this message | ||
> How can I run through a database like I am trying to do here? It seems
like
> at the end of the first I need to start over in order to start reading
from
> the beggining of the database on the second.
> I hope that I hace explained my problem well if not please reply with your
> questions. Thank you in advance.
>
> Caleb
> <!--Snip-->
> $connect = mysql_connect("$host","$user","$pass") OR
> (die("mysql_error"));
> $selectdb = mysql_select_db("$db") OR (die("mysql_error"));
> $result = mysql_query("SELECT * FROM teams where week='$list' ORDER BY
date");
> while($view = mysql_fetch_row($result))
> {
> code;
> }
> more code;
> and <html>
> while($view = mysql_fetch_row($result))
> {
> code;
> }
try adding:
mysql_data_seek($result, 0);
before your second loop. This should reset your dataset so you can loop
again.
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk