Display only one record with foreach

Question

I need help to display only one database record, follow code:

<?php
    $posts  = DBRead( 'posts', "WHERE categoria = 3 AND status = 1 ORDER BY data_numero ASC" );

    if( !$posts )
        echo '<h2>Nenhuma Corrida Registrada!</h2>';
    else
        foreach ( $posts as $post ):
?>

You would need to make the foreach return the with the shorter date and only one to insert into a BOX.

Answer 1

If you want one, you don’t need foreach, just pick up the index:

<?php
    $posts = DBRead('posts', "WHERE categoria = 3 AND status = 1 ORDER BY data_numero ASC");

    if( !$posts ) {
        echo '<h2>Nenhuma Corrida Registrada!</h2>';
    } else {
        $post = $posts[0]; // Pega o primeiro, sem precisar de foreach
    }
?>

The foreach iterates the variable since $posts[0] until $posts[ultimo item], if you want only one, specify the first index, which is zero.

If there are many items originally returned, you can limit the search with a LIMIT 1 at the end of query as commented by @gmsantos. This will not affect screen output with the current solution, but will save unnecessary data transmission.

Answer 2

You can limit your query for a single result, thus the foreach will have only one iteration.

<?php
    $posts  = DBRead( 'posts', "WHERE categoria = 3 AND status = 1 ORDER BY data_numero ASC LIMIT 1" );

    if( !$posts )
        echo '<h2>Nenhuma Corrida Registrada!</h2>';
    else
        foreach ( $posts as $post ):
?>

Or then right away in your code give a break

<?php
    $posts  = DBRead( 'posts', "WHERE categoria = 3 AND status = 1 ORDER BY data_numero ASC" );

    if( !$posts )
        echo '<h2>Nenhuma Corrida Registrada!</h2>';
    else
        foreach ( $posts as $post ):
?>
Dados do post: <?=$post?>
<?php break; ?>
<?php endforeach; ?>