"Jeff" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Why would a mysql db think that 55 was greater than 14000. > > I have several headings that display sql data under them, when you click on > the heading, it sorts that section (descending/ascending), but it only seems > to be looking at the first two numbers in the one heading. Is there a > command that forces it to look at the entire record before sorting it?
Because "55" is greater than "14000"... i.e. you're sorting the values as strings, not integers. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php