Mercurial > hg > extraction-interface

diff interface/check_sections.php @ 4:883ad980a43b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add dynasty column to table books
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 27 Jan 2015 16:40:30 +0100
parents ef6d0c6a13d7
children 0e9a7c69f22c
line wrap: on
line diff
--- a/interface/check_sections.php	Mon Jan 26 12:19:39 2015 +0100
+++ b/interface/check_sections.php	Tue Jan 27 16:40:30 2015 +0100
@@ -71,18 +71,19 @@
 function checkSections_sort_by($sort_by){
 	switch ($sort_by) {
 		case 'time':
-			$query="(SELECT name AS book_name,level1,level2,period,start_year,id from books ORDER BY start_year)";
+			$query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)";
 			$result = mysql_query($query);
 			echo mysql_num_rows($result)." result(s)<br><br>";
 			echo "<table>";
 			echo "<tr>";
-			echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='start_year'>start_year";
+			echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year";
 		        while ($row = mysql_fetch_assoc($result)) {
 				$str="<tr>";	
 				$str.="<td>".$row['book_name'];
 				$str.="<td>".$row['level1'];
 				$str.="<td>".$row['level2'];
 				$str.="<td>".$row['period'];
+				$str.="<td>".$row['dynasty'];
 				$str.="<td>".$row['start_year'];
 				$str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>";
 				echo $str;	
@@ -106,7 +107,7 @@
         <head>
                 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
                 <link href="css/search.css" type="text/css" rel="stylesheet"/>
-                <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
+                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
                 <!--<script src="js/check_sections.js" charset="utf-8"></script>!-->
         </head>
         <body>