jwk811 Posted February 20, 2007 Share Posted February 20, 2007 $sql = "SELECT sum(av_weight) as av_weight FROM tbl_cart WHERE ct_session_id = '$sid'"; is there anything wrong with that? its saying.. Unknown column 'av_weight' in 'field list' Link to comment https://forums.phpfreaks.com/topic/39258-unknown-column/ Share on other sites More sharing options...
Jessica Posted February 20, 2007 Share Posted February 20, 2007 Is there a field called that in the table? Link to comment https://forums.phpfreaks.com/topic/39258-unknown-column/#findComment-189173 Share on other sites More sharing options...
jwk811 Posted February 20, 2007 Author Share Posted February 20, 2007 yes there is, thats why i dont understand Link to comment https://forums.phpfreaks.com/topic/39258-unknown-column/#findComment-189176 Share on other sites More sharing options...
Jessica Posted February 20, 2007 Share Posted February 20, 2007 Can we see the structure of the table? Try $sql = "SELECT sum(av_weight) as av_w FROM tbl_cart WHERE ct_session_id = '$sid'"; Maybe you can't use the same name if it already exists? Link to comment https://forums.phpfreaks.com/topic/39258-unknown-column/#findComment-189178 Share on other sites More sharing options...
jwk811 Posted February 20, 2007 Author Share Posted February 20, 2007 oh i see, i was looking at the wrong table.. lol Link to comment https://forums.phpfreaks.com/topic/39258-unknown-column/#findComment-189189 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.