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
G
Gorf Offline OP
Junior Member
Gorf  Offline OP
Junior Member
G

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
· Interserver.net
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 458
Joined: February 2008
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,454
Posts293,496
Members13,800
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,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
Today's Statistics
Currently Online 852
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180915.dev)
Page Time: 0.063s Queries: 14 (0.043s) Memory: 3.2300 MB (Peak: 3.4856 MB) Zlib enabled. Server Time: 2018-09-21 19:54:39 UTC