Returning values within a loop?

[livewirerules]

how do i return a value from a loop within a function?

 

function deprecated()
{
$sql="select * from table where id=1";
$result=mysql_query($sql) or die(mysql_error());

while ($row=mysql_fetch_array($result)) {

	$date=$row['date'];
               $cat=$row['cat'];


}
}

 

i want to return both $date and $cat.... How do i do it?

[trq]

The best you can do is return an array.

 

function deprecated()
{
  $sql="select * from table where id=1";
  $result=mysql_query($sql) or die(mysql_error());
  $return = array();
  while ($row=mysql_fetch_array($result)) {
    $return[] = $row;
  }
  return $return;
}