[Using if in the select data code]

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...

[Using if in the select data code]

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

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

 

[Using if in the select data code]

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.

[Listing previous 10 records]

<?PHP Beautiful people, i wish love and health ?> 🖐️

[Listing previous 10 records]

[Listing previous 10 records]

thank you but this is not the solution.
As if there were no first 10 records - next 10 records will be print to the screen.

$sqlq=$connectx->prepare("SELECT * FROM lovetree WHERE id > -10");
- 10 record go back

[Listing previous 10 records]

I want to list 10 records after the last 10 entrie.
 

[Listing previous 10 records]

I want to list the previous (minus) 10 records.
classic asp example:  <% do while not rs.eof and i< 7 %>
how to do with php pdo?

My code is this:
<?php
$sqlq=$connectx->prepare("SELECT * FROM lovetree ");
$sqlq->execute();
while($rs = $sqlq->fetch()) {

echo $rs['tree'];

}
?>

Thanks...