Login     Sign up
sql error help me please
taziekisland (@taziekisland)
Join date: May 22nd 2011
Community posts: 5
View Profile
Send Message

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'

157 months ago
Gilbert Michel (@gilmichelz)
Join date: Oct 6th 2010
Community posts: 56
View Profile
Send Message

Look in your Mysql table if the correspondant colomn "hide" exist or not!

157 months ago
taziekisland (@taziekisland)
Join date: May 22nd 2011
Community posts: 5
View Profile
Send Message

how to handle it like where? Could I still learn this

157 months ago