> How can I run through a database like I am trying to do here?  It seems
> at the end of the first I need to start over in order to start reading
> 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
>         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

Jason Wong
Gremlins Associates

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to