sql error help me please
taziekisland
Join date: May 22nd 2011
Community posts: 5
View Profile
Send Message
+Follow
SQL query error!
Error infomation:[SQL]
select c.*,u.username,u.avatar,u.fullname from jcow_comments as c left join jcow_accounts as u on u.id=c.uid where c.stream_id='1' and hide = 0 order by id asc

[Error]
Unknown column 'hide' in 'where clause'
Jun 25th 2011, 12:01 pm
gilmichelz
Join date: Oct 6th 2010
Community posts: 56
View Profile
Send Message
+Follow
Look in your Mysql table if the correspondant colomn "hide" exist or not!
Jun 25th 2011, 10:41 pm
taziekisland
Join date: May 22nd 2011
Community posts: 5
View Profile
Send Message
+Follow
how to handle it like where? Could I still learn this
Jun 26th 2011, 3:07 am