re on cdaudio.iGenreID = genre.iGenreID
left join user on cdaudio.iUserId = user.iUserId
left join POS_TEMP on cdaudio.iCDAid=POS_TEMP.cd_id
and user.iUserId = $userid
order by pos");
}
Sergei, Bruce, thank you
at would work with 3.23 ? :))
(ah, damn real-life admins, who don't want to upgrade before 6 months
of proven reliability)
PS: i add the following words to pass the spam filter :)
database sql query table
--
Boris Hajduk
Saturday, November 17, Bruce Ferrell wrote:
BF> SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
BF> (1...200);
no, i wasn't clear enough, let's try it again.
the table book contains :
|-- title -|--position1--|--position2--|--lots of other fields---
| bravenewworl
on1=j \
or position2=j;
note: given a number between 0 and 199, the number is stored in
position1 OR position2 , but never both.
any idea ?
--
Boris Hajduk [EMAIL PROTECTED]
-
Before posting, please check:
