I am all confused

[Anon]

I have this script:
<?php
if(isset($searchprice)):
$db = mysql_connect("localhost");
mysql_select_db("saintparis", $db);
$sql="select * from class where class_price>='$littlenumber' and class_price<='$bignumber'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
printf("<b>»</b><a href='classoutfinal.php?finalclassid=%s'>%s</p>",$row["class_id"],$row["class_name"]);
}
exit;
endif;
?>

There is two numbers coming from a form. The user puts in a littlenumber and a bignumber. I want it to get the whole range. Any ideas why its not working?

It gets if the bignumber equals the number i am trying to get it works. But not any others. Any help?

Thanks!

Chad

[Anon]

Should they NOT be in quotes, if they are numbers?

e.g.

$sql="select * from class where class_price>=$littlenumber and class_price<=$bignumber";

Diego

[Anon]

Well what if I need it to be 150,000 MySQL select statement will not accept the , key. Classifieds section is what this thing is for. So I need it to do 23.23 and 232,000. If it helps this field is set as a TEXT field.
Chad

[Anon]

Well what if I need it to be 150,000 MySQL select statement will not accept the , key.

I don't understand what you're trying to say there...

So I need it to do 23.23 and 232,000

Ok, so why don't you use a FLOAT or DOUBLE type of column, instead of a TEXT column? FLOAT and DOUBLE support decimals and big numbers also.

If you use TEXT type, remember the decimal dot also has an ASCII value and will be used in the comparisons and that might be what's causing problems...

Diego

[Anon]

Not good. Doesn't work. I tried making it Float and put in 45,002.30 and it just showed up as 45. Thats not good. Here is the scenario. I am making a classifieds section to a website. They can put their crap online and have people search for it. Kinda of like Ebay but not near as advanced. So people can put a price of 45,000 and someone can put in 45. 45,000 for a SUV or a Truck and 45 for a dog. Ya know? I have a search thing down if it was all even numbers. But since this thing is a little weird it wouldnt work. Float and double both didnt work. Lata!
Chad

[Anon]

I tried making it Float and put in 45,002.30

I don't think you can use commas...just try 45002.30. Floats and Doubles have to work...

Diego

[Anon]

Well you have to think that people are stupid. They will place in , in their numbers. Should I just rip them out then?
Chad

[Anon]

Ok Diego you the man. I finally used Double and it worked! I had to stip out the , and then it was all good. So I thank you. Have a great rest of the night!
zig (chad)

[Anon]

Cool!

[redcircle]

Isn't there a BETWEEN function in mysql??

[Anon]

Good Question. I will look.
Zig