RE: [PHP-DB] mysql_fetch_assoc() bug with mysql 4.1 and fields escaping?

Funny, questions about MySQL 4.1.x seem to be popping up a lot recently. With good reason. There are some changes that make old mysql_*() functions not work anymore. I don't know all the ins and outs yet, but I ran into it last weekend and everything I saw seemed to recommend switching to the Improved MySQL Functions: http://www.php.net/manual/en/ref.mysqli.php It is definitely supposed to help with being able to connect and log into the database since the new password hashing scheme is incompatible with the old MySQL standards. It might help you with this other stuff too. Good luck! -TG > -----Original Message----- > From: Clément MOULIN [mailto:cmoulin@simplerezo.com] > Sent: Thursday, December 02, 2004 7:55 AM > To: php-db@lists.php.net > Subject: [PHP-DB] mysql_fetch_assoc() bug with mysql 4.1 and > fields escaping? > > > > Hi, > > We have recently upgraded our mysql server from 4.0.X to 4.1.7. > But now, the mysql_fetch_array() & mysql_fetch_assoc() > doesn't work anymore > when escaping fields names like that: > SELECT name FROM db; > mysql_fetch_assoc() returns a associative arrays, but not > with good key > names (somes binary characters like square character or > '#B'...), and some > lines are missing. > > With: SELECT name FROM db; > It works fine... But sometimes we _really_ need to escape field name. > > Running php 4.3.9. Is it a known bug? > > -- > Clément Moulin > SimpleRezo - Simplifiez-vous le réseau ! > Tél.: +33 871 763 102 - Web: http://www.simplerezo.com/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >