sykorazza

So I wanted to make an automatic table displaying all the products from the database, where you can click on its name and view the whole information of the product. The problem is that it wouldn't load the product's information. Error 1: Warning: Wrong parameter count for mysqli_stmt_bind_result() in C:\wamp\www\goldenrod\index.php on line 59 Error 2: Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, object given in C:\wamp\www\goldenrod\index.php on line 61 Connection to the database: <?php //Database Connections $conn = mysqli_connect('localhost', 'root', '', 'lionsierra_db') or die("Cannot find specified server"); //Product Database $db_products = "SELECT * FROM `products`"; $products = mysqli_query($conn, $db_products); ?> Here is the function: //View product if(isset($_GET['view_product'])) { //now let's build out our query $view_product_statement = mysqli_prepare($conn, "SELECT * FROM `products` WHERE `ID` = ?"); mysqli_stmt_bind_param($view_product_statement, 'i', $_GET['view_product']); mysqli_stmt_execute($view_product_statement); mysqli_stmt_bind_result($view_product_statement); while($product=mysqli_fetch_assoc($view_product_statement)){ //Display a product echo "<p><span> <span style='font-weight:bold;'>" . $product['name'] . "</span><br/> <span>$" . $product['price'] . "</span><br/> <span>" . $product['category'] . "</span><br/> <span>" . $product['description'] . "</span> </p>"; } mysqli_stmt_close($view_product_statement); }else{ //View all products echo '<table width="600" border="1" cellpadding="1" cellspacing="1"> <tr> <th>Name</th> <th>Price</th> <th>Category</th> </tr>'; while($product=mysqli_fetch_assoc($products)) { echo "<tr> <td><a href='./index.php?view_product=" . $product['ID'] . "'>". $product['name'] . "</a></td> <td>" . $product['price'] . "</td> <td>" . $product['category'] . "</td> </tr>"; $ID = $product['ID']; } } Kudos!