Re: Problems with mysql

[ahmed]

Hello there,
i did as u both told me to do ...but i am still facing the same error-->Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\table.php on line 5

the code i used is:
<?php
$username = "";
$password = "root";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("first_test",$dbh)
or die("Could not select first_test");
// you're going to do lots more here soon
mysql_close($dbh);
?>


then i made changes in the following areas :

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:\Program_Files\php\ext"
.
.
.
.
.
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

;extension=php_mbstring.dll
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
:extension=php_msql.dll
;extension=php_mysql.dll <-------- when i removed the semi-colen...and when i tried to
run my script i get an error saying
unable to laod mysql and mysqli dll's.
;extension=php_mysqli.dll <--------

;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll


so please give me a solution to work on php and mysql...

thank you..

ahmed