"; $sq112ZaAVV="SELECT * FROM $table_name103 WHERE van2 = '$searchP' "; $result3AVV = @mysql_query($sq112ZaAVV,$connection) or die(mysql_error()); $num33AVV = mysql_num_rows($result3AVV); if ($searchP >0 AND $num33AVV>0){ $searchtalk="- Answer #: $searchP"; $searchCheck=''; //$searchCheck="AND (company LIKE '%$searchP%' OR firstname LIKE '%$searchP%' OR email LIKE '%$searchP%'OR lastname LIKE '%$searchP%' OR van1 LIKE '%$searchP%' OR van2 LIKE '%$searchP%' OR van3 LIKE '%$searchP%' OR van4 LIKE '%$searchP%' OR van5 LIKE '%$searchP%' OR van6 LIKE '%$searchP%' OR van7 LIKE '%$searchP%' OR van8 LIKE '%$searchP%' OR van9 LIKE '%$searchP%' OR van10 LIKE '%$searchP%' OR van11 LIKE '%$searchP%' OR van12 LIKE '%$searchP%' OR van13 LIKE '%$searchP%' OR van14 LIKE '%$searchP%' OR van15 LIKE '%$searchP%' OR van16 LIKE '%$searchP%' OR van17 LIKE '%$searchP%' OR van18 LIKE '%$searchP%' OR van19 LIKE '%$searchP%' OR van20 LIKE '%$searchP%' OR van21 LIKE '%$searchP%' OR van22 LIKE '%$searchP%' OR van23 LIKE '%$searchP%' OR van24 LIKE '%$searchP%' OR van25 LIKE '%$searchP%' OR van26 LIKE '%$searchP%' OR van27 LIKE '%$searchP%' OR van28 LIKE '%$searchP%' OR van29 LIKE '%$searchP%' OR van30 LIKE '%$searchP%' OR van31 LIKE '%$searchP%' OR van32 LIKE '%$searchP%' OR van33 LIKE '%$searchP%' OR van34 LIKE '%$searchP%' OR van35 LIKE '%$searchP%' OR van36 LIKE '%$searchP%' OR van37 LIKE '%$searchP%' OR van38 LIKE '%$searchP%' OR van39 LIKE '%$searchP%' OR van40 LIKE '%$searchP%' OR van41 LIKE '%$searchP%' OR van42 LIKE '%$searchP%' OR van43 LIKE '%$searchP%' OR van44 LIKE '%$searchP%' OR van45 LIKE '%$searchP%' OR van46 LIKE '%$searchP%' OR van47 LIKE '%$searchP%' OR van48 LIKE '%$searchP%' OR van49 LIKE '%$searchP%' OR van50 LIKE '%$searchP%' OR van51 LIKE '%$searchP%' OR van52 LIKE '%$searchP%' OR van53 LIKE '%$searchP%' OR van54 LIKE '%$searchP%' OR van55 LIKE '%$searchP%' OR van56 LIKE '%$searchP%') "; $searchCheck300="AND (van2 = '$searchP')"; // echo $searchCheck300; // echo $searchCheck; // create_date between '$lyear' AND '$tomorr' "; } ?>