Suchen über mehrere MySQL-Felder

PHP:
	$sql1 = $this->base->db->sql_query("SELECT * FROM " . $this->base->db->prefix . "_tabelle
	WHERE field1 = '" . intval($_POST['field2']) . "'
	AND
	(
		field3 LIKE '%" . pwcAddSlashes($_POST['suchtext']) . "%'
		OR field4 LIKE '%" . pwcAddSlashes($_POST['suchtext']) . "%'
		OR field5 LIKE '%" . pwcAddSlashes($_POST['suchtext']) . "%'
		OR field6 LIKE '%" . pwcAddSlashes($_POST['suchtext']) . "%'
	)
	ORDER BY field7 DESC");
 
Zurück