Go Back   CodingForums.com > Search Forums

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 6 of 6
Search took 0.06 seconds.
Search: Posts Made By: LiamHorizon
Forum: MySQL 10-11-2012, 08:21 AM
Replies: 7
Views: 976
Posted By LiamHorizon
if it is any help, here is an example of a search...

if it is any help, here is an example of a search form I am trying to aim for. I am pretty sure this one uses percentages for its search. So anything within say 10% of a search of 110, 30, 200
...
Forum: MySQL 10-11-2012, 08:07 AM
Replies: 7
Views: 976
Posted By LiamHorizon
The 110 60 20 one would ultimately be one I...

The

110 60 20 one would ultimately be one I would want to show. But say a user just searched for a width of 110 and there wasn't an exact match. The search would return any results that have a...
Forum: MySQL 10-10-2012, 01:30 PM
Replies: 7
Views: 976
Posted By LiamHorizon
I have this code currently, but it doesn't work...

I have this code currently, but it doesn't work either:


$scope = 20;
$width_min = $width - $scope;
$width_max = $width + $scope;
$depth_min = $depth - $scope;...
Forum: MySQL 10-10-2012, 01:25 PM
Replies: 7
Views: 976
Posted By LiamHorizon
Thanks for your reply :) Okay I will look at...

Thanks for your reply :)
Okay I will look at the % and remove what is needed.

I understand what you mean; having the results being able to find the closest match to the users input is what I am...
Forum: MySQL 10-10-2012, 08:17 AM
Replies: 7
Views: 976
Posted By LiamHorizon
Getting the nearest SQL results if a query cannot find an exact match?

I want to be able to allow my search form to return the nearest results if it cannot find an exact match to the user input. So if a user enters "272" for height and there isn't an exact match but...
Forum: MySQL 10-09-2012, 12:57 PM
Replies: 2
Views: 476
Posted By LiamHorizon
Make SQL ignore a specific search value if clicked in a dropdown?

I am creating a multi-form search box that searches a Meat packaging database. The search works only if users are specific, I want them to be able to search the database without having to choose a...
Showing results 1 to 6 of 6

 
Forum Jump

All times are GMT +1. The time now is 10:12 PM.