Database connect

Posted: Mon Mar 14, 2005 10:04 pm Post subject: Database connect

Hello ! tis me again !
long time no hastle eh ! lol

When i put the connection string and stuff into my webpage, i get no connection to the datebase, all i get is the connection string apearing as text.

HELP ME !!!!

NetHosted Staff Joined: 22 Mar 2004 Posts: 5684

Ummm, not quite sure of your question, can you elaborate?

Andrew

Posted: Tue Mar 15, 2005 1:29 pm Post subject:

If you are using php have you remembered to start with <? tag? Perhaps if you post some code, we can have a look.

Posted: Tue Mar 15, 2005 1:51 pm Post subject: Database connection

According to cpanel the connection string is
$dbh=mysql_connect ("localhost", "thedrug_paul", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("thedrug_business");

When i put this code into a webpage i am getting no connection, but the code is apearing as if i have asked it to echo on screen

NetHosted Staff Joined: 22 Mar 2004 Posts: 5684

Did you put the password where it says "<PASSWORD HERE>" ?

Andrew

Posted: Tue Mar 15, 2005 2:23 pm Post subject:

Andrew, does localhost work on your server?

NetHosted Staff Joined: 22 Mar 2004 Posts: 5684

If he's uploading the files to our server yes, obviously wont work when on his home computer...

Andrew

Posted: Tue Mar 15, 2005 2:27 pm Post subject:

Yep, put the password in.

its coming up just as text in the page, just as if i want the details for others to read

NetHosted Staff Joined: 22 Mar 2004 Posts: 5684

Is your page a .php page?

Andrew

Posted: Tue Mar 15, 2005 2:48 pm Post subject:

Yep, what I will do, when i get home i will re write the page in notepad and try it again.

NetHosted Staff Joined: 22 Mar 2004 Posts: 5684

I'm sure it's something obvious, I'll look into this!

Andrew

Posted: Tue Mar 15, 2005 3:09 pm Post subject:

If it is echoing the text rather than running the query, there must be a php error else the mysql_error() would be returned. Maybe some code hasn't be closed properly before this line. If you are printing text before this line, have you closed the command properly?

Client Support	Community	Server Status	Contact Us	Client Login
Email Hosting	Website Hosting	Reseller Hosting	VPS Hosting	Dedicated Servers