Code: Select all
<?php
/*Includes for the hours*/
$link = mysql_connect("localhost", "AppUser_HAE", "1234");
if (!$link)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("HAE", $link);
$result = mysql_query("call hae.disp_cch");
while($row = mysql_fetch_array($result))
{
$cch_mo = $row['cch_mo'];
$cch_tu = $row['cch_tu'];
$cch_we = $row['cch_we'];
$cch_th = $row['cch_th'];
$cch_fr = $row['cch_fr'];
$cch_sa = $row['cch_sa'];
$cch_su = $row['cch_su'];
$cch_c1 = $row['cch_c1'];
$cch_c2 = $row['cch_c2'];
$cch_c3 = $row['cch_c3'];
$cch_c4 = $row['cch_c4'];
$cch_c5 = $row['cch_c5'];
}
mysql_close($link);
?>
I've given AppUser_HAE permissions for execute grant to all the stored procedures. I've also even logged into the mysql server with the AppUser_HAE and executed the procedure myself and it works.
What's going on here.....