PHP and MySQL show for before position

Question

I have a Mysql database, where the records are sorted by positions. How do I display. The data that is before a position, and not show the data of the following positions?

PHP invoke data

$r_ruta = $_GET["r_ruta"]; 
$jornada = $_GET["jornada"]; 
$query = mysqli_query($con, 'SELECT * '.
                            'FROM escolar '.
                            "WHERE r_ruta = '$r_ruta' ".
                              "AND jornada = '$jornada' ".
                            'ORDER BY pos ASC');

Possible duplicate of [MySQL select before after row](https://stackoverflow.com/questions/9836279/mysql-select-before-after-row) — , Feb 20 '18 at 03:39
I need to show the coordinates related to my id, and the one that is before and the previous id, only those two data — Matheo Espitia, Feb 20 '18 at 03:41

score 0 · Accepted Answer · answered Feb 20 '18 at 05:50

Using above query, you will get this id, say $id. Then next query for previous id can be like this -

        $query = mysqli_query($con, 'SELECT * '.
                            'FROM escolar '.
                            "WHERE id < '$id' ".
                            'ORDER BY id DESC LIMIT 1');

PHP and MySQL show for before position

1 Answers1