Get single row using SQLite

I want to be able to use an SQL statement such as “SELECT * FROM thetable WHERE id=1” which returns a single record. Do I have to use db:nrows to extract the columns in that row even though there is only one? [import]uid: 95579 topic_id: 17182 reply_id: 317182[/import]

From the research I’ve done, yes, that’s the only way to get a single row.

Jay
[import]uid: 9440 topic_id: 17182 reply_id: 64739[/import]