Return results..

[NZ_Kiwis]

function UnixTime($value1) {
         $time = time();
         return 'The current time is: ' . $time;  

}

I've got a web service and it returns results like above, however I want to have another function which will return results from my MySQL DB. I want to know to turn so many resutls.

I thought of

1. Return a string with the MySQL dump
2. Return it in some form or an array

Both seem messy, do we have any other ideas?

[Weedpacket]

What's messy about an array? That's what they're for.

[NogDog]

It's not very clear to me what you want, but my first thought was: XML.

[NZ_Kiwis]

Hmmm how can I do something like this then?

ysql_connect (localhost, **, **);
mysql_select_db (**);

$result2 = mysql_query ("SELECT * From news order by id desc limit 10");
$row2 = mysql_fetch_array($result2);      

foreach ($data as $key => $row) {
$volume[$key]  = $row['id'];
$edition[$key] = $row['header'];
}

[NogDog]

I think you want:

$result2 = mysql_query ("SELECT * From news order by id desc limit 10");
$data = array();  // initialize data array
while($row = mysql_fetch_assoc($result2))  // retrieve with associative indexes
{
   $data[] = $row;
}