[SOLVED] A simple questions... Is this that I have done right

[npsari]

mysql_select_db(flat);

$q = "SELECT * FROM
rent
             WHERE Price=<200
ORDER BY Price DESC
LIMIT 10000;";

 

Reefering to my above code....

 

Is what I done right?

 

Price=<200

 

Will that work, cus I want to show all Prices less than 200

 

[metrostars]

mysql_select_db(quickfla_find);

$q = "SELECT * FROM
rent
             WHERE Price <= '200'
ORDER BY Price DESC
LIMIT 0, 10000";

 

that one

[npsari]

Yes, but a user will select from a Combobox

 

<select name="Price" size="1">

<option value="<200">Less than 200</option>

<option value="<300">Less than 300</option>

<option value="<400">Less than 400 </option>

<option value="<500">Less than 400</option>

<option value="<600">Less than 600</option>

<option value="<700">Less than 700</option>

<option value="<800">Less than 800</option>

<option value="<900">Less than 900</option>

<option>More than 1000 / Month</option>

</select>

 

And the PHP code is...

 

mysql_select_db(flat);

$q = "SELECT * FROM
rent
             WHERE Price='$Price'
ORDER BY Price DESC
LIMIT 10000;";

 

And I am giving the values of Price to be <200 ... <300... <4000 ... etc