Re: ODBC and SQLCA
| From: | Andreas Karajannis | Date: | Mon, 14 Aug 2000 14:23:21 +0000 |
| Subject: | Re: ODBC and SQLCA | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2042@lists.php.net to get a copy of this message | ||
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