I've tried SQLyog and found a small but very annoying issue. It gives trouble, when trying to run a Stores Procedure wich gives data back to the client.
The error code is this:
Error Code : 1312
PROCEDURE testdb.sp_PostCount can't return a result set in the given context
The stored procedure:
CREATE PROCEDURE `sp_PostCount`()
BEGIN
DECLARE message_count_1,message_count_2,comment_count,linksxchange_count INT;
SELECT COUNT(id) INTO message_count_1 FROM message where deleted=0 and id_user=1;
SELECT COUNT(id) INTO message_count_2 FROM message where deleted=0 and id_user=2;
SELECT COUNT(id) INTO comment_count FROM comment where deleted=0;
SELECT COUNT(id) INTO linksxchange_count FROM linksxchange where deleted=0;
SELECT message_count_1,message_count_2,comment_count,linksxchange_count;
END$$
As far as i have read on the php and mysql forums, it's the use of the mysql instead of the mysqli connector. And the fact that php, as a standard, comes with older mysql connectors made for the 4x branch of mysql.
It would be just great if you could find the time to implement mysqli in your php tunnel.
Other than that, i can't find anything to complain about. SQLyog is just the greatest mysql manager made. Thanks.
Cheers,
Nicky Larstrup
