SELECT * FROM car inner join data on car.id_card=data.id_card order by enddate asc AND (data.name LIKE '%ราตรี%' )

<?

	include('config.php');    

	$strSQL = " SELECT  *  FROM car inner join data on car.id_card=data.id_card  order by enddate asc ";
	$i=1;
	if($_POST["ddlSelect"] != "" and  $_POST["txtKeyword"]  != '')
	{
	  $strSQL .= " AND (".$_POST["ddlSelect"]." LIKE '%".$_POST["txtKeyword"]."%' ) ";
	}	


	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>

<?
include('config.php'); 
$i=1;
$strSQL = " SELECT * FROM car inner join data on car.id_card=data.id_card ";
if($_POST["ddlSelect"] != "" and $_POST["txtKeyword"] != ''){
$strSQL .= " AND   ตรงนี้ต้องมีชื่อฟิลด์ที่มีค่าที่ต้องการหาด้วยครับ LIKE '%".$_POST["txtKeyword"]."%' ";
}	

$strSQL .=" order by enddate asc";

$objQuery = mysql_query($strSQL) or die (mysql_error());
?>

<?
include('config.php');    

$strSQL = " SELECT  *  FROM car LEFT JOIN data on car.id_card=data.id_card   WHERE 1 ";
$i=1;
if($_POST["ddlSelect"] != "" and  $_POST["txtKeyword"]  != '')
{
  $strSQL .= " AND (".$_POST["ddlSelect"]." LIKE '%".$_POST["txtKeyword"]."%' ) ";
}

$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>