exclude 1st record

Hey Ray

With this recordset

<?php
$Events = new WA_MySQLi_RS("Events",$DBConnection,4);
$Events->setQuery("SELECT * FROM events WHERE Live = 1 ORDER BY EventDate ASC");
$Events->execute();
?>

in the results, how would I exclude the most recent record based on the date column EventDate?

I have updated the rsobj.php file to support this more easily. Just update the first line manually to:

$Events = new WA_MySQLi_RS("Events",$DBConnection,4,1);

I have attached the updated rsobj.php file. (make sure to update the CrossSiteProtect attribute if you have turned it off in your file)

thanks Ray however replacing that first line of the recordset stops any records from being shown.

***********update************ I swtiched it round from 4,1 to 1,4 and that seems to have made it work

Maybe for now it is best to update it in your SQL directly and put in:

LIMIT 1,4

at the end of your SQL statement manually... I'm probably going to change the order in a future build, I'm not sure I need to think about this some more, but I wouldn't want you to have to go in and update the page if the rsobj.php file gets updated to use the other order.

ok many thanks

And just to let you know that the updated rsobj file 'broke' the search element that we discussed the other day - it was back to showing 'you searched' on every results page. reverted back to my 'original' file and it was fixed. have attached my original rsobj 2.2 for you here

Please add FTP information and a url where I can view the 'you searched' message in the private area. I'd like to take a look at it. Also include steps to reproduce with any usernames or passwords I might need.