Thanks for the sugestions from all. I just switched the column type to integer.
Thanks again, Ed On Mon, 8 Dec 2003, Tobias Asplund wrote: > > You have a few ways to do this. > What's happening here is that you do a comparison in a string context, > which means that it will sort according to the ascii values, and 1 comes > before 8. > To sort the way you want you need to specify to MySQL that you want to do > it in a numeric context. > You have two simple ways to do this. > > Add 0 to the string number to force it into numeric mode. > > AND squarefeet >= '$squarefeet' + 0 > > use the CAST() function, it's described more at: > http://www.mysql.com/doc/en/Cast_Functions.html > > > On Mon, 8 Dec 2003, Ed Curtis wrote: > > > > > I've got an entry in a table where the value is 875. If I run a query on > > that table with the clause AND sqaurefeet >= '$squarefeet' and $squarefeet > > has a value of say 1000 the row with the squarefeer value of 875 will > > appear. The column is of type varchar(10) and using the binary flag. > > > > What am I doing wrong? > > > > Thanks, > > > > Ed > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
