returning values from a function

ajna

I am totally lost. My head is spinning from reading about returning arrays and I just don't get it.

I call a function from my php page, in that function I need to get 4 different pieces of information and return them to the page that called the function. How do I get them and call them from the function?

So far the function works like this (I've hacked out a bunch of "do this" stuff):

function Inwork($userid) { // BEGIN KEEP ONLINE ROUTINE

$sql = "select * from table where FIELD = '$userid')";
$result = @($sql,$connection) or die ("Couldn't select databaseKO3.");

if (mysql_num_rows($result) > 0) {

while($row= mysql_fetch_array($result, 1)) { D

//Define Session Id Number that is used in Session Variables table
$SessionID = $row[id];
$UserName = $row[UsersName];

// DO SOME STUFF HERE

// RETURN VALUES TO PAGE FROM TABLE
return array($SessionID, $UserName);

}
}

else {

// PUT IN REDIRECT HERE

}
} // END FUNCTION

Thanks,

Kev

rinjani

Try this, it should work for you

if (mysql_num_rows($result) > 0) {
while($row= mysql_fetch_array($result, 1)) {

$my_data[] = $row;
}

return $my_data

}

call the function this way:

$user_data = Inwork($userid);

And each member of the array can be identified as:

$user_data[0];
$user_data[1]

etc

Alternatively, if you plan to process the items before returning them a simple way to go about it is:

if (mysql_num_rows($result) > 0) {
while($row= mysql_fetch_array($result, 1)) {

//Define Session Id Number that is used in Session Variables table
$SessionID = $row[id];
$UserName = $row[UsersName];

// DO SOME STUFF HERE
}
//Or Do More STUFF HERE

//Build array
$my_data_array = array($SessionID, $UserName, $third, $fourth);

// RETURN VALUES TO PAGE
return $my_data_array;

}

You can call it the same way. Also check out the different array function in the manual for walking through etc.

HTH

ajna

Thanks for the help. I found a similar solution in the meantime...varying only by allowing me to define the array values individual name.

calling function in the following way:

list($value1, $value2, $value3...etc) = KeepOnline($sID, null);

then

function KeepOnline($sID) {

//do stuff
return array($value1, $value2, $value3...etc);

}

then my php page that called the function can reference these values by echos

<? echo $value1 ?>

Thanks again for the help!

Kev