Returning variables

[johnslater]

I have a function which is out-putting information from a MySQL my MySQL query has a while loop which is where my problem seems to be.

 

I want to pass the value of a variable out of the while loop and also out of the function to the main script. How is this done?

[pocobueno1388]

Can you post your code? Sounds like you need to use the return keyword.

[johnslater]

// Is there a user cookie set?
function cookie()
{
if (isset($_COOKIE["userlogin"]))
{
$cookie_acti = $_COOKIE["userlogin"];

$result = mysql_query("SELECT * FROM users WHERE activationid='$cookie_acti'");
while($row = mysql_fetch_array($result))
{
$cookie_username = $row['username'];
$cookie_fname = $row['fname'];
$cookie_lname = $row['lname'];

return $cookie_username;
return $cookie_fname;
return $cookie_lname;
}
}

else
{
$cookie_username = "Guest";
$cookie_fname = "Guest";
$cookie_lname = "";
}

} // End cookie function

cookie();

 

I have once used a different method to get 1 item from a database but i dont seem to be able to find it, if you could post another emthod that you think may fix the while loop then that would be great

[Stooney]

in your script:

$variable=cookie();

$variable will get the value of the variable you're returning in the function.

 

at the end of your function

return $variable;  //change $variable to what you want to return to the main script.

 

 

[johnslater]

It looks like that has fixed my problem. thanks for your help :-)

[johnslater]

Is there anyway i can set up all of these varibles then just call them as normal like $cookie_username

 

I currently have this...

$cookie_fname = $cookie_fname=cookie();
$cookie_lname = $cookie_lname=cookie();
$cookie_username = $cookie_username=cookie();
$cookie_set = $cookie_set=cookie();

 

But for some reason the top one cancels out all of the others

[johnslater]

After slightly more testing and after putting this at the end of my function like you suggested it appear it only works with one value however i need to call several values from the same function.

 

return $cookie_username;

return $cookie_fname;

return $cookie_lname;

return $cookie_set;

 

Only the top one (username) is being used and no matter which value i try to call it always calls username

[Stooney]

You can only return one variable with return.  Your best bet would be to return an array containing all of the data you need.