php error - no database selected

Hi everyone,

I'm trying to test out a php registration system up on my remote server. I created using securityAssist in the Super Suite.

I uploaded all the files but when I go to the rego page, I get the following error:

"No database selected"

Below is the code I have in my connection file.

I don't know if it's because I've put the files into a subdirectory within the root folder of my site. Would this be causing the problem and do I need to have this reflected in the file path somehow?

Really appreciate any help.



<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost:/tmp/mysql5.sock";
$database_localhost = "olink_stm_site";
$username_localhost = "stmEvents";
$password_localhost = "mypassword";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

The hostname should be an IP address or domain of the database server. The syntax of specifying a directory seems incorrect... maybe it should just be "localhost"

Thanks - yes that was the problem. I've put in the correct syntax and all works well now.