Hacker
Hacker

Reputation: 7906

meaning of this sql statement

I just found a code like this in my new project. and i have no idea wht it does.

$q = "SELECT getnewmsg(" . $_GET['messgae'] . " result)";

i searched for getnewmsg in whole file system and i did not get it. Can you please let me know does it actually mean. i have never seen such sql statement.

Upvotes: 1

Views: 69

Answers (3)

Paolo Stefan
Paolo Stefan

Reputation: 10253

If you want to know more about the procedure (in case it is a procedure), you may send the following query:

SHOW PROCEDURE STATUS LIKE 'getnewmsg';

For more information, see the MySQL manual for SHOW PROCEDURE STATUS.

Upvotes: 2

Emmerman
Emmerman

Reputation: 2343

looks like stored function http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

Upvotes: 2

Colin Fine
Colin Fine

Reputation: 3364

"getnewmsg" is not found in a search of the Mysql site, so it is probably a stored procedure that has been added to your particular database. We have no way of telling what it does.

Upvotes: 2

Related Questions