Help on Varible Scope

[Anon]

Hi, thanks to mrmufin, I have manage to read multiple field from the database. But I've now got a new problem. Problem is that in the following code:
$temp = mysql_query("SELECT * FROM news ORDER BY date DESC LIMIT 3");
for($i = 0; $i < 3; $i++) {
while($result[$i] = mysql_fetch_array($temp)) {
$news[$i]["id"] = $result[$i]["id"];
$news[$i]["name"] = $result[$i]["name"];
$news[$i]["author"] = $result[$i]["author"];
$news[$i]["content"] = $result[$i]["content"];
$news[$i]["date"] = strftime("%A %d/%m/%y", $result[$i]["date"]);
}
}
the variable $i in the while statement returns 0 and $i in the for statement (and not in the while statement) returns the correct number. Why is this?

Regards,

Takuma Habu

[waldo]

Hi,
try a few things...
place an $i = 0;
prior to the for statement...

the other thing is to change the for loop to another while loop
$i = 0;
while( $i < 3 ) {
.
.
.
$i++;
}

Joe

[Anon]

A rewrite:

$i=0;
while($result = mysql_fetch_array($temp)) {
$news[$i]["id"] = $result["id"];
$news[$i]["name"] = $result["name"];
$news[$i]["author"] = $result["author"];
$news[$i]["content"] = $result["content"];
$news[$i]["date"] = strftime("%A %d/%m/%y", $result["date"]);
$i++;
}

Your while statement will loop throught the $temp result for all the results three times in your code.