I have the following code in PHP:
$mysql = mysql_connect("localhost","myuser","password",false,65536);
$sql = "CALL UPDATE_LINE_ITEMS(123)";
$rs = mysql_query( $sql )
Re mysql, 'myuser' has execute privileges on this procedure - ie if I call this through the mysql console it works. However, when I call this procedure using php it sometimes works and sometimes doesn't. How do I debug (using php) why this isn't being called?