Re: Array?
| From: | Joao Prado Maia | Date: | Fri, 06 Oct 2000 19:23:02 +0000 |
| Subject: | Re: Array? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-18963@lists.php.net to get a copy of this message | ||
On Fri, 6 Oct 2000, Wee Chua wrote:
> Hi all,
> I am newbie to PHP. How could call each field out manully from this array?
> Thanks in advance for any helps!
>
> $result = @mysql_query("Select * from
> Project,ProjType,Company,Event,EventType",$db);
> for ($i=0;$i<mysql_num_fields($result);$i++) {
>
> $field = mysql_field_name($result,$i);
>
<?php
// sweet code to dynamically get all values from all fields
// and create dynamic variables with their names
$sql = "SELECT * FROM Project";
$result = @mysql_query($sql, $db);
$rows = @mysql_num_rows($result);
for ($i = 0; $i < $rows; $i++) {
$fields = mysql_num_fields($result);
for ($y = 0; $y < $fields; $y++) {
$field_name = mysql_field_name($result, $y);
$$field_name = mysql_result($result, $i, $y);
}
}
?>
Thats sweet ;)
Joao
--
Joao Prado Maia
Web Developer
Kefta, Inc.
T: (415) 391-6881 ext 8008
F: (415) 391-7079