Using ms access query with php

Hi, Abul

Do as below.

<?php

$conn = odbc_connect( "db_local_mysql",
"", "", SQL_CUR_USE_DRIVER );
$access_qry = odbc_do( $conn, "{CALL
My_Access_Query}" ); 


while(odbc_fetch_row($access_qry)){
    $loop_max = odbc_num_fields($access_qry);
    for($i=1; $i <= $loop_max; $i++){
        echo "  ".odbc_result($access_qry,$i);
    }
    echo "<br />";
}

?&gt;

This code will echo the result of 'My_Access_Query'.
Hope that helps.

Chong






 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.
yahoo.com/group/PHP-OOP/

<*> To unsubscribe from this group, send an email to:
    PHP-OOP-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/