Hi phpeople
Anybody can give me a hint about this...
I have my search engine and it works well
FROM availablespace, corpo
WHERE availablespace.area LIKE '%$search%'
AND availablespace.AvailableSF BETWEEN '$m2_1' AND '$m2_2'
AND corpo.ClassCode LIKE '%$searchclass%'
AND corpo.PropertyID = availablespace.PropertyID
AND availablespace.FloorAv LIKE '%$FloorAv%'
GROUP BY ID
ORDER BY availablespace.AvailableSF");
It's simple and it gets the data from 2 tables.
My question is
is there someway to add a value to $m2_2 by default so if that field is not filled it will get the value that I already set up?
Let say that if you don't fill that field the value of $m2_2 will be 1000 and if you fill the field it will have te value you typed.
Thanx for any recommendation or hint
