|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Mysql approx values
hi
i have a database and i want to select all numerical values in it that are close to it. say i put in the value 54.560 i want all to select all rows with values between 54.060 and 55.060 many thanks tbo ------------------ forget this i was just being a dope, i was trying to do it in sql when i can just do it in the php before, however if it can be done in sql i would like to know. ta --------- doh its BETWEEN $min AND $max i am a fool sorry guys Last edited by trist4king : May 13th, 2008 at 12:00 PM. |
|
#2
|
|||
|
|||
|
You can also use < and > parameters in SQL.
Quote:
|
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > Mysql approx values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|