Function headache, can't run more than once?

[darthmahon]

Hey,

Trying to run the following function in a while statement:

function func_userinfo($user) {

$userinfo = func_query_first("SELECT fld_name FROM tbl_users WHERE fld_id = $user");

$fld_name_output = $userinfo["fld_name"];

echo $fld_name_output;

}

This is the snippet of code that shows the while statement. I have another function called db_fetch_array in there.

while($row = db_fetch_array($result)) // print results

	{

	?>

		<p><strong>Added by</strong> <? func_userinfo($row['fld_id']); ?> <strong>on</strong> <? echo $row['fld_date']; ?> <strong>at</strong> <? echo $row['fld_time']; ?></p>
		<p><? echo nl2br($row['fld_text']); ?></p>
		<hr>
	<?

	} // end " while($row = mysql_fetch_array($result)) "

Now, the first entry outputs the correct name, but the second displays nothing.

Any ideas, driving me mental.

Cheers,
Chris

[weekender]

try putting some error checking echo's in your func_query_first function

also, your db_fetch_array function looks just like [man]mysql_fetch_assoc[/man] - you're using it in exactly the same way

[darthmahon]

Hey,

Sorted it, was calling the wrong field in the select. Doh!:o

Is it a bad thing that the function does the same thing as mysql_fetch_assoc? I thought mysql_fetch_array also did something very similar?

What's the difference between arrary and assoc?

Cheers,
Chris

[laserlight]

mysql_fetch_array() combines mysql_fetch_assoc() and mysql_fetch_row()

If there's a PHP function available, unless you're writing some sort of abstraction layer, just use the PHP function.