Just the first record

[eluser]Chris Williams[/eluser]
I'd like to get this:

Code:

title field

record one
record two
record three
etc

The data returned from the records has the title field in them already. But to access them I have to use a foreach statement as shown in the user guide.

I supposed I could do this with multiple queries, but is it possible to reuse results from the same query?

[eluser]Michael Wales[/eluser]
I'm not exactly sure what the question is...

Your title says just the first record - to select just the first:

Code:

$query = $this->db->get('table', 1, 0);
return $query->row();

What your explanation sounds like is you are selecting titles and want to echo them out on at a time. For some reason you don't want to use foreach - not sure why, since that is what it is for...

Code:

$query = $this->db->get('table');
foreach ($query->result() as $record) {
  echo '<p>' . $record->title . '</p>';
}

Of course, this code is sloppy - there should be quite a few more checks to ensure what you expect to happen is happening, but you get the idea.

[eluser]Chris Williams[/eluser]
I guess I'm trying to write something like this

Code:

//just the first record (or any really since all the records name this value)

<?php some code to show field 1 from the first record only ?>

//then all the records

<?php foreach ($query->result() as $row): ?>
    <tr>
        <td>&lt;?=$row->field2?&gt;</td>
        <td>&lt;?=$row->field3?&gt;</td>
        <td>&lt;?=$row->field4?&gt;</td>
        <td>&lt;?=$row->etc?&gt;</td>
    </tr>
&lt;?php endforeach; ?&gt;

[eluser]Pascal Kriete[/eluser]
I don't know if I understand the problem. How is it different from doing this:

Code:

$row1 = $query->row();
echo $row1->field1;

//all records

[eluser]Chris Williams[/eluser]
[quote author="inparo" date="1212369881"]I don't know if I understand the problem. How is it different from doing this:

Code:

$row1 = $query->row();
echo $row1->field1;

//all records

[/quote]

That's a good suggestion. A lot better than that I ended up with:

Code:

<?php foreach($query->result() as $row): ?>
<?php endforeach; ?>
<?=$row->field1?>

Which seems to work fine, if a bit hacky. :-)

Thanks!