close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Search Not Working

Thread began 5/08/2012 11:12 am by J7HNW | Last modified 5/10/2012 10:53 am by Jason Byrnes | 765 views | 6 replies |

J7HNW

Search Not Working

Please can you help

I have run the database wizard and all pages work fine apart from Search ( Insert, Update etc all doing as they should )

If I search with no criteria - then the results all appear fine

One of the fields is TOWN

If I do a search by putting TOWN in the search and then enter HIGH for HIGH WYCOMBE which is a town in the database - the search returns nothing

Same if I search on any of the fields. However if I leave all the search fields blank - then all results are shown

Help please

Attached Files
repvisits_Search.zip
Sign in to reply to this post

Jason ByrnesWebAssist

please send a link where i can see the problem and a copy of the repvisits_Results.php page to troubleshoot.

Sign in to reply to this post

J7HNW

Link

Hi Jason

Search file and Results file are attached

Link to search can be found here

repvisits_Search.php

Thanks

John

Attached Files
Customers.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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

php:
<?php echo("SQL: ".$query_limit_WADArepvisits); ?><br />
Sign in to reply to this post

J7HNW

Code Added

Hi Jason

Code added just after Body tag

PHP:

---------

<?php echo("SQL: ".$query_limit_WADArepvisits); ?>

---------

Sign in to reply to this post

J7HNW

Fixed

Hi Jason

In the end I ran the Wizard again and remade the pages and this time it has worked

Thanks for your help.

John

Sign in to reply to this post

Jason ByrnesWebAssist

Ok, glad to hear it is working.

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...