Problem in MySql function

doctorweb

i m using php 5.04 and i m using the following code to connect to mysql database

<?php 
$db = mysql_connect("localhost","root","pass"); 
mysql_select_db("mybuddy",$db); 
//replace the above values with your actual database values 

$sql_result = mysql_query("SELECT joke FROM jokes WHERE joke_no=1", $db); 

$rs = mysql_fetch_row($sql_result); 
echo $rs[0]; 
?>

It gives error
Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\php\DbConnect.php on line 2

can any one tellme that what is wrong in my code

waiting for your reply

Thanks
Zeeshan Saeed

rincewind456

Nothing wrong with the code, check if you have the mysql extension enabled in your php.ini

doctorweb

rincewind456 wrote:
Nothing wrong with the code, check if you have the mysql extension enabled in your php.ini

thanks for the quick reply ...

now can u temme how can i enable the extension in my php.ini file ?

Thanks
Zeeshan Saeed

rincewind456

Without knowing your server and OS configuration the best thing to do is open up the install file that's in your php directory and follow the instructions specific to your environment about installing extensions.

doctorweb

I m using PHP 5.0.5 on windows XP now i only want to enable mysql_connect function

Please Help me resove this problem

Thanks

rincewind456

Open up your php.ini file, it will be in your the directory you installed php usually c:\Program Files\php\ or c:\php.

Look down to around line 529 for this entry

extension_dir

and take note of what it says if it's

extension_dir = "./ext/"

leave it as it is and look at around line 657 for this

extension=php_mysql.dll

if there is a

at the start of the line delete it.

extension_dir

extension_dir = "./"

you will have to move the dll files in c:\Program Files\php\ext or c:\php\ext into your c:\Program Files\php\ or c:\php\ directory as well as deleting the

as described above.

Save the file and restart the Apache server to make the changes take effect.