...

IF in WHERE

stellarid
11-07-2002, 03:59 PM
i did something like this :

SELECT bla
FROM bla
WHERE bla AND
... more bla ... AND

IF(1<2, 'M_TAB.ID=3','M_TAB.ID=4')

ORDER BY otherbla


...but it seems that M_TAB.ID=whatever aint really working. I just whant to decide which other WHERE clause i take.
Canīt bee that difficult, right?



___
stellarid

stellarid
11-07-2002, 05:05 PM
...got it

IF(1<2,M_TAB.ID=$ID,1)

...thanks4helping...:p



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum