varibles and globals

NoRp

ok so heres my function without globals and such

function userinfo($tot){ 
require 'database  connection';
$query = "SELECT * FROM  database name WHERE  id = '$tot'";
$result = mysql_query($query) or die("Invalid query:" .mysql_error() );
$i = 0;
$name =mysql_result($result,$i,"name");
$id =mysql_result($result,$i,"id");

;}

and i want to call it like so

				userinfo($captid);
				echo"$name<br>";
				unset($name);
				userinfo($ply2id);
				echo"$name<br>";

nows where the fun part comes
ive tried setting the $name and $id to globals and inside the global array
the problem allways arises when i try to unset it and then call the function the 2nd time

any ideas?
when u answer please bare in mind that the function wil be used 10 times or more thanks in avance

/edit i also dont want to do it all in one function as i have meny more things to do with the function and global and i would like to know how to use it correctly

--NoRp

tunage

You could use [MAN]mysql_fetch_array[/MAN] to return an array of the result from the userinfo function.

$result = userinfo($captid); 

echo $result['name'];

Weedpacket

A bit of simplification:

require_once 'database  connection';

function userinfo($tot){ 
$query = "SELECT name FROM  database name WHERE  id = '$tot'";
$result = mysql_query($query) or die("Invalid query:" .mysql_error() );
return mysql_result($result,0);
}

Why bother selecting or returning the ID? You already know the ID.
Don't select more than you have to.
Use the return statement to return information from a function.
If you do want to select (and return) more than one item, you could return an entire array as tunage suggested.

NoRp

thanks for your help

and yeah that works how ever i have multiple tasks simlar to this that i need to reproduce and i would like to do it a simlar way to how i have shown it above if any knows of a way i com produce this pls rply
and thanks again