odbc_result_all

int odbc_result_all ( resource $result_id [, string $format ] )

Print result as HTML table

Prints all rows from a result identifier produced by odbc_exec(). The result is printed in HTML table format.

Following is the example

 
<?php
$package_code = 'AUS03B';
$client_id = 488;
$conn = odbc_connect(DSN,USER,PASS,SQL_CUR_USE_ODBC);
$sql_result = odbc_prepare($conn, "EXEC usp_packagesearch_xml '$pacCode','$client_id'");
$result = odbc_execute($sql_result);
//$string = odbc_result($sql_result,1);
$string = odbc_result_all($sql_result,"border=0");
?>