I know this question might sound simple to you, as if it case sensitive issue, However it is not. My problem is that when I try to grab a Decimal value(10,2) it returns 0.00 but the rest of the rows it selected are fine. Here is my code: This grabs the rows, most of them work and ALL of them are properly typed with Caps in the right places:
$query = "SELECT * FROM invoice WHERE id='$id'";
$result = mysql_query($query) or die("Couldn't execute query");
while ($row = mysql_fetch_array($result)) {
$DateCreated = $row['DateOfCreation'];
$id = $row['id'];
$Description = $row['Description'];
$ProductCode = $row['ProductCode'];
$VatRate = $row['VatRate'];
$PriceExVat = $row['PriceExVat'];
$Status = $row['Status'];
}
This outputs the variable:
<input type="text" name="priceExVat" size="10" id="priceExVat" value="<? echo $PriceExVat; ?>"/>
I would guess that the PHP server has short tags disabled. Try replacing
<? echo $PriceExVat; ?>
with
<?php echo $PriceExVat; ?>