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?