RE: [PHP-DB] Re: Newbie Questions
| From: | Pete Holsberg | Date: | Sun, 05 Sep 2004 22:27:27 +0000 |
| Subject: | RE: [PHP-DB] Re: Newbie Questions | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36059@lists.php.net to get a copy of this message | ||
On Thu, 2 Sep 2004, Torsten Roehr wrote:
>
> mysql_query() will return a result set. There are
> different functions to extract the rows from it. I
> would recommend mysql_fetch_assoc() - it returns an
> associative array of the current row/record set where
> the field names of your table become the keys of the
> array. So if you select firstname, lastname you will
> get an array like this:
>
> array('firstname' => 'My firstname', 'lastname' => 'My
> lastname')
>
> Just loop through your result set to output/process
> the data. Try this:
>
> $result = mysql_query('SELECT firstname, lastname FROM table');
>
> while ($row = mysql_fetch_assoc($result)) {
>
> echo $row['firstname'] . ' ' . $row['lastname'];
> }
Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY surname, street, housenumber ASC');
while ($row=mysql_fetch_assoc($result))
{
echo $row['surname'].' '.$row['firstname'].'
'.$row['housenumber'].' '.$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.
????
Thanks.