Could you please help me implement this If statement to the query$where = array();$whereclause = '';if (!empty($mark)) { $where[] = "a.mark = '$model'";}if (!empty($model)) { $where[] = "a.model = '$mark'";}if (!empty($year)) { $where[] = "a.year = $year";}if (count($where > 0)) { $whereclause = 'WHERE ' . join(' AND ', $where);}
$result = mysql_query("SELECT * FROM `add_new_car` AS a INNER JOIN `image_add_car` AS b ON a.id_add_car = b.user_id WHERE (b.user_id, b.id_image_add_car) IN (SELECT user_id, MIN(id_image_add_car) FROM image_add_car GROUP BY user_id) AND a.mark='$model' and a.model='$mark' and a.year='$year' ORDER BY a.id_add_car");