[SOLVED] Unknown mysql_connect problem

[Phobios]

When I try to connect from my php-script to my mysql server on localhost it will not work. This is the test code I am using while trying to get it to work:

 

<?php

 

    $user = "user";

        $password = "password";

        $host = "localhost";

        $db = "db";

 

        echo first;

        $conn = mysql_connect($host,$user,$password) or die("Problems connecting: " . mysql_error());

        echo second;

        $db = mysql_select_db($conn);

        mysql_close($conn);

 

?>

 

After the mysql_connect call nothing will be displayed and I get no error message whatsoever. I have set all the right privileges in the mysql database. I have looked through the php.ini file and found no fault in there. I have googled alot on the subject, but I haven't found anything of help yet.

 

On my real page, which I will use it on, the css on the page gets screwed up as well.

 

I am using fedora core 11.

 

I hope someone out there can help me out.

[PFMaBiSmAd]

Add the following two lines of code immediately after the first opening <?php tag to get php to help you -

ini_set("display_errors", "1");
error_reporting(E_ALL);

[rhodesa]

try something like this instead:

 

<?php
  $user = "user";
  $password = "password";
  $host = "localhost";
  $db = "db";

  echo "Connecting...";
  $conn = mysql_connect($host,$user,$password)
    or die("Problems connecting: " . mysql_error());
  echo "Done<br />";     

  echo "Selecting DB...";
  if(!mysql_select_db($db, $conn))
    echo "Failed";
  else
    echo "Done<br />";

  mysql_close($conn);
?>

[mikesta707]

welll of course that doesn't echo anything. you have to enclose strings with quotes.

 

echo "second";

 

is it still not echoing anything?

[PFMaBiSmAd]

Except that php allows some extremely awful code to do something -

Notice: Use of undefined constant first - assumed 'first' in your_file.php on line x

first

[Phobios]

Now I see the error! It says:

Fatal error: Call to undefined function mysql_connect() in /var/www/html/test.php on line 12

 

How do I fix this problem?

 

edit:

It still echoed first, but I have added quotation marks now since it gave me a warning... didn't think about that.

[rhodesa]

http://us3.php.net/manual/en/mysql.installation.php

[mikesta707]

are you sure you have the PHP mysql package installed on your server?

[Phobios]

Thanks everyone for your help. Everything works fine now.