1: if (preg_match("/^07[0-9]+$/",$sok)){ 2: $SQL1 = " WHERE mms.status='Aktiv' AND mnr = '$sok' AND (typ = 'image' OR typ = 'video') GROUP BY mms.id ORDER BY `mms` . `tilllagd_tid` DESC"; 3: $SQL2 = " FROM mms WHERE mms.status='Aktiv' AND mnr = '$sok' GROUP BY mms.id"; 4: } 5: elseif (preg_match("/^[0-9]+$/",$sok)){ 6: $SQL1 = " WHERE mms.status='Aktiv' AND mms.id = '$sok' AND (typ = 'image' OR typ = 'video') GROUP BY mms.id ORDER BY `mms` . `tilllagd_tid` DESC"; 7: $SQL2 = " FROM mms WHERE mms.status='Aktiv' AND mms.id = '$sok' GROUP BY mms.id"; 8: } 9: elseif ($sok != ""){ 10: $SQL1 = " WHERE mms.status='Aktiv' AND mms.subject = '$sok' AND (typ = 'image' OR typ = 'video') GROUP BY mms.id ORDER BY `mms` . `tilllagd_tid` DESC"; 11: $SQL2 = " FROM mms WHERE mms.status='Aktiv' AND mms.subject = '$sok' GROUP BY mms.id"; 12: } 13: else{ 14: $SQL1 = " WHERE mms.status='Aktiv' AND (typ = 'image' OR typ = 'video') GROUP BY mms.id ORDER BY `mms` . `tilllagd_tid` DESC"; 15: $SQL2 = " FROM mms WHERE mms.status='Aktiv' GROUP BY mms.id"; 16: