return values via function

condoug

If someone could help me out here I would greatly appreciate it.

I have a query which returns 3 values:

	$q= "select field1, field2, field3 from a_table";
	$r= mysql_query($q);
	while($data = mysql_fetch_array($r)) {
		$field1= $datarow['field1'];
		$field2= stripslashes($datarow['field2']);
		$field3= $datarow['field3];
	}
	mysql_free_result($r);

However, I will run this query multiple times in different scripts across my new website and therefore would like to have it as a function in a separate function document.

My question is, how do I return all 3 values of this query via a function to the page that calls the function?

Hope that males sense.

Thanks
Gaz

NogDog

Probably I'd put them into an array, then return the array.

condoug

Would you be able to provide an example of how to do this?

NogDog

function something_or_other()
{
   // do query stuff, storing query result in $result, then:
   $data = array();
   while($row = mysql_fetch_assoc($result))
   {
      $data[] = $row;
   }
   return($data);
}