note 42993 deleted from function.mysql-fetch-assoc by tomsommer
| From: | tomsommer@php.net | Date: | Tue, 06 Jul 2004 09:28:05 +0000 |
| Subject: | note 42993 deleted from function.mysql-fetch-assoc by tomsommer | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-72737@lists.php.net to get a copy of this message | ||
Note Submitter: Artem (E-dima.net)
----
The best way to get results with mysql_fetch_assoc is this:
$result=mysql_query("select field_id, field_name from table order by field_id");
while ($data=mysql_fetch_assoc($result)) {
while (list($key, $value)=each($data))
$$key=$value;
echo $field_id." - ".$field_name;
}