Search function not working?

[David Mc]

Just keeps returning me to the main "home" page! Is it just me?

[Mark]

What are you searching for? And are you Mac/PC/phone? And what browser are you using (e.g IE6, Safari, FireFox)?

[David Mc]

A few things. The last was "le chardon". PC (XP Professional). Internet Explorer v6.doyouneedtherest?!

[SeanMacGabhann]

David

I'm getting a full page of results for "le chardon"

http://www.eastdulwichforum.co.uk/forum/search.php?12,search=le+chardon,page=1,match_type=ALL,match_dates=365,match_forum=ALL

using Vista and Firefox

[mockney piers]

it is a bit patch if you remember the whole 'definately' search malarkey.

[mockney piers]

Any chance you can send me the search function (PM probably wisest). It's basically rubbish and I'd love to see the code behind it.

It should be "SELECT post_text FROM posts WHERE post_text LIKE '%search term%'" but obviously isn't.

Well, I guess it's wrapped in a procedure otherwise people would search for '; DROP DATABASE' but that's another matter entirely.

If I could rewrite it so it worked, that'd be pretty useful.

[macroban]

Not a good idea to give SQL access outside Admin.

[mockney piers]

No no, didn't want access, just suggesting I might write a correctly working function that Admin could use rather than one that clearly doesn't do the job.