user defined troubles

[marcps]

I am getting results on who's online examples etc - but cannot get my user defined query to get results.

my query is

select id,action from actionlog where type = 'county' order by `id` desc limit 0,5

this works in sql direct...

This should pull the last 5 counties searched for in my find-a-pro directory.

www.balloonconsultant.co.uk is the web adress.

Marc P Summers

[Saka]

As it says in documentation, don't use LIMIT command, it is added automatically.
So try just:
SELECT id, action FROM actionlog WHERE type='county' ORDER BY id DESC

[marcps]

Thank you for pointing out my silly mistake.  I hope by making a fool of myself will help others

Marc

[Saka]

No problem, that's what's forum is for.
I did my best to explain everything in PDF documentation but if you are not sure about something just ask.