new server, new php/mysql problems

Lcousins

hi,

ive just moved onto a raq550 from a raq3 and have started the laborious process of moving stuff accross. Unfortunately ive come unstuck very early on in that I get the error message:

Fatal error: Call to undefined function: mysql_connect() in /home/.sites/28/site1/web/logon.php on line 2

having searched around the web theres a lot of suggestion that I need to do things to the php.ini file. Great except I dont know how to edit the php.ini file nor am I clear what i have to put even if i did manage to edit it.

any help would as ever be much appreciated

Luke

frog

Do you do the mysql_connect in an include file? You may have forgotten to copy that file across.

Lcousins

Due to my rather limited skills at this time there are no includes at all. all the functions used on each page are stored on the same page. I thought 'mysql_connect' was an in built function though?? is there any other way to connect to a mysql database using php that I should know about??

frog

You have to specify your mysql database name, username and password when using mysql_connect. It is a PHP function, but you need to set the parameters in order to make it work.
See the manual:

http://uk2.php.net/manual/en/function.mysql-connect.php

Here is some code to help you (not mine, I found it in the user comments in the manual!)

<?
// db variables
// inserts variables accordingly
$host = "";
$user = "";
$pass = "";
$db = "";
$table = "";

// connecting to the db
$link = mysql_connect ($host, $user, $pass);

// the db query
$q = "SELECT * from $table";
$results = mysql_db_query ($db, $q, $link);

// fetching the results
while ($row = mysql_fetch_array($result)){

echo "$row[whatever]
$row[whatever2]

}

// closing the db link
mysql_close ($link);
?>

Lcousins

yep, sorry im still being unclear, i'll give you the full code (minus password of course 😛) to look at:

$db = mysql_connect("localhost" , "ufaadmin", "mypassword");
mysql_select_db("virtualufa",$db);
$result = mysql_query("select * from user where name='$username' and pass= password('$password')",$db);
$row = mysql_fetch_array($result);

the problem isnt with the code itself (it works fine when I return it to its original home), and ive double checked that the two databases and mysql users are exactly the same. the php simply isnt recognising any mySQL functions even though the php info is showing up as having the '-with mysql' installed.

thanks for all the effort anyway 😉 any further ideas would be happily recieved.

luke

frog

Wht don't you try the Install forum, seems to an installation issue.

Good luck!