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);
?>