lundi 21 décembre 2015

Show Every Data from Mysql Database except the last one

$query = "SELECT id,subject,date,notice from sam_notice ORDER BY id DESC LIMIT 1";$result = $conn->query($query);

This query pulls the last one only and i can view in section 1

$query2 = "SELECT id,subject,date,notice from sam_notice ORDER BY id DESC";$result2 = $conn->query($query2);

This query pulls all data to view in section 2

What is the change i need in query2 so that it can pull all data except the last one?




Aucun commentaire:

Enregistrer un commentaire