[thelist] php/mysql get next two records

[Mark Groen]

> > Can you use TOP in mySQL?
> [/snip]
> 
> No, but it does support a "LIMIT" clause which does the same in it's
> simplest syntax:
> 
> SELECT
>         <whatever fields>
> FROM
>         myTable
> WHERE
>         myField => myCriteria
> ORDER BY
>         myField
> LIMIT 3
> 
> (It does have to be specified after the ORDER clause.)
> 
> For more details:
> http://dev.mysql.com/doc/mysql/en/select.html

I think I will try Burhan's idea, the records may need a wee bit of
extra sorting and pulling them all out for one day in a chunk would
work for that, (there isn't something on every hour, lots of blank
spots), thanks everyone!

I rather do like the sql way though, more elegant...hmmm

-- 
cheers,

             Mark

             MG Web Services
             www.mgwebservices.ca

Your Canadian West Coast web site development and hosting solution.