<?php
mysql_connect("localhost","root","");
mysql_select_db("mkdb");
$term=trim(strip_tags($_GET['term']));
$qstring="SELECT * FROM mk_project WHERE projectID LIKE '".$term."%'";
$result=mysql_query($qstring);
while($row=mysql_fetch_array($result)){
$row['value']=htmlentities(stripslashes($row['projectID']));
$row['projectID']=(int)$row['projectID'];
$row_set[]=$row;
}
echo json_encode($row_set);
?>