PHP how to echo a row from the database based on the timestamp

Question

In my website, All I pretty much do is show the fullnames of the users that submitted a form from the database and when a admin clicks a name, it just gives the clicked users email. My question is, how can I arrange the list of names to where it gives me the newest names on top and older on bottom? I have a timestamp cell in there that documents the timestamp when the user submits a form. Here is my code

<?php


require_once('db_login.php');

    $stmt = $handler->prepare("SELECT * FROM formdata");

    $stmt->execute();
    while($result = $stmt->fetch()){

       $userid = $result['user_id'];
        echo "<a href='speaker_apps.php?infoid={$userid}'>". $result['fullname']."</a></br>";
    }

if(isset($_GET['infoid'])){


    $stmt = $handler->prepare("SELECT * FROM formdata where user_id='".$_GET['infoid']."'");
    $stmt->execute();
    $row = $stmt->fetch();
    echo "<p>id =".$row['email']."</p></br>";
}


?>

Be aware that your prepare() is a straw plane that never flies. You must use a real [prepared statement](https://phpdelusions.net/pdo#prepared) — Your Common Sense, Feb 17 '18 at 18:28

score 1 · Accepted Answer · answered Feb 17 '18 at 18:26

1

ORDER your results:

$stmt = $handler->prepare("SELECT * FROM formdata ORDER BY your_time_field DESC");

answered Feb 17 '18 at 18:26

u_mulder

54,101
5
48
64

PHP how to echo a row from the database based on the timestamp

1 Answers1