At some point in your WordPress development career you may be presented with the need to write some custom mysql queries.

Select Query

Single row fetching

$ures = $wpdb->get_row("SELECT * F ROM `custome_users` ORDER BY `id` DESC");
    $ures ->name;

Multiple rows fetching

$ures = $wpdb->get_results("SELECT * F ROM `custome_users` ORDER BY `id` DESC");					
foreach ($ures as $uresfet)
{
    $uresfet->name;
}

How to count total number of rows

 $ures = $wpdb->get_results("SELECT * F ROM `custome_users` ORDER BY `id` DESC");
 $rows=$wpdb->num_rows;

Delete Query

 $wpdb->query("DELETE F ROM custome_users where id='$deleteid'");

Update query

 $wpdb->query("UPDATE `sample_requests` SET `firstname` = '$firstname', `lastname` = '$lastname' WHERE `id` ='$id'");