RE: [PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-17 Thread Gary . Every
//Place your request into a variable: $result = odbc_do($connection,select * from events where id=$id); $var = odbc_fetch_row($result); // Now you have an array to work on foreach($var as $line){ //Do your formatting thusly: echo ' trtd' . $line[0] . '?td

RE: [PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-16 Thread Dennis Cole
$cnx = odbc_connect( 'DSN' , 'USER', 'PASS' ); if (!$cnx) { ?Could not connect to ODBC? } $cur= odbc_exec( $cnx, SELECT Vehicle.Vehicle_ID, Vehicle.Cust_ID FROM Vehicle ); if (!$cur) { Error_handler( Error in odbc_exec( no cursor returned ) , $cnx ); } //