PDA

View Full Version : Echoing information from MySQL



big-dog1965
12-14-2007, 08:35 AM
How would I make this code display the information that is coming from the DB differantly. These are check box fields from a form if checked the value is "count me in"
I need each to display for instance $TH_SCALE displays "count me in" I need it to display on page as 8Th Scale, $ARENA_TRUCK as Arena Truck and so on.


$i=0;
while ($i < $num) {

$NAME=mysql_result($result,$i,"NAME");
$TH_SCALE=mysql_result($result,$i,"TH_SCALE");
$TH_SCALE_SPORTSMAN=mysql_result($result,$i,"TH_SCALE_SPORTSMAN");
$ARENA_TRUCK=mysql_result($result,$i,"ARENA_TRUCK");
$MONSTER_TRUCK=mysql_result($result,$i,"MONSTER_TRUCK");

echo "<b>$NAME<br>$TH_SCALE<br>$TH_SCALE_SPORTSMAN<br>$ARENA_TRUCK<br>$MONSTER_TRUCK<hr>";

$i++;
}

?>