Using if in the select data code

[DisplayError]

Example Code:
$sql=$baglan->prepare("SELECT * FROM img where id='$getx') and if (FirstImage==1 echo FirstImage=1 ; else FirstImage==0 echo FirstImage=0 ) "); // AS ETC.
$sql->execute();    
$rs = $sql->fetch();

if FirstImage=1 is absent, continue with FirstImage=0

Thanks for your idea and effort.

[Barand]

Can you tell us what you are trying to achieve? It's impossible to tell from that hotchpotch of code.

[DisplayError]

where id = '$ getx') and
FirstImage =1
FirstImage=0

If there is no 1, the ones with 0 should be listed

 

[dodgeitorelse3]

I think you are going to want to run your if/else statement on your results instead of in your query.

[Barand]

WHERE id = ? AND FirstImage IN (0,1)

 

[DisplayError]

WHERE id = ? AND FirstImage IN (0,1) order by FirstImage desc
view selected picture first - if not view other pictures.
i thank all my friends who help.
with love...