Re: [PHP-DB] ODBC and SQLCA From: Andreas Karajannis (Andreas.Karajannis <email protected>)
Date: 08/14/00

Eirik Overby wrote:
>
> Hi!
>
> I'm writing a mysql<->odbc compatiblity class in PHP, but to implement
> the mysql_affected_rows() function I need to be able, through ODBC
> (using DB2 now), to get the SQLCA variables, which among other things
> hold the number of (estimated if a prepared statement) affected rows by,
> say, an UPDATE statement..
>
> Anyone know how to do this?
> Any help appreciated..
>

Use odbc_num_rows(), it will give you the number of affected rows for
update etc but not for select!

-Andreas

-- 
Andreas Karajannis
GMD National Research Center for Information Technology
Schloss Birlinghoven, D-53754 Sankt Augustin
Phone +49 2241 142948

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>