Ahah.. Ok I think I understand now. I had a similar problem when using the Xoops CMS after upgrading to MySQL5 (part of the reason that my site has been completly rewritten)
Try adding these queries right after the database connection is made in
include/common.php
| Code: |
if($db = @mysql_pconnect($dbhost, $dbuser, $dbpasswd)){
mysql_select_db($dbname, $db);
// added to set mysql to use UTF8 on queries
mysql_query('SET character_set_results="utf8"');
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES 'utf8'");
|
Also, you may want to change "@mysql_pconnect" to "@mysql_connect" fewer and fewer servers use persistent connections these days.
Favoured: 0
