Mercurial > hg > LGToc
diff check_sections.php @ 4:373c8ecad8b4
deploy to development server
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Tue, 24 Mar 2015 11:32:31 +0100 |
parents | 1f9d2bfe1d13 |
children | 7e04cbe8b2a0 |
line wrap: on
line diff
--- a/check_sections.php Fri Mar 20 15:32:58 2015 +0100 +++ b/check_sections.php Tue Mar 24 11:32:31 2015 +0100 @@ -1,6 +1,6 @@ <?php -include_once('Lib_mb_utf8.php'); -include_once('config.php'); +include_once('config/Lib_mb_utf8.php'); +include_once('config/config.php'); include_once('edit_section_db.php'); set_time_limit(0); ini_set('memory_limit', '-1'); @@ -78,7 +78,7 @@ HAVING COUNT( * ) >=".$count.") ORDER BY count DESC "; */ - $query="(SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count + $query="(SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections_index.name, start_page, end_page, COUNT( * ) AS count FROM sections_index JOIN books ON sections_index.books_id = books.id WHERE NOT EXISTS @@ -99,6 +99,10 @@ HAVING COUNT( * ) >=".$count.") ORDER BY count DESC "; $result = mysql_query($query); + if (!$result) { + echo mysql_error(); + return; + } echo mysql_num_rows($result)." result(s)<br><br>"; echo "<table>"; echo "<tr>"; @@ -195,7 +199,7 @@ <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> - <link href="css/search.css" type="text/css" rel="stylesheet"/> + <!-- <link href="css/search.css" type="text/css" rel="stylesheet"/> --> <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>