question about getting query elements.

[onedumbcoder]

if i have

$result = mysql_query("...")

 

and i keep doing

 

$list = mysql_fetch_array($result );

echo $list['name']

 

$list = mysql_fetch_array($result );

echo $list['name']

 

$list = mysql_fetch_array($result );

echo $list['name']

 

what will happen if there is no more elements left? will it through an exception?

 

and is there a way to check if there is any more elements left

 

for example

 

if(mysql_has_next($result))

 

 

[soycharliente]

Use a while loop. It will automatically stop processing once the elements run out.

 

From the manual:

array mysql_fetch_array  ( resource $result  [, int $result_type  ] )

Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

It knows.

 

<?php
$result = mysql_query("...");
if (mysql_num_rows($result) > 0)
{
while ($list = mysql_fetch_array($result))
{
	echo $list['name'];
}
}
?>

[onedumbcoder]

i cant use a while loop for what i need it for, i need to iterate through it manually.

 

[jonaHill87]

what exactly are you trying to do? find a specific value or echo all of the values in the array?

[soycharliente]

i cant use a while loop for what i need it for, i need to iterate through it manually.

Can you explain a bit more of what you're trying to do?