# HG changeset patch # User Zoe Hong # Date 1424795396 -3600 # Node ID a8ae5cbc336485b32fd5dcd1a09ba50c15a633e3 # Parent c805470cefeebccd1c2f927254bd7d25ccf6c730 update topic_tag_relation table when adding new tag diff -r c805470cefee -r a8ae5cbc3364 develop/models/extractapp.php --- 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); diff -r c805470cefee -r a8ae5cbc3364 develop/views/Extractapp/edittaglist.php --- a/develop/views/Extractapp/edittaglist.php Tue Feb 24 16:09:59 2015 +0100 +++ b/develop/views/Extractapp/edittaglist.php Tue Feb 24 17:29:56 2015 +0100 @@ -3,7 +3,6 @@ $taglistArray = $viewmodel['taglistArray']; $topic_id = $viewmodel['topic_id']; $largestId = $viewmodel['largest_id']; -var_dump($largestId); ?> @@ -25,7 +24,8 @@ --> -