close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Search not working

Thread begun 10/26/2011 5:34 am by iainmacdonald331081 | Last modified 10/27/2011 2:44 am by iainmacdonald331081 | 1700 views | 4 replies |

iainmacdonald331081

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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

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




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

Sign in to reply to this post

iainmacdonald331081

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post

iainmacdonald331081

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...