Search not working

Not sure what's happened here - I was just looking over something and noticed that a search function has stopped working on a page that I know used to be fine.

I did recently create another search page based on the original - the only difference being it was searching a different field in a different table.

The newer one is working fine, and I've looked at the two search and two results pages, and can't see why one works and the other not.

I've attached the four files and would be grateful if someone could have a quick look and see if they can spot what's gone AWOL.

The two that have stopped working are:

candidatesearch.php
candidatesearchresults.php

And the two that are working are:

contactWishlistSearch.php
contactWishlistSearchResults.php

Thank you!

to help troubleshoot, add the following code just after the body tag of the results page:

<?php echo("SQL: ".$query_Recordset1."<br />"); ?>

this will write the search SQL to the page, post the SQL back please.

Thanks Jason.

The original that is no longer working (I should have expanded on that earlier - it just looks like its returning every record), is outputting:

SQL: SELECT * FROM Candidates WHERE ((CV LIKE '%engineer%'))

The newer one that is working is outputting:

SQL: SELECT * FROM EmployerContacts WHERE ((Wishlist LIKE '%engineer%'))

Which both look kind of right, so not sure what's up.

judging from the SQL being written to the screen the search appears to be working correctly.


If you try a different search term does the number of records returned change?

Ok - not sure what happened there - either I or the internet had a funny five minutes, as it looks OK now.

Thanks for having a look.