[RESOLVED] Help with PHP function!!!

misha299

Hi everyone. I was assigned to rewrite an old application written in php and I came across a function that I cant find anywhere. It is mysql($database, $query) - NOT mysql_connect() or mysql_...(). I dont know what is it and it is not in the library files. Does anyone know something about?

Please help,

Thanx.

bradgrafelman

EDIT: Looks like a deprecated form of [man]mysql_query/man. I would definitely use [man]mysql_query/man instead.

misha299

Thanx but the problem is that I did not miss anything.

laserlight

Looks like a deprecated form of mysql_query(). I would definitely use mysql_query() instead.

I doubt it. The deprecated form is mysql_db_query(). Did you check the include files for a user defined function named mysql?

misha299

Yes I did. It is possible that I was given a faulty source code like a testing version or something... but unlikely...

bradgrafelman

User defined function mysql()? You can't create a user defined function when the function already exists in PHP...

Weedpacket

Yeah, but "mysql()" isn't a PHP function. But if the function isn't defined anywhere then the program will choke and say so when it's encountered. So, does it? (Hopefully, there are some coding standards in place for the source code, so that it would be possible to search through all the code for something like "function mysql(" to see if and where it is defined.)

Just started wondering: how old are we talking here? Did PHP/FI have this function?

bradgrafelman

Weedpacket wrote:
Just started wondering: how old are we talking here? Did PHP/FI have this function?

Not sure, but I'm running PHP 4.4.2 on Windows, and this mysql() function is built-in.

If I do this:

<?PHP
mysql('hi', 'hi', 'hi');
?>

I see this:

Notice: mysql(): This function is deprecated; use mysql_query() instead. in c:\program files\apache group\apache\htdocs\mytest.php on line 2

Warning: mysql(): supplied argument is not a valid MySQL-Link resource in c:\program files\apache group\apache\htdocs\mytest.php on line 2

Weedpacket

Well, it does exist in PHP4 (even 4.3.x) - but it's certainly very old - so old it's been removed from the documentation.

Why not take the error message's advice and change it to mysql_query()?

misha299

Thank you guys. I guess it is a very old PHP function.