Using LIMIT in MySQLi query

OK - so I'm having a problem doing a query like this -

$rsQuotes->setQuery("SELECT quotes.quotes_quote FROM quotes WHERE quotes.quotes_display=1 LIMIT 1");

(I've also tried moving the LIMIT to just after the FROM statement)

I'm catching "Error in SQL Syntax" when I try that. Is this me or you or MySQLi?

Make sure you have the latest version of the MySQLi extension installed, this is a bug that should be fixed.

The limit is passed through the recordset definition line.

so the line that instantiates the recordset object:

$rsQuotes = new WA_MySQLi_RS("rsQuotes",$<connectionName>,1);

that last argument "1" is the limit, rather than it being part of the SQL statement.

YIKES - I knew that and forgot that I knew it!

I think I'm fully informed now, and you can relax for the rest of the day! :)

you're welcome.

So in a statement like "ORDER BY id DESC LIMIT 1, 1" where it goes 1 row back how would I call this with the MySQLi extension or am I just ill informed? Perhaps there's a better way? I'm trying to get the record right before the last record. Thanks.

That limit statement doesn't look like it will do what you want, instead of using LIMIT in the recordset, use a loop to move the pointer to the last record, then move previous to move one back, then write the record to the page:

<?php 
while(!$RecordsetName->atEnd()) {
$RecordsetName->moveNext();
}
$RecordsetName->movePrevious();
echo($RecordsetName->getColumnVal("ColumnName")); 
?>

Cool. Thanks Jason!

you're welcome.