mysql query and php arrays

[roycrom]

Hi I am trying to display a web page. I have a database table with 11 fields. I have populated a php array with the field headers

$FIELDS=array("Barcode", "Status"......);
$result=mysql_query("SELECT * FROM table WHERE Barcode=$Barcode");  //barcode from $_GET variable
$row=mysql_fetch_row($result); //only 1 row will return

Now I want to use the echo to print put each valuein the returned row array, such as

foreach($FIELDS as $VARIABLE) {
    echo "$VARIABLE<BR>";  //Make sure var is set
    echo "$row[$VARIABLE]<BR>";  //This line just blank
}

So variable is printing out, but I am just getting blank lines for $row[$VARIABLE]. Is it not possible to pull result back from a $row array like this? Anytips on a better way?

Thanks for any help you can give.

------------------------------------------
Somethings come from nothing, nothing seems to come from somethings - SFA - Guerilla

roycrom

 

[jpadie]

i think you might need to change your foreach loop

foreach($row as $val):
    echo "$val <BR/>";
endforeach;

and if you want the field names

$row=mysql_fetch_assoc($result); //only 1 row will return
echo "<table>";
foreach ($row as $key=>$val):
 echo "<tr><td>$key</td><td>$val</td></tr>";
endforeach;
echo "</table>";