[SOLVED] Oring Measurements

[theladycoder]

I am fairly new to PHP and I am not sure where to start. I need to perform a calculation based on user input. For example:

 

You should be able to type in any value in the inside diameter or cross sectional diameter boxes.  For example 1.4332”.  The computer will look at this as an inch dimension and also a metric dimension.  It will find all inside diameters from the standard and metric o-ring database that are within ¼” of this dimension.  Then the customer will type in the cross sectional diameter they desire.  This time the computer will only search from the first list of inside diameters that it came up with and match all the ones that have that inside diameter and a cross section that is within 1/32” of what the customer typed in.  That will give the customer a final list to choose from.  They will pick one or more from the list.

 

I am not sure how to go about this and would greatly appreciate any help!

[Barand]

Use a query something like

SELECT id, diameter, description
FROM oring
WHERE ABS(diameter - $inchesInput) <= 0.25

 

The dropdowns themselves can be generated using AJAX (See sample in my sig)

[theladycoder]

Okay, this is what I am trying to:

 

Let's say that $var is = to .040 (which this is in inches)

$var = @$_GET['q'];

$trimmed = trim($var) <= 0.25;

 

I want to take that value and display all values in the same table from the CS field that is within .25 either way using the query

 

$query = "select * from tablename where csInches >= $trimmed";

 

The problem is that I am not returning anything and I would like to display within 1/4" of the user input. What am I doing wrong?

 

Thanks :-\

[Barand]

$trimmmed will contain "true" or "false" depending on whether $var is greater then 0.25 or not.

[theladycoder]

I do appreciate the help, but are you saying that I should not use trim in this case? Have I written the code wrong? Again, thanks.