Jump to content

Irregular stored proc results giving me headaches, please help


darkroastbeans

Recommended Posts

Hey folks, I'm having a really weird problem -- I've written a stored procedure to give me aggregated results from a table and pair that with data from another table -- what's weird is that when I execute the proc in Toad or MySQL Query Browser, the results come out fine, but when I execute the proc in SQLyog, or from a PHP script, the results come out with some weird numbers.

 

Here is the proc - http://pastebin.com/d5e3d24ab

 

Here are the *expected* results (come back fine in Toad and MySQL Query Browser) - http://pastebin.com/d4babe393

 

Here is what I'm getting in SQLYog and my PHP script - http://pastebin.com/d4847f26a

 

Notice the 544 values -- that's what's throwing me off.  Any insight would be MOST welcome!

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.