<?php
 include("../include/session.php");

 $q=$_GET['q'];
 $my_data=mysql_real_escape_string($q);
 //$mysqli=mysqli_connect('localhost','username','password','databasename') or die("Database Error");
 $query="SELECT CompanyName FROM customer WHERE CompanyName LIKE '%$my_data%' ORDER BY CompanyName";
 $result = mySQL_query($query) or die ("Error in query:   $query . * ". mySQL_error());
 if($result)
 {
  while($row=mysql_fetch_array($result))
  {
   echo $row['CompanyName']."\n";
  }
 }
?>
