function help needed

[rajveer]

Hello Friends I need help in one function

i want to get user info via id with function

example first if i need just username i have to do is

function username($id)
{
$query = mysql_fetch_array(mysql_query("SELECT username FROM members WHERE id = '$id' ");
$username = $query[0];
}

$user_name = username($id);
echo 'hello $user_name'; 

but i want to get multiple queries from it

function userinfo($id)
{
$query = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE id = '$id' ");

} 

i want to di is get array from that function and show it like if username then select username query via function n show it then show gender and other stuff how will that work please help me ??

[rajveer]

No one to help ???

[just_m3.]

<?php

function userinfo($id,$param)
{

$query = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE id = '$id' ");

return $query[''.$param.''];

}  

// print gender , id , name etc 
echo userinfo($id,'gender');

echo userinfo($id,'name');

echo userinfo($id,'id');

?>

[rajveer]

Wow thanks just_m3 it worked thank you save alot my time