•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 428,570 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,629 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 923 | Replies: 2 | Solved
 |
•
•
Join Date: Jun 2007
Posts: 18
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
Hi. I'm currently trying my hands on PHP and MySQL.
I understand how to retrieve results from SELECT statements in PHP? However, I'm not exactly sure of how to do it when a procedure call is made e.g.
...(code continues)
1 row is expected from the CALL statement so there may be no need of the While Loop.
Can someone please help?
I understand how to retrieve results from SELECT statements in PHP? However, I'm not exactly sure of how to do it when a procedure call is made e.g.
$query = "CALL mach_validity($student_id, @result)"; if ($result = $mysqli->query($query) { while($row = $result->fetch_assoc()) { $ returned_val =$row['@result']} }
1 row is expected from the CALL statement so there may be no need of the While Loop.
Can someone please help?
•
•
Join Date: Aug 2005
Posts: 4,782
Reputation:
Rep Power: 17
Solved Threads: 319
I'm not a programmer. My attitude starts with ignorance, holds steady at conversation, and ends with a trip to the hospital. Get used to it.
•
•
Join Date: Jun 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
It's been helpful. I've decided to use IN parameters only while declaring local variables in the procedure to receive the values I need. I then add a SELECT statement of these variables within the procedure.Thank you for your help. It got me far.
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- return result set in SPs (MySQL)
- Why does my CALL statement return NULL in PHP? (PHP)
- Something wrong with this (Visual Basic 4 / 5 / 6)
- Can you fix the problem (Visual Basic 4 / 5 / 6)
- passing arrays in visual basic (Visual Basic 4 / 5 / 6)
Other Threads in the PHP Forum
- Previous Thread: passing session
- Next Thread: Retrieving and comparing data from arrays
