Themes & Topics: Search the Database
divider
New Search
Total Records in Database
Click on items below to see many of the photographs, videos, biographies and other
resource materials used to produce THE WAR:
TOWNS 0) { while ($row = mysql_fetch_array($result)) { $SQL_count = "SELECT DISTINCT(tbl_main__objects.objects_id) FROM tbl_join__objects_towns INNER JOIN tbl_main__objects ON tbl_join__objects_towns.objects_id = tbl_main__objects.objects_id WHERE towns_id = ".$row['towns_id']. " AND tbl_main__objects.objects_active = 1 AND tbl_main__objects.objects_status = 1 ORDER BY objects_id"; $result_count = mysql_query($SQL_count) or die(mysql_error()); $row_count = mysql_num_rows($result_count); ?>
 ()
SUBJECTS 0) { while ($row = mysql_fetch_array($result)) { $SQL_count = "SELECT DISTINCT(tbl_main__objects.objects_id) FROM tbl_join__objects_subjects INNER JOIN tbl_main__objects ON tbl_join__objects_subjects.objects_id = tbl_main__objects.objects_id INNER JOIN tbl_look__subjects ON tbl_look__subjects.subjects_id = tbl_join__objects_subjects.subjects_id WHERE tbl_look__subjects.subjects_id = ".$row['subjects_id']. " AND tbl_main__objects.objects_active = 1 AND tbl_main__objects.objects_status = 1"; $result_count = mysql_query($SQL_count) or die(mysql_error()); $row_count = mysql_num_rows($result_count); //echo("
$SQL_count
"); ?>
 ()
MEDIA 21 AND tbl_look__media.media_id<>22) ORDER BY media_title"; $result = mysql_query($SQL) or die(mysql_error()); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { while ($row = mysql_fetch_array($result)) { $SQL_count = "SELECT media_id FROM tbl_join__objects_media INNER JOIN tbl_main__objects ON tbl_join__objects_media.objects_id = tbl_main__objects.objects_id WHERE media_id = ".$row['media_id']. " AND tbl_main__objects.objects_active = 1 AND tbl_main__objects.objects_status = 1"; $result_count = mysql_query($SQL_count) or die(mysql_error()); $row_count = mysql_num_rows($result_count) ?>
 ()
BATTLES 0) { while ($row = mysql_fetch_array($result)) { ?>
PEOPLE 0) { while ($row = mysql_fetch_array($result)) { ?>