0) { $condition = $condition." AND "; } $condition = $condition."productname LIKE '%".$stext."%'"; $n++; } echo $condition."
"; include("connect.php"); mysqli_query($mysqli,"SET character_set_results=utf8"); mysqli_query($mysqli,"SET character_set_client=utf8"); mysqli_query($mysqli,"SET character_set_connection=utf8"); $sql = "SELECT * FROM allstores WHERE ".$condition." group by barcode ORDER BY `allstores`.`imageurl` DESC LIMIT 0,100"; $result = $mysqli->query($sql); while($row=$result->fetch_row()) { echo $row[0]."|1|".$row[1]."|2|".$row[2]."|3|".$row[11].chr(13).chr(10); } ?>