Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $criteria = array('ctitle', 'csubject', 'creference', 'cat_id', 'cmaterial', 'ctechnic', 'cartist', 'csource', 'stolen');
- $likes = "";
- foreach ( $criteria AS $criterion ) {
- if ( ! empty($_POST[$criterion]) ) {
- $value = mysql_real_escape_string($_POST[$criterion]);
- $likes .= " AND `$criterion` = '%$value%'";
- } elseif ( ! empty($_GET[$criterion]) ) {
- $value = mysql_real_escape_string($_GET[$criterion]);
- $likes .= " AND `$criterion` = '%$value%'";
- }
- }
- $query = "SELECT * FROM collections WHERE c_id>0" . $likes . " ORDER BY c_id ASC";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement