Using IF and Else ?

Mark_Nordstrom

OK heres what I need and I have no clue how to start even. Ive looked over the IF statements on php.net couldnt find anything.

I need to use
IF ColumnC>=50
UPDATE table SET ratio=Column1/Columnb
ELSE
UPDATE table SET ratio=Column1/Columnb-.01

How do i get tit to minus .01 fro mratio for every .01 below 50 ?

So if ColumnC=30 then it would minus .20 from ratio.

bradgrafelman

Mark Nordstrom wrote:
How do i get tit to minus .01 fro mratio for every .01 below 50 ?

So if ColumnC=30 then it would minus .20 from ratio.

I think you meant "for every 10 below 50"... otherwise a value of 30 should subtract 200. Assuming this is what you meant...

You can use MySQL's CASE syntax:

UPDATE table
SET ratio=(CASE WHEN ColumnC>=50 THEN Column1/Columnb ELSE Column1/Columnb-.01*(50-ColumnC+ColumnC%10))

(Query untested)

EDIT: Also note that there might be a simpler way to do the math... that's just what I thought of doing off the top of my head.

Mark_Nordstrom

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 87
STR: -.
SQL: UPDATE Ratio
SET ratio=(CASE WHEN attend>=50 THEN attendance/loot ELSE attendance/loot-.01*(50-attend+attend%10))

this is what i get.

bradgrafelman

Try changing that ".01" to "0.01".