Stivereamevax
New Member
I have two completely separate queries that were transferred over to procedures. When they were ad-hoc queries, they ran great but now that I have stored them, things have gotten strange.PHP calls a class method which returns the values of one of the procs. The second method is then called and fails. When I run the run the proc that PHP fails to give me, directly from the command line, it gives me the results just fine. This is certainly strange.Can someone tell me if I'm missing something? I'd be happy to post some code but in the interest of time, I figured I would ask and see if this is a common problem first.This is the function that connects;\[code\]function connect(){ $conn = mysql_connect($host, $user, $pass); if(!$conn){ echo 'Error: cannot connect'; }else{ $selectDB(); }}\[/code\]This is the proc that is failing:\[code\]BEGINSELECT name FROM source ORDER BY name ASC;END\[/code\]This is the first proc that returns the results.\[code\]BEGINSELECT cpw, cpw_id FROM cpw ORDER BY cpw ASC;END\[/code\]