Hi all,
Can anyone tell me how to fix this little problem?
Here is a snippet of the code:
if(is_numeric($sprice)){
$sql = $sql."AND movie.movie_current_price<='" . mysql_escape_string(stripslashes($sprice)) . "' ";
}
Lets say the value for $sprice equals 15. At the moment my query does select all the movies in the DB that are less than 15 (dollars) but for some reason it is also displayng movies that are over 100 (dollars). I'm assuming this is becuase it has three digits.
The movie_current_price values in the DB are in the following format 23.00 or 115.00.
Any ideas?
Cheers,
micmac
