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
Germany, Bremen
Posts: 417
Joined: November 2001
Show All Member Profiles 
Forum Statistics
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 21,084
JoshPet 10,370
LK 7,395
Lord Dexter 6,709
Gizmo 5,781
Greg Hard 4,625
Top Posters(30 Days)
isaac 16
driv 13
Gizmo 5
Today's Statistics
Currently Online 954
Topics Created 0
Posts Made 0
Users Online 2
Birthdays 24
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build
PHP: 5.4.45 Page Time: 0.030s Queries: 14 (0.008s) Memory: 3.1774 MB (Peak: 3.4262 MB) Data Comp: Zlib Server Time: 2019-03-25 10:14:22 UTC