Can't Connect To Mysql Through PhP

csmsach

I recently Installed Redhat 9, and am new to php and mysql. I read some tutorials and set up an account in mysql and created a database. I can't connect to it no problems from mysql command line, but when i use php i get errors. Is there anything specfific to redhat that i have overlooked? any help would be greatly appriciated...

the code i used to try and connect to mysql is

<html>
<head>
<title>Connect To Sachnet Database</title>
</head>
<body>

DEFINE (HOST, "localhost");
DEFINE (USER, "user");
DEFINE (PASSWD, "pass");
DEFINE (DB, "database");

$linkID = mysql_pconnect (HOST, USER, PASSWD);

mysql_select_db (DB, $linkID);

$result_id = mysql_query ("CREATE TABLE customer(customerID INT(8),
firstname CHAR(30), lastname CHAR(30))", $linkID);

if ($resultID != FALSE)
{
print "The query was succesfully executed.";
}
else
{
print "The query was not successfully executed.";
}
msql_close($linkID);

</body>
</html>

i have obviously taken the real user pass * out of script

planetsim

You have gotten a little lost with Define

define isnt suppose to be used as a resort for variables.

You should make it like this

$HOST = "localhost";
$USER = "user";
$PASSWD = "pass";
$DB = "database";

$linkID = mysql_connect ($HOST, $USER, $PASSWD);

mysql_select_db (DB, $linkID);

I dont suggest using pconnect.

csmsach

I changed the variables declaration as suggested but I still get the same errors. I can login to the mysql command line tool, but not through php. I set up the user permissions properly and flushed the permissions, but still not working. What problems could cause this to occur?

noeledoran

Are the typo's ($resultID vs $result_id) and (msql vs mysql) in your code or just the in your question?

csmsach

yeah the result_id vs resultID was a problem.

thnx!

Feel stupid for that one!!!