darkroastbeans Posted September 16, 2007 Share Posted September 16, 2007 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! Quote Link to comment https://forums.phpfreaks.com/topic/69570-irregular-stored-proc-results-giving-me-headaches-please-help/ Share on other sites More sharing options...
darkroastbeans Posted September 16, 2007 Author Share Posted September 16, 2007 What makes this even more puzzling is that if I execute the query outside of the proc, with hard-coded values, it works fine. Quote Link to comment https://forums.phpfreaks.com/topic/69570-irregular-stored-proc-results-giving-me-headaches-please-help/#findComment-349586 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.