<?php
	/*
	* PHP Ajax AutoSuggest Jquery Plugin
	* //www.amitpatil.me/
	*
	* @version
	* 1.0 (Dec 20 2010)
	* 
	* @copyright
	* Copyright (C) 2010-2011 
	*
	* @Auther
	* Amit Patil (amitpatil321@gmail.com)
	* Maharashtra (India) m
	*
	* @license
	* This file is part of PHP Ajax AutoSuggest Jquery Plugin.
	* 
	* PHP Ajax AutoSuggest Jquery Plugin is freeware script. you can redistribute it and/or modify
	* it under the terms of the GNU Lesser General Public License as published by
	* the Free Software Foundation, either version 3 of the License, or
	* (at your option) any later version.
	* 
	* PHP Ajax AutoSuggest Jquery Plugin is distributed in the hope that it will be useful,
	* but WITHOUT ANY WARRANTY; without even the implied warranty of
	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	* GNU General Public License for more details.
	* 
	* You should have received a copy of the GNU General Public License
	* along with this script.  If not, see <//www.gnu.org/copyleft/lesser.html>.
	*/

	include("config.php");
	extract($_POST);

	if	   ($match == "starts")		$like = " like '".$data."%' ";
	elseif ($match == "ends")		$like = " like '%".$data."' ";
	elseif ($match == "contains")   $like = " like '%".$data."%' ";

	$sql = "select * from ".$db_table." where ".$db_column." ".$like." limit ".$limit;
	$result = mysql_query($sql) or die(mysql_error());
	if(mysql_num_rows($result))
	{
		while($row = mysql_fetch_array($result)){
		  if($getId == 1) $list .= $row['id']."-";
			$list .= strtolower($row['quote'])."|";
		}

		// send all collected data to the client
		$list = substr($list,0,-1);
		echo $list;
	}
	else
		echo 0;
?>