Mysqli fetch_assoc first result

Question

I have a fetch_assoc query that will grab 14 rows, but I want the FIRST result displayed so it is differnet to the others, then the rest are just ordinary.

    $site_events = $db->query("SELECT * FROM site_events ORDER BY time ASC limit 14");
        while($events = $site_events->fetch_assoc()) {

        if( first result???? ) { //this is where im stuck
           echo $events['title'], 'FIRST RESULT';
        }

        //then display others like a normal list..
        echo $events['title'], '<br />';
   }

you can always use a *variable* to store the state – Your Common Sense Nov 27 '13 at 16:20 — Your Common Sense, Nov 27 '13 at 16:20

score 2 · Answer 1 · answered Nov 27 '13 at 16:23

2

I based mine on Yatin Trivedi's answer, but removed the increment with a variable which I unset. You wont notice the difference, but this is a bit faster. This is because the $i++ doens't have to be called every itteration. Also, unset() is really fast. Edit: That answer started with $i=0 and a $i++, now it doesnt anymore :)

$hasNotLooped = true; // set it before you run the loop
$site_events = $db->query("SELECT * FROM site_events ORDER BY time ASC limit 14");
    while($events = $site_events->fetch_assoc()) {

    if( $hasNotLooped ) {
       echo $events['title'], 'FIRST RESULT';
       unset($hasNotLooped);
    }
    //then display others like a normal list..
    echo $events['title'], '<br />';
}

answered Nov 27 '13 at 16:23

Martijn

15,791
4
36
68

Why not just `if ($hasNotLooped) $hasNotLooped = false;`? – h2ooooooo Nov 27 '13 at 16:24
Doesnt really matter I guess... Either way has advantages. You could say I just removed some info from the memory – Martijn Nov 27 '13 at 16:26
Is it possible to make it so the first results inst duplicated again? Cause its duplicated and echos like a normal one as well. – Jayden Nov 27 '13 at 16:28
Just wrap it with an `else{}` – Martijn Nov 28 '13 at 08:54

score 1 · Accepted Answer · answered Nov 27 '13 at 16:28

You can fetch first line outside the "while" and then continue normally. But first you should probably check if there are data selected just in case:

$site_events = $db->query("SELECT * FROM site_events ORDER BY time ASC limit 14");
if($db->field_count){
   $event = $site_events->fetch_assoc();
   echo $event['title'], 'FIRST RESULT';

   while($events = $site_events->fetch_assoc()) {

     //then display others like a normal list..
     echo $events['title'], '<br />';
   }
}

Yatin Trivedi · Answer 3 · 2013-11-27T16:26:25.040

0

$tmp=true;
$site_events = $db->query("SELECT * FROM site_events ORDER BY time ASC limit 14");
    while($events = $site_events->fetch_assoc()) {

    if( $tmp) { //this is where im stuck
       echo $events['title'], 'FIRST RESULT';
       $tmp=false;
    }
    else
    {
    //then display others like a normal list..
    echo $events['title'], '<br />';
    }
}

edited Nov 27 '13 at 16:26

answered Nov 27 '13 at 16:20

Yatin Trivedi

661
6
9

Booleans are quicker than integers. Just saying. – h2ooooooo Nov 27 '13 at 16:21
1

you could improve speed by adding the $tmp++ in the if statement... (microscopical difference :) ) – SpiderLinked Nov 27 '13 at 16:23
Is it possible to make it so the first results inst duplicated again? Cause its duplicated and echos like a normal one as well. – Jayden Nov 27 '13 at 16:25

Mysqli fetch_assoc first result

3 Answers3

Linked