Output problem!

[Nathalie]

I have a database with a table that is acting weird.

Thru a PHP page I can get values stored in the table. I can log into MySQL and see them stored in the table.

I have a scipt to show the contents of that table. It works fine but it will only display values that have numbers in them.

Here is the script I am using to display the table
------------

$allTable = mysql_query("SELECT * FROM tablename WHERE fieldname>0");
$entrys = mysql_numrows($allTable);
echo"<br>Total Rows:$entrys";

$i = 0;
while ($i < $entrys)
{
$report = mysql_result($allTable, $i, "Name");
echo "<br>$report";
$i++;
}
?>
------------

Is it because of a character set I'm giving the field?
Thanks for reading! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

Since you are comparing the field to a numeric value, MySQL first converts the field to numeric. If if does not begin with a numeric character then the assigned value is zero. Zero is not greater than zero and so the row is not displayed. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --