RE: [PHP-DB] mysqli prepared statement query result sets

The functions you want exist in php5, if that's an option: http://us2.php.net/manual/en/ref.mysqli.php -> http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -----Original Message----- From: Hans Lellelid [mailto:hans@velum.net] Sent: Tuesday, October 26, 2004 5:57 AM To: Gerard Samuel Cc: php-db@lists.php.net Subject: Re: [PHP-DB] mysqli prepared statement query result sets Hi Gerard, Thanks for the reply. >> I'm writing a db abstraction layer driver for MySQLi. I'm glad to >> finally get a chance to play around with these new functions, but am >> completely stumped by this question: >> >> Is there no way to get back a standard resultset when using prepared >> statement queries? >><snip> >> I don't see the solution, but I hope I'm just missing something >> because I've been staring at it too long. > > > > No you're not missing anything... > I ran into the same thing... > > http://marc.theaimsgroup.com/?l=php-db&m=109625996830773&w=2 > So I ended up simulating "prepared" statements via php itself. The way > the mysqli extension is currently setup, is that you can either use > the normal functions by themselves, or you use the statement functions > by themselves. They cannot be used together, which I think.... Never > mind, I'll keep my thoughts to myself... Ooops, I guess I should have searched the list itself; I did some google searches to no avail. This is really unfortunate. This API sucks! I was looking forward to being able to use native prepared statements rather than emulating, but I guess that's really not feasible for this project. Argh. Thanks again for response. Hans -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php