I need a help resolving a PHP query

Vote count:

-1

Can you please tell me the wrong with this query ?

        $q = '%franci%';

        $liveSearch=$stmt->prepare("SELECT keyword FROM keyword WHERE keyword LIKE :keyword ORDER BY id DESC LIMIT 10");
        $liveSearch->execute(array(':keyword' => $q));
        if ($liveSearch->fetch() <= 0) {
            echo "no results";
        }else {

            echo $liveSearch->rowCount();

            while($row=$liveSearch->fetch()){
                echo $row['keyword'];
            }
        }

In my DB i have two rows

1-> Francian

2-> Franciano

• 
  

  rowCount() echos 2

  
  


• 
  

  While gives me only Franciano

  
  

Where'is Francian ? And how to resolve this ? Thanks

asked 55 secs ago

Simdine

41

I need a help resolving a PHP query