Since I upgraded to CB 1.4 I cannot execute a mysql_select_db() statement to select any database other than the database for the Joomla site.

This call does not return an error, it does not return at all and I am left with a blank screen

Code as simple as shown below will fail for any existing database unless 'xyz' is the Joomla database

<?
$con = mysql_connect("localhost",$username,$password);
$select = mysql_select_db('xyz',$con);
mysql_close($con);
?>

It doesn't even error, just hangs with a white screen....take out the mysql_select_db call and the page is displayed (but doesn't work because can't retrieve any data for the db).

When I restored the site from a backup I took just before the upgrade, everything started working again under 1.2.3

Any thoughts?

Thanks,
Dom

Thanks for the reply...but I was not clear....I am not talking about using the CB database. This is a MySQL database that is unrelated to Joomla or CB. It is one that I maintain to keep track of other data necessary for the whole site to work properly.

I do use the CB API when I need to work with the CB data, but this is outside CB.

The interesting thing is that the mysql_select_db never returns so I cannot even process an error code.

In principal I agree with you that this should have no effect as I am using direct PHP methods, but as far as I can tell, the only change to the site is the change of CB version.

Regards,
Dom

Again, thanks for your reply....the query is being executed from within an article in order to get the proper information to display on the page.

I guess I wasn't clear....this site has been up an running for many months....the select_db call stopped working when I upgraded. No coding changes were made.

I will think about where else it could be happening and report back.

I appreciate your input!
Dom

OK...I just did it again to be sure that nothing else could have changed....I took the completely working site running with CB 1.2.3 and installed 1.4.

Again, as soon as the install competed, my article with embedded PHP code including a mysql_select_db() call would no display.

I have tested that simply commenting out that line and the page displays (but without all the data it needs). Additionally, I made a page consisting of simply the code from my original post (with the proper information in the arguments) and the page will not display. Comment out the select_db call and all works.

The call to the function never returns so no error code is generated.

While I agree that it does not make sense for it to be CB related, at the same time it is the only that does make sense as it is the only change.

Thanks for all the support!
Dom