altendew wrote:
What do you mean assemble the SQL in Code.
I am using MYSQL 4.1 and PHP.
Ah. Looking closer, I see that you're not using an outside variable in
the CASE bit. Sorry about that. Should have read closer.
In your FROM clause, you could have stuff like:
FROM bonus b
JOIN bonu
What do you mean assemble the SQL in Code.
I am using MYSQL 4.1 and PHP.
Daniel Kasak wrote:
>
> altendew wrote:
>
>> Im trying to create one query here. I know why its failing because CASE
>> can
>> not be used like this, but how could I ever do a query like this.
>>
>> [CODE]
>> SELECT b.*
>
altendew wrote:
Im trying to create one query here. I know why its failing because CASE can
not be used like this, but how could I ever do a query like this.
[CODE]
SELECT b.*
FROM bonus b
JOIN
CASE b.type
WHEN 'custom' THEN 'bonusCustom g'
WHEN 'pts' THE
