On Sun, 5 Sep 2004, Pete Holsberg wrote:

> Well, I have this:
> $result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum ASC');
> while ($row=mysql_fetch_assoc($result))
> { 
>    echo $row['lastname'].' '.$row['firstname'].' '.$row['housenum'].' 
> '.$row['street'];
> }
> and I get "Warning: mysql_fetch_assoc(): supplied
> argument is not a valid MySQL result resource in
> /home/.fanny/pjh/4seasonsatmapleton.org/4sam/directory/showForm-mod.php
> on line 26"
> Line 26 is the while statement.
> ????

<blush> I have to learn to keep a 3x5 card with my column
headings nearby!!

But having corrected that, I'm running into another

I added:

if (!$result) {
   echo "Could not successfully run query ($sql) from DB: ". mysql_error();

if (mysql_num_rows($result) == 0) {
   echo "No rows found, nothing to print so am exiting";

And they output nothing nowm so I assume that there are
things to print. But the "while" statement produces nothing

Also, I think I misunderstood something someone saod
earlier.  Is it true that the above mysql_query call does
not change the way the database is stored by simply sorts
the copy that's in memory?


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to