Re: Regarding calling stored procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
thank you very much for your response.We tried to solve that problem by running but we got following warning 

[Thu Dec 13 10:39:09 2007] [error] [client 127.0.0.1] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in F:\\Softwares\\php\\htdocs\\vijaya\\sample_111207.php on line 13
[Thu Dec 13 10:39:09 2007] [error] [client 127.0.0.1] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in F:\\Softwares\\php\\htdocs\\vijaya\\sample_111207.php on line 15
Please give us correct solution...

Pradeep Rawat <rawat167@xxxxxxxxx> wrote:                               <?php
 $mysql = mysql_connect
 ("localhost", "root", "abcd", "empdb");
 $res_new=array();
 $Query1="";$Query="";$result1=0;
 $url="sciencedaily.com";
 $Query1="call GetExpert_last('$url')";
 echo $Query1;
 echo "<br/>";
 $res = $mysql->query("$Query1");
 if(mysqli_num_rows($res)>0)
 {
 $row = mysql_fetch_row($res);
 $res = $row[0];
 $res_new[] = $row[0];
 $res_new[] = $row[1];
 //$mysqli->close();
 //$res=NULL;
 *********$Query="call GetExpert_lastvalue($res)";
 echo $Query;echo "<br/>";
 $result1=5;
 $result1=$mysql->query("$Query");
 echo "hai";echo "<br/>";
 echo $result1;
 if(mysql_num_rows($result1)>0)
 {
 $expert_value= mysql_fetch_row($result1);
 $res_new[]=$expert_value[0];
 $res_new[]=$expert_value[1];
 
 $res_new[]=$expert_value[2];
 
 } else
 {
 $res_new[]="None";
 }
 }
 
 for($i=0;$i<count($res_new);$i++)
 {
 $strid= $res_new["$i"];
 echo $strid;
 echo "<br/>";
 }
 
 ?>
 
 [Non-text portions of this message have been removed]
 
 
     
                               

       
---------------------------------
 Get the freedom to save as many mails as you wish. Click here to know how.

[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux