Problems with Content Islands and SQL - 01/13/2005 4:38 PM
Okay when I make the content island it does this query:
SELECT t1.B_Number,t1.B_Board,t1.B_Subject,t1.B_Body,t2.U_Username,t1.B_Posted,t1.B_PosterId FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_PosterId = t2.U_Number AND B_Topic = '1' AND B_Board IN () ORDER BY t1.B_Posted DESC LIMIT 1
The problem is AND B_Board IN () I've never seen this before in mySQL
Running : MySQL 4.0.22
on : ubb.threads 6.5
SELECT t1.B_Number,t1.B_Board,t1.B_Subject,t1.B_Body,t2.U_Username,t1.B_Posted,t1.B_PosterId FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_PosterId = t2.U_Number AND B_Topic = '1' AND B_Board IN () ORDER BY t1.B_Posted DESC LIMIT 1
The problem is AND B_Board IN () I've never seen this before in mySQL
Running : MySQL 4.0.22
on : ubb.threads 6.5