[open_code]
$Qtotal = mysql_query("SELECT * FROM survey_detail,surveying,tree,plant,user
where survey_detail.sur_id=surveying.sur_id and survey_detail.tree_id=tree.tree_id and
tree.pnt_id=plant.pnt_id and surveying.user_id = user.user_id and ".$Search2." like '%".$Search."%' ") mysql_error() ;
[/close_code]
มันขึ้น error Column 'tree_id' in where clause is ambiguous
Column 'sur_id' in where clause is ambiguous
Column 'user_id' in where clause is ambiguous
Column 'pnt_id' in where clause is ambiguous
จะแก้ยังไงหรอครับ รบกวนด้วย
รบกวนสอบถามวิธีแก้ error Column 'tree_id' in where clause is ambiguous
$Qtotal = mysql_query("SELECT * FROM survey_detail,surveying,tree,plant,user
where survey_detail.sur_id=surveying.sur_id and survey_detail.tree_id=tree.tree_id and
tree.pnt_id=plant.pnt_id and surveying.user_id = user.user_id and ".$Search2." like '%".$Search."%' ") mysql_error() ;
[/close_code]
มันขึ้น error Column 'tree_id' in where clause is ambiguous
Column 'sur_id' in where clause is ambiguous
Column 'user_id' in where clause is ambiguous
Column 'pnt_id' in where clause is ambiguous
จะแก้ยังไงหรอครับ รบกวนด้วย