|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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! |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
What makes this even more puzzling is that if I execute the query
outside of the proc, with hard-coded values, it works fine. |
|
![]() |
| Outils de la discussion | |
|
|