Search the Community

Hi All, I'm a newbie in PHP/MySQL and this place has been helpful, Larry thanks. My coffee site is not coming up while knowledge is power is up and firing. I was very happy until my coffee site refuses to come up. This is the error message I'm getting: An error occurred in script 'C:\xampp\htdocs\ecom\html\views\home.html' on line 14: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given Array ( [0] => Array ( [function] => my_error_handler [args] => Array ( [0] => 2 [1] => mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [2] => C:\xampp\htdocs\ecom\html\views\home.html [3] => 14 [4] => Array ( [GLOBALS] => Array *RECURSION* [_POST] => Array ( ) [_GET] => Array ( ) [_COOKIE] => Array ( [phpSESSID] => 30nvl7ovcsvt9lgskus5jacdq6 ) [_FILES] => Array ( ) [live] => [contact_email] => you@example.com [page_title] => Coffee - Wouldn't You Love a Cup Right Now? [dbc] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $ [client_version] => 50008 [connect_errno] => 0 [connect_error] => [errno] => 1305 [error] => PROCEDURE ecommerce1.select_sale_items does not exist [field_count] => 0 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.16 [server_version] => 50516 [sqlstate] => 42000 [protocol_version] => 10 [thread_id] => 406 [warning_count] => 0 ) [r] => ) ) ) [1] => Array ( [file] => C:\xampp\htdocs\ecom\html\views\home.html [line] => 14 [function] => mysqli_num_rows [args] => Array ( [0] => ) ) [2] => Array ( [file] => C:\xampp\htdocs\ecom\html\index.php [line] => 20 [args] => Array ( [0] => C:\xampp\htdocs\ecom\html\views\home.html ) [function] => include ) ) Please what am I doing wrong. I didn't change anything except my URI. Thanks for rescuing me in advance.