SELECT using IF statement

blackbox

Hi, all.

Is this possible, I am trying to include an IF statement in my SELECT query like.

In place of displaying the content of "Fail" I want to display text.

SELECT SeqID, SeqText,  IF(Fail = 1,Fail = "Failed")
FROM Avail, Table01Q
WHERE Avail.UniqueID = "' . $_SESSION['UniqueID'] . '"',$prop);

Many thanks in advance.

Blackbox

traq

IF() requires three arguments.

Also, why compare [font=monospace]Fail[/font] twice anyway? If the value was 1, then you already know the value is not "Failed". Or are you trying to update the value (you cannot)?

blackbox

Hi traq,

Many thanks for your reply.

what I want to do is, if Fail = 1, then instead of outputting 1, output "Failed. Or if Fail = 2, output Pass.

I know I can do this with a php if statement but in this case I am outputting to a PDF using FPDF and PDF_MySQL_Table.

The code to output the query is:

$pdf->Table('SELECT SeqID, SeqText,  Fail 
FROM Avail, Table01Q
WHERE Avail.UniqueID = "' . $_SESSION['UniqueID'] . '"',$prop);

Is it not possible to code it so it out puts "Fail" or "Pass".

Again, many thanks for your time.

Blackbox

traq

SQL is not PHP.

(did you see my link to the docs, above?)

Sounds like you want something like

SELECT SeqID, SeqText, IF( Fail=1, 'Fail', 'Pass' ) as Fail
 &#8230;