* Thus wrote Ross Hulford:
> My page displays the first result and then I get the following
> error.................
>
> Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource in
> c:\inetpub\wwwroot\testy\Untitled-1.php on line 29
>
>
>
> Please help.
>
> R.
>
>
> my code.............
>
>
> ...
>
> $Recordset1 = mysql_query($query_limit_Recordset1, $ross) or
> die(mysql_error());
> ...
>
> mysql_free_result($Recordset1);
You are freeing $Recordset1, thus making it useless.
> ?>
> <?php echo $totalRows_Recordset1 ?>
> <?php do { ?>
> <p><?php echo $row_Recordset1['location_name']; ?></p>
> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
Curt
--
Quoth the Raven, "Nevermore."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
