Foreach for iterating mysql result, or other alternatives

[wepnop]

Now i use a very complex normal for, how i can use a foreach?

[Muddy_Funster]

could you try again, and maybe give us some more info?  What do you want to do?

[wepnop]

could you try again, and maybe give us some more info?  What do you want to do?

 

Mmm, i you dont need more info, i think. I just want to iterate a mysql result in a foreach, or in a batter way than this:

 

	# Itera en totes les ciutats
for ($i=0; $i<=mysql_num_rows($result)-1; $i++) {
	$object = mysql_fetch_object($result);

	if (mysql_num_rows($result)-1 == $i)	{

		break;
	}

	mysql_data_seek($result, $i+1);

}	

[Muddy_Funster]

while ($row = mysql_fetch_assoc($result)){
//do what you want for each row returned
}

is the normal way of doing this, so long as by iterate you are reffering to running through the returned result set from the query, and not to repeating the query it's self to obtain a specific result set.  You see, it's still a bit ambiguous.

[wepnop]

while ($row = mysql_fetch_assoc($result)){
//do what you want for each row returned
}

is the normal way of doing this, so long as by iterate you are reffering to running through the returned result set from the query, and not to repeating the query it's self to obtain a specific result set.  You see, it's still a bit ambiguous.

 

Thats what i want. That and the way of use foreach for the same task.

[PFMaBiSmAd]

Sorry to jump in, but I'm glad you finally shared what you are doing, because the code you are using now is very very inefficient -

 

1) It is re-evaluating mysql_num_rows() every pass through the for() statement,

 

2) It is re-evaluating mysql_num_rows() inside the loop to break from the loop, but that is pointless because that is what the loop is already doing,

 

3) It is using mysql_data_seek() inside the loop, but that is pointless because mysql_fetch_object() advances the result pointer.

 

You can replace all that with the following that just about every php/mysql book or tutorial would have shown -

 

while($object = mysql_fetch_object($result)){

}

[wepnop]

Sorry to jump in, but I'm glad you finally shared what you are doing, because the code you are using now is very very inefficient -

 

1) It is re-evaluating mysql_num_rows() every pass through the for() statement,

 

2) It is re-evaluating mysql_num_rows() inside the loop to break from the loop, but that is pointless because that is what the loop is already doing,

 

3) It is using mysql_data_seek() inside the loop, but that is pointless because mysql_fetch_object() advances the result pointer.

 

You can replace all that with the following that just about every php/mysql book or tutorial would have shown -

 

while($object = mysql_fetch_object($result)){

}

 

I learned that way in a host that haved a very old PHP, at minium php4. And as far i know, removing  data seek, etc, make break the all thing. 

 

Anyway i will use the while or the foreach, if exist.

[wepnop]

any ideas for using the forech?

[Muddy_Funster]

kind of - but it's non-standard practice, and you would need to be barking to use it in a normal scenrio.

$result_set = array();

$resultset = mysql_fetch_assoc($result);

foreach ($result_set as $field => $value){

//do what you want to do

}

using this kind of loop here is so bizzare I don't even know if that will actualy work

[PFMaBiSmAd]

There's no way to use a foreach() loop because a foreach() loop iterates over an array. Queries don't return an array, they return a result resource that must be accessed using mysql_fetch_xxxxx() or mysql_result() statements.