How to display only first value of database column in WordPress

Question

I have following foreach loop code...

<?php

$usernames = $wpdb->get_results( "SELECT user_name FROM wpxa_project_members WHERE project_id = 698" );

foreach ( $usernames as $username ) 
{
    echo $username->user_name;
}

?>

When I use echo $username->user_name; it displays all the usernames from the user_name column of database. I want to display only the first username from the list. How to do... Pl help... Thanks...

Answer 1

$usernames = $wpdb->get_results( "SELECT user_name FROM wpxa_project_members WHERE project_id = 698 LIMIT 1" 

Answer 2

It's a little bit hard to guess, what exactly are you trying to achieve, but... Based on your answer, here's much cleaner and more secure code, you can use:

global $wpdb;
$usernames = $wpdb->get_results(
    $wpdb->prepare(
        "SELECT user_name FROM {$wpdb->prefix}project_members WHERE project_id = %d",
        698
    )
);

if ( ! empty($usernames) ) {
    echo $usernames[0]->user_name;
} else {
    // there are no users
}

Answer 3

I have found the solution... Here it is...

<?php

$usernames = $wpdb->get_results( "SELECT user_name FROM wpxa_project_members WHERE project_id = 698" );

foreach ( $usernames as $username ) 
{
    $member_username[] = $username->user_name;
}

echo $member_username[0];

?>

Hope it may help other users.