Hi
I run a festival site in the UK and I have a search facility on it whereby users can search for all festivals, by year, month or area, or a combination of each, with textual searches also availble. Currently there's 239 records and I wish to split that over several pages (probably of 10 or 20).
I can make it work when it do a select all query to the database, but when I add the 'where' clause, it gives me all the records but it will only display the first 10. If I try to go to the next page, it doesn't display any results.
As it is dreamweaver, I am connecting through that via its wizard as I am unable to connect using the database connect function for some reason.
Is there any help out there or advised that I can get which will allow me to do paging with the 'where' clause added to my query?
Thanks