im creating a website and within the website there will be a search box that will let you search for items on your website. I have code but i keep getting an error message. 

```
<?php
include 'connect.php';

$search = $_POST['search']."*";

$search_query = $link->prepare("SELECT name FROM products WHERE MATCH(name) 
AGAINST (? IN BOOLEAN MODE)")
$search_query->bind_param('s', $search);
$search_query->execute();
$search_query->store_result();

$search_rows = $search_query->num_rows;
$search_query->bind_result($product_name);

if($search_rows > 0){
    while($search_query->fetch()){
        echo "Your search returned $search_rows results";
        echo $product_name."<br>";
    }
} else { echo "Your search returned no results, sorry :("; }   

```

is it possible to run a search using a mysql query from the database to return searches??

Any advice would be deeply appreciated. 

Thanks