Click here to Skip to main content
12,399,561 members (53,458 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: PHP MySQL
Hi all,
I have created a small web application using php and mysql for fetching data in mysql i have used stored procedure before hosting the application all worked fine but after hosting mysql stored procedure not fetching any data not showing any error and the query executing succesfull but no fetching occurs if we use query instead its working fine . Pls help me to solve this issue

Thanks in advance
Posted 9-May-13 18:16pm
Comments
SS Reddy 10-May-13 0:20am
   
Can u provide the code you are using to fetch the data from mysql
Member 9762654 10-May-13 0:30am
   
$sql=mysql_query("call prcSelRole()");
$n=mysql_num_rows($sql);// always displays 0
echo $n;
Mohibur Rashid 10-May-13 1:16am
   
try myslqi_ instead mysql_. mysql_ function is not doing very well with procedure
Member 9762654 10-May-13 2:16am
   
ok let me try
Member 9762654 10-May-13 2:25am
   
no its not working
Mohibur Rashid 10-May-13 2:27am
   
then call your procedure by running mysql client in console mode and see the result
Member 9762654 10-May-13 2:33am
   
in backend its working fine and no issues before the app hosting also only after hosting its giving issues
Mohibur Rashid 10-May-13 2:34am
   
how many data do you expect on your host? may be there is no output at all
Member 9762654 10-May-13 3:09am
   
two rows are there if no data means it should not display before hosting know and another thing is only select procedure not working i am able to update, insert and delete

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100