Jump to content


Photo

mysql connection, help me please


  • Please log in to reply
No replies to this topic

#1 icecoldtears

icecoldtears
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 27 August 2005 - 01:40 PM

I'm trying to get mysql connections to work in dreamweaver (i've managed to get it to work manually, but I can't get any response from dreamweaver).

Dreamweaver creates this connection file (I haven't tested to see if it works)
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_thegeneral = "mysql57.secureserver.net";
$database_thegeneral = "thegeneral";
$username_thegeneral = "thegeneral";
$password_thegeneral = "********";
$thegeneral = mysql_pconnect($hostname_thegeneral, $username_thegeneral, $password_thegeneral) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

The code I used to test the connection with (I tested this and even tried replacing dreamweavers code with it)
<?php
$hostname="mysql.secureserver.net";
$username="thegeneral";
$password="********";
$dbname="thegeneral";
$usertable="authentication";
$yourfield = "user_name";
mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($dbname);

# Check If Record Exists

$query = "SELECT * FROM $usertable";

$result = mysql_query($query);

if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."
";
}
}
?> 

The code I used to replace dreamweavers connection file with
$hostname="mysql.secureserver.net";
$username="thegeneral";
$password="********";
$dbname="thegeneral";
$usertable="authentication";
$yourfield = "user_name";
mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($dbname);

The error message dreamweaver gives when i try to test the connection in dreamweaver
Posted Image

I don't understand y it isn't working :(
Whats the reason for the 404 error and whats this MMHTTPDB.php file it mentions in the error message? I've tried everything i can think of to fix this problem but I just can't make a connection in dreamweaver. Thank you for your help.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users