mysql - php pdo search column array

Question

table name - animationmaster

column - animationdate ,type= varchar

column - animationno ,type= varchar

data in each column are like below..

animationno = 300,301

animationdate = 300 - 23-03-2015,301- 23-04-2015

When user search 300 then it display output 300 - 23-03-2015 from animationdate

When user search 301 then it display output 301- 23-04-2015 from animationdate

my mean is if user hit 300 then it match in animationdate column and get values of 300 upto comma only.

plz help to get solution for this..array search

<?php   
$q = $_GET['q'];
$city = $database->getRows("SELECT animationdate  FROM animationmaster WHERE animationno = :animationno ", array(':animationno '=>"$q"));  
$info = array();
foreach($city as $row)
{       
    $generat = $row['animationdate'];           

    $info[] = array('date' =>$generat);
}
echo json_encode($info);
?> 

Answer 1

Waitting for answers