Returning results

[Anon]

Hello,

I have just started to use PHP on Apache connecting to Sybase backend. I would like to know if it is possible to retrieve all the result set together instead of having to retrieve row by row ???

Any assistance we be very much appreciated.

Thank you,

Nick

[[deleted]]

No it's not possible (and usually not what you want either)

If you want to build a 'complete' resultset in PHP,
build a simple function to execute the query.
That function can then also retreive the data and store it in an array to be returned.

function sql_query($query , &$aResultData, &$sErrorMsg, $db_connection_id)
{
if ($result = sql_query($query, $db_connection_id))
{
$aResultData=array();
while ($row=sql_fetch($result))
{
$aResultData[]=$row;
};
return true;
}
else
{
$sErrorMsg = sql_error();
return false;
};

you'll have to replace the sql_query() etc with the proper PHP commands to fetch the data from the database.
With a function like this you can execute the query and get a clean array of data back all in one go.