Home
News
Events
Bands
Labels
Venues
Pics
MP3s
Radio Show
Reviews
Releases
Buy$tuff
Forum
Classifieds
News
Localband
Shows
Show Pics
Polls
OT Threads
Other News
Movies
VideoGames
Videos
TV
Sports
Gear
/r/
Food
New Thread
New Poll
Miscellaneous
Links
E-mail
Search
login
New site? Maybe some day.
Username:
SPAM Filter:
re-type this
(values are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E, or F)
Select Color
orange
orange-red
crimson
red
firebrick
dark red
green
limegreen
teal
silver
sea-green
deeppink
tomato
coral
purple
indigo
burlywood
sandy brown
sienna
chocolate
FONT
XXSmall
XSmall
Small
Medium
Large
XL
XXL
:DG:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Char
†
‡
‰
♠
♣
♥
♦
‾
←
↑
→
↓
™
–
—
¡
¢
£
¤
¥
¦
§
¨
©
ª
«
¬
®
¯
°
±
²
³
´
µ
¶
·
¸
¹
º
»
¼
½
¾
¿
À
Á
Â
Ã
Ä
Å
Æ
Ç
È
É
Ê
Ë
Ì
Í
Î
Ï
Ð
Ñ
Ò
Ó
Ô
Õ
Ö
×
Ø
Ù
Ú
Û
Ü
Ý
Þ
ß
à
á
â
ã
ä
å
æ
ç
è
é
ê
ë
ì
í
î
ï
ð
ñ
ò
ó
ô
õ
ö
÷
ø
ù
ú
û
ü
ý
þ
ÿ
b
i
u
add:
url
image
video
(
?
)
Message:
you are ab-using [QUOTE]blah blah blah[/QUOTE] to reply to the_reverend.
Please remove excess text as not to re-post tons
[QUOTE="the_reverend:375553"]I don't know if this can be done without PLC or something like SPC I posted this on another forum... ok, this has been bugging me for a while. I have 2 tables. picturetable {index, bandname varchar, path...} bandtable {index bandname varchar, displayname varchar, bandinfo...} here is the deal that makes it tricky... there are bandnames in the picturetable that aren't in the bandtable and there are bandnames in the bandtable that arent in the picturetable. what I am currently doing is: SELECT pt.bandname as band, bandtable.bandname as btband, bandtable.displayname, bandtable.displayname FROM bandtable RIGHT JOIN (SELECT band FROM `picturetable` GROUP BY `bandname` ORDER BY `bandname`) pt on pt.bandname=bandtable.bandname ORDER BY pt.bandname this shows all the distinct bandnames in the picturetable joined to the bandtable and sorted by bandname. what I want to do is this PLUS all the bandtable that aren't in the picturetable AND if that weren't enough... I want it sorted by the bandtable.displayname, but if that is null or blank, then order it by pt.bandname. any for a 3rd part, I would like to cache the query until the number of rows in bandtable or the number of rows in picturetable change. anyone? I know that's a lot to ask for... http://www.php-editors.com/forum/index.php?s=2b64df00c3613af8dfca36e7dc71af04&act=ST&f=23&t=2008 http://forums.devshed.com/mysql-help-4/how-to-merging-and-sort-two-tables-324306.html[/QUOTE]
UBB
enabled
. HTML
disabled
Spam Filtering
enabled
Icons: (click image to insert)
Show All
-
pop
[
default homepage
]
[
print
][
1:43:11pm Apr 27,2024
load time 0.03424 secs/10 queries]
[
search
]
[
refresh page
]