Previous Thread
Next Thread
Print Thread
Rate Thread
Problems with Content Islands and SQL #283069
01/13/2005 9:38 AM
01/13/2005 9:38 AM
Joined: Jan 2006
Posts: 4
Gorf Offline OP
Junior Member
Gorf  Offline OP
Junior Member
Joined: Jan 2006
Posts: 4
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

Sponsored Links

Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
Visit Us on Facebook
Member Spotlight
Portland, OR, USA
Posts: 5,936
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,936
Greg Hard 5,533
Top Posters(30 Days)
driv 1
isaac 1
Today's Statistics
Currently Online 712
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 19
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

Powered by UBB.threads™ PHP Forum Software 7.6.2
(Snapshot build
Page Time: 0.233s Queries: 14 (0.050s) Memory: 3.2139 MB (Peak: 3.3206 MB) Zlib enabled. Server Time: 2018-03-20 08:00:56 UTC