Duke Posted August 22, 2014 Share Posted August 22, 2014 Hi Chapter 8 index.php-home page Display where a few items on sale are show I am using $r = mysqli_query($dbc, 'CALL select_sale_items(true)');.....this is not formatting the price(ie 500) I change to $r = mysqli_query($dbc, 'CALL select_sale_items(false)');...this is formatting the price(ie$5.00) I am thinking there is an error in my select_sale_items stored procedure in the IF beginning section.. I have not found the error.. My Question is... Could I be not seeing the error in this stored procedure? Thank you Link to comment Share on other sites More sharing options...
Larry Posted August 22, 2014 Share Posted August 22, 2014 Both queries return a result set that will be handled by the same PHP code. If the results differ, but the same PHP code is used, then the problem must be in the result set. That means is must be in the stored procedure. Link to comment Share on other sites More sharing options...
Duke Posted August 23, 2014 Author Share Posted August 23, 2014 Thank you for your help Larry... I had an error in my stored procedure... Link to comment Share on other sites More sharing options...
Larry Posted August 25, 2014 Share Posted August 25, 2014 Thanks for confirming! Link to comment Share on other sites More sharing options...
Recommended Posts