Mercurial > hg > extraction-interface
diff develop/models/extractapp.php @ 22:a8ae5cbc3364
update topic_tag_relation table when adding new tag
| author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
|---|---|
| date | Tue, 24 Feb 2015 17:29:56 +0100 |
| parents | c805470cefee |
| children | a879f6b9d166 |
line wrap: on
line diff
--- a/develop/models/extractapp.php Tue Feb 24 16:09:59 2015 +0100 +++ b/develop/models/extractapp.php Tue Feb 24 17:29:56 2015 +0100 @@ -494,9 +494,14 @@ // === for manage tag list === public function EditTaglist($_postdata) { - - $query = "SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'taglist'"; - $largest_id = mysql_query($query); + $query = "SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='taglist'"; + $result = mysql_query($query); + if (!$result) { + echo json_encode(mysql_error()); + } + $row = mysql_fetch_assoc($result); + $largest_id = $row['AUTO_INCREMENT']; + $topic_id = $_postdata['topic_id']; $result = $this->GetTaglistByTopicID($topic_id);