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! 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. 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
Archived
This topic is now archived and is closed to further replies.