Use database query result twice

[jdurand]

I was wondering if it is possible to use the same query result twice as I am having problems with this.
Lets say I run this query:

$sql = "SELECT user_name,ID FROM users
WHERE show_admin = 1 ORDER BY user_name ";
$solicitor = mysql_query($sql);

Then lets say I run this function inside a form to populate a dropdown box.

function showClients($solicitor) {

while ($row = mysql_fetch_array($solicitor, MYSQL_ASSOC)) {

print "<option value= '$row[ID]'>$row[location]<br>\n";
}
}

If I then try and use the $solicitor result set again in another function

function legalstream($solicitor) {
$client_index = 0 ;
	while ($row = mysql_fetch_array($solicitor, MYSQL_ASSOC)) {	
	if ($row[user_name] == "LEGALSTREAM") {
		$legalstream = $client_index + 1 ;
	return $legalstream ;
	}
$client_index = $client_index + 1 ;
}
}

I get the mysql_fetch_array(): supplied argument is not a valid MySQL result resource error.

Everything works fine if I run the query twice and use different result names for each function

Thanks
Jm Durand

[rincewind456]

Take a look at [man]reset/man, you need to reset the array pointer to the start of the array.

[jdurand]

this function works fine until I put in the reset

function showClients($solicitors) {
	while ($row = mysql_fetch_array($solicitors, MYSQL_ASSOC)) {
	print "<option value= '$row[ID]'>$row[user_name]<br>\n";
}
reset ($solicitors) ;
}

Warning reset(): Passed variable is not an array or object
I even tried changing the argument name.
I can run the follwing function as many times as I like

function westside($location) {
                $west_index = 0 ;
	while ($row = mysql_fetch_array($location, MYSQL_ASSOC)) {
	if ($row[location] == "WESTSIDE") {
		$westside = $client_index + 1 ;
	return $westside ;
	}
                $client_index = $client_index + 1 ;
}
}

As long as I don't run this one first

function showLocation($location) {

while ($row = mysql_fetch_array($location, MYSQL_ASSOC)) {

print "<option value= '$row[ID]'>$row[location]<br>\n";
}
}

Hmmmm?

[Installer]

mysql_data_seek()