I'm working on listing fields in a db using mysql_fetch_array. I was able to list the first 4 fields but when I add a 5th field to the code it dos not display and I can not seem to figure out why?
<?php
mysql_connect("??????.com","?????","??????");
mysql_select_db("??????");
$query = mysql_query("SELECT * FROM recipe");
while($row = mysql_fetch_array($query))
{
$ID = $row['id'];
$name = $row['name'];
$basegrain = $row['basegrain'];
$bgamount = $row['bgamount'];
$spg1 = $row['$specialtygrain1'];
echo "<table cellpadding=10><tr></tr><tr><td>".$ID.".</td><td><b>".$name."</b> - >"."</td><td>".$basegrain."</td>
<td><font size=2>amt = ".$bgamount."lbs</font><td>".$spg1."</td><br></td></tr></table>";
}
?>
