Click here to Skip to main content
13,044,428 members (131,450 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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
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.170713.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2017
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