Auto redirect to Last record

[Daryl]

I have a page which uses a URL variable to get its data from a database

news-detail.php?News=1

Is there a way to get the page to redirect to the last record if no URL variable is present?

ie news-detail.php would get redirected to news-detail.php?News="Last Record"

[CraigR]

what i would do is use the News ID from your url parameter as your recordset filter.

you could have an additional recordset on your page which would return the Max news ID from your table

something like "SELECT max(NewsID) AS MaxNewsID FROM tblnews"

if the recordset returns no rows (ie you have no matching record) you use this instead of the url parameter as your recordset filter

[Daryl]

So is there a way of 'showif' url variable, 'showif' no url variable?

[CraigR]

what i meant was using the server behavior

show if recordset is empty/not empty

if the recordset returns a row, you show the information returned

if the recordset doesnt return a row, your max news id would come into play

so the psudologic would be..

if first recordset returns a row, show it
if first recordset is empty, use the max news id that is present as a filter instead

[Daryl]

Ah I see - pretty obvious realy

Thanks for your idease!