Re: Call to undefined function mysql_real_escape_string()

Paul Hickey wrote:

Can someone help me overcome this recurring problem? I am using the Joomla content management system and I keep coming across the following errors. Fatal error: Call to undefined function mysql_real_escape_string() in /usr/local/apache2/htdocs/common.php on line 24 Fatal error: Call to undefined function mysql_real_escape_string() in /usr/local/apache2/htdocs/class.inputfilter.php on line 344 I notice in my Dynamic Extensions section of php.ini there are no extensions called for; if that helps. Joomla works fine, but when adding components or modules the problems start. One component author made a test for the mysql_real_escape_string and I think avoided using it then the component worked. I think that's probably not the best solution. Fedora Core 3 Apache 2.0.55 PHP 5.0.5 (compiled with mysqli vice mysql) './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--enable-ftp' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-mbstring' '--enable-track-vars' '--enable-trans-sid' '--enable-wddx=shared' '--enable-xml' '--with-dom' '--with-gd' '--with-gettext' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-regex=system' '--with-xml' '--with-zlib-dir=/usr/lib' MySQL 4.1.15

mysql_real_escape_string() is a MySQL function, and you're server is compiled with the 'improved' MySQL functions. You want mysqli_real_escape_string() http://us3.php.net/manual/en/function.mysqli-real-escape-string.php -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 jnichel@dotcomholdingsofbuffalo.com