Click here to Skip to main content
Rate this: bad
good
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 19:16pm
Comments
SS Reddy at 10-May-13 0:20am
   
Can u provide the code you are using to fetch the data from mysql
Member 9762654 at 10-May-13 0:30am
   
$sql=mysql_query("call prcSelRole()");
$n=mysql_num_rows($sql);// always displays 0
echo $n;
Mohibur Rashid at 10-May-13 1:16am
   
try myslqi_ instead mysql_. mysql_ function is not doing very well with procedure
Member 9762654 at 10-May-13 2:16am
   
ok let me try
Member 9762654 at 10-May-13 2:25am
   
no its not working
Mohibur Rashid at 10-May-13 2:27am
   
then call your procedure by running mysql client in console mode and see the result
Member 9762654 at 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 at 10-May-13 2:34am
   
how many data do you expect on your host? may be there is no output at all
Member 9762654 at 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
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 120
4 DamithSL 105
0 OriginalGriff 6,045
1 DamithSL 4,611
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2014
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