message No database selected
Hello I need some basic help here because I cannot work out what I am doing wrong.
I am slowly working through this Solution Pack and my current challenge is overcoming the "No database selected" message.
I am runing XAMP with Apache and MySQL as a local host on Windows Vista with IIS turned off. I use Dreamweaver CS3
Page results as follows
users_LogIn.php?accesscheck=%2Fphptest%2Fusr_reg%2Fusers_LogOut.php
The above page loads OK
users_Registration.php
This page displays the message No database selected
users_EmailPW.php
This page displays the message No database selected
The MySQL Connection test passes OK so I do not understand why there is no database connection
I looked at these support pages and spotted a similar issue except that my localhost php file content has one less line.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "users.sql";
$username_localhost = "root";
$password_localhost = "dicksdo1025";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>
I have tried changing line 6 by removing .sql from users.sql and saving the file but next time I open the file in notepad the .sql is back!
Clearly I have not completed one of the pages in the Solution pack correctly but which ones and what needs to be changed?
