PHP mySQL Stored Procedure

[diex]

mySQL Version : 5.0.19-nt

PHP : 5.1.4

 

I cant do this! :'(

When I run the following code I always get an unexptected end. My query works from the mySQL command prompt. Even if I remove everything after $query I still get the unexpected end. It looks like PHP is not supporting the stored procedure.

 

<? 

include("sqlConnect.php"); 
$query1 = ("call sp_Performance_RevA_Change ('miamiprobe'));
$result1 = mysql_query($query1);
$num=mysql_numrows($result1);
$i=0;
while ($i < $num) {
// this where I want to assign the return values.
}

?>

 

 

So if I can not get that to work... is it possible to do the acutal stored procedure in php? Anyone assist? Thanks

 

SELECT * 
FROM
`http_get_performance_daily`
Inner Join `probe_reva_upgrade` ON `http_get_performance_daily`.`probeName` = `probe_reva_upgrade`.`ProbeName`
WHERE
`http_get_performance_daily`.`ProbeName` = location AND
`http_get_performance_daily`.`Date` >= date_sub(`probe_reva_upgrade`.`Date`, interval 10 day) AND
`http_get_performance_daily`.`Date` <= date_sub(`probe_reva_upgrade`.`Date`, interval -10 day)
order by
`http_get_performance_daily`.`Date` ASC;

 

 

 

 

[bwcc]

line 2 - missing closing "

line 4 - mysql_num_rows