I have finish designing a dynamic site with PHP/MySQL in dreamweaver. Upon upload, I keep getting "no database selected" when I try to log in my database as a user.

here is my connection file code:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_db = "localhost";
$database_db = "dbname";
$username_db = "username";
$password_db = "pasword";
$sya = mysql_connect("localhost", "cplogin", "cppassword", "dbname"or trigger_error(mysql_error(),E_USER_ERROR);
?>

Av u imported ur database to ur host. i.e hav u also created ur dbase afta hosting

from your code, i see u a learner. why did u create variables u ended up not using? also, your db is no longer 'localhost' after uploading. u hv 2 either upload the database frm localhost or create a corresponding one online. 08182028090 for help

You have probably not created your database. Go back to your php my admin and create your database there. Then you need to use the name of the database you created in php my admin in your connection string. For how to create the database in php my admin, simple google it

I have written and uploaded an instruction on what to do for you on the following link

http://www.hypertechnetwork.com/products/pg?a=0001

I think it will help you alot.

i think you had a wrong approach in ur coding, after creating the variables for the database and established a connection with mysql_connect("localhost",$dbuser,$dbpass) or die('error connecting to db'); then you should add it to a variable like $conn=mysql_connect blah blah; then next line should be mysql_select_db($conn,$dbname);. It should work well if u grab my sketch up, call 07032973337 for help

Thanks a lot guys for your solutions. Will work on them and get back to you.

chuchutech: i think you had a wrong approach in ur coding, after creating the variables for the database and established a connection with mysql_connect("localhost",$dbuser,$dbpass) or die('error connecting to db'); then you should add it to a variable like $conn=mysql_connect blah blah; then next line should be mysql_select_db($conn,$dbname);. It should work well if u grab my sketch up, call 07032973337 for help

look at the code again he did just that, he added it a variable. There's no wrong approach there. Since the code didn't scale the first test of connectivity then the dbase name or that the dbase as not been created is the problem

Thanks a lot guys, it finally works. I wasn't using the complete db and username in cpanel (cpanel username followed by an underscore then the MySQL username I created. same with dbname). Thanks a lot, you guided me to it, really appreciate it.