strange thing with mysql_connect

luksedj

Hi,

I have a strange thing on my system running apache , php and mysql.

Running phpmyadmin works like a charm, but when i tried to run some scripts of my own, using the database gave me this:

Fatal error: Call to undefined function: mysql_connect() in /var/www/blah.php
😕
how can phpmyadmin be working correctly whithout this function? Also, I checked, php is compiled with mysql support.

All this is running on debian sarge (testing) with the debian packages for apache, php,mysql (nothing compiled on my own)

thnx for any clues,

pieter

piersk

Are you quite sure that MySQL support is enabled withing PHP? You ran a script with

<?php
phpinfo();
?>

in it?

luksedj

Yes , I'm very sure :-)

I checked it already with phpinfo();

here is the config-line: (deletede some parts because it was to long)
'../configure' '--prefix=/usr' '--with-apxs=/usr/bin/apxs' '--with-regex=php' '--with-config-file-path=/etc/php4/apache' '--disable-rpath' '--disable-debug' '--enable-memory-limit' '--enable-calendar' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-bcmath' '--with-bz2' '--enable-ctype' '--with-db2' '--with-iconv' '--with-ndbm' '--enable-exif' '--enable-filepro' '--enable-ftp' '--with-gettext' '--enable-mbstring' '--with-pcre-regex=/usr' '--enable-shmop' '--with-mysql=shared,/usr'

(btw: phpmyadmin works, and it uses mysql_connect intensively)

Thnx for your answer...

pieter

piersk

And you're logging in with all the correct user id/password (sounds stupid I know, but there might be a typo) and you are selecting the right database?

luksedj

Yes, to double check I copy-pasted the server,username and password to the commandline interface to mysql (mysql -h localhost -u pasted-user -p)

connection was fine.
😕