SELECT FROM query not returning result for field value >1.99

[RLJ]

Hi all,

 

I need assistance, I'm completely lost!

I have the following MySQL query:

 

<?php
$link = mysql_connect  ('localhost', 'root');
if (!$link) {die('Could not connect: ' . mysql_error());}

$selectDB = mysql_select_db ('TCDB', $link);
if (!$selectDB) {die('Could not select database: ' . mysql_error());}

$query =
"SELECT firstname, lastname FROM translators WHERE (DocTrans <= '100.00') AND (DocTrans >= '0.00')";

$result= mysql_query ($query);
if (!$result) {die('Could not search database: ' . mysql_error());}

if($result)
{   
    //$arr2 = mysql_fetch_array($result); echo implode(",",$arr2);
    if(mysql_num_rows($result) == 0)
    {
        echo "No records found.";           
    }
    else 
    {
        $arr = mysql_fetch_array($result);
        echo implode(",",$arr);
    }
}

?>

 

This query works fine when the field DocTrans has a value <=1.99 , but for a value of 2.00 or higher, the query returns "No records found.".

 

Any idea why this could be?! The field DocTrans is set to VARCHAR length 6.

 

Thanks!

[gristoi]

If you're working with numerical data then try changing the datatype to float and remove the '' from the values

[RLJ]

Thanks! Can't change datatype, but removing quotes seems to work. Still no idea why this became a problem only for values above 1.99 though

[fenway]

Show us the table definitions.... quotes shouldn't matter.