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' Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.