note 104687 added to mysql.constants

If you're using stored procedures and mysql_error() returns "PROCEDURE storedProcedureName can't return a result set in the given context", you need to pass an additional flag (CLIENT_MULTI_RESULTS) to mysql_connect() as such: mysql_connect($hostname, $username, $password, true, 131072); Some other sources say that you should use 65536. 65536 is actually the flag to allow multiple statements in a single mysql_query(), and is a security issue. The reason it allows you to receive results from stored procedures is because it implies 131072. To be safe, use 131072 over 65536. ---- Server IP: 69.147.83.197 Probable Submitter: 128.193.15.52 (proxied: 128.193.39.31) ---- Manual Page -- http://www.php.net/manual/en/mysql.constants.php Edit -- https://master.php.net/note/edit/104687 Del: integrated -- https://master.php.net/note/delete/104687/integrated Del: useless -- https://master.php.net/note/delete/104687/useless Del: bad code -- https://master.php.net/note/delete/104687/bad+code Del: spam -- https://master.php.net/note/delete/104687/spam Del: non-english -- https://master.php.net/note/delete/104687/non-english Del: in docs -- https://master.php.net/note/delete/104687/in+docs Del: other reasons-- https://master.php.net/note/delete/104687 Reject -- https://master.php.net/note/reject/104687 Search -- https://master.php.net/manage/user-notes.php