note 35763 deleted from function.mysql-result by aidan
| From: | aidan@php.net | Date: | Fri, 09 Sep 2005 08:41:51 +0000 |
| Subject: | note 35763 deleted from function.mysql-result by aidan | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-94953@lists.php.net to get a copy of this message | ||
Note Submitter: till at klimpong dot com
----
I frequently use mysql_result() together with mysql_fetch_array(), kinda like that... :-)
<?
$query="SELECT id, name, something_else FROM table";
$rawdb=mysql_query($query);
?>
<table>
<tr><td><?=mysql_result($rawdb, 0, "name")?></td></tr>
<?
mysql_data_seek($rawdb, 0);
while($array=mysql_fetch_array($rawdb, MYSQL_ASSOC)){
extract($array);
?>
<tr><td><?=$id?></td><td><?=$something_else?></td></tr>
<?
}
mysql_free_result($rawdb);
?>
</table>
Took me a while to figure out what to do with mysql_data_seek when you are using mysql_result and
mysql_fetch_array on the same query. Hope it helps someone else. :-)