query("SELECT * FROM `art_collection_records` WHERE (`department` LIKE '%".$search2."%') OR (`building` LIKE '%".$_POST['search']."%') OR (`room_number` LIKE '%".$_POST['search']."%') OR (`contact_person` LIKE '%".$_POST['search']."%') OR (`category` LIKE '%".$_POST['search']."%') OR (`painting` LIKE '%".$_POST['search']."%') OR (`drawing` LIKE '%".$_POST['search']."%') OR (`mixed` LIKE '%".$_POST['search']."%') OR (`print` LIKE '%".$_POST['search']."%') OR (`sculpture` LIKE '%".$_POST['search']."%') OR (`craft` LIKE '%".$_POST['search']."%') OR (`title` LIKE '%".$_POST['search']."%') OR (`artist` LIKE '%".$_POST['search']."%') OR (`how_acquired` LIKE '%".$_POST['search']."%') OR (`back_notes` LIKE '%".$_POST['search']."%') OR (`written_description` LIKE '%".$_POST['search']."%') ORDER BY title ASC LIMIT 1200"); $row = $query->num_rows; if($row > 0){ $output = ""; $output .= "

Search Results

"; while($fetch = $query->fetch_array()){ $output .= " "; } $output .="
End of Results
ID Department Building Room Number Contact Person Category Painting Drawing Mixed Print Framed Sculpture Craft Base 2D Size 3D Size Title Artist Date Created Date Acquired Back Notes Description Image 1 Image 2 Image 3
".$fetch['acs_id']." ".$fetch['department']." ".$fetch['building']." ".$fetch['room_number']." ".$fetch['contact_person']." ".$fetch['category']." ".$fetch['painting']." ".$fetch['drawing']." ".$fetch['mixed']." ".$fetch['print']." ".$fetch['framed']." ".$fetch['sculpture']." ".$fetch['craft']." ".$fetch['base']." ".$fetch['two_d_size']." ".$fetch['three_d_size']." ".$fetch['title']." ".$fetch['artist']." ".$fetch['date_created']." ".$fetch['date_acquired']." ".$fetch['back_notes']." ".$fetch['written_description']."
Return to Top of Page "; echo $output; }else{ echo "

Search Not Found!

"; } } ?>