Changing table data's display

[cyprus]

 while ($rows = mysql_fetch_assoc($result))
   {
     echo "<tr>";
     foreach ($rows as $data)

[b]I AM TRYING TO DISPLAY CERTAIN COLUMN VALUES HERE
DIFFERENTLY TO MY TABLE DATA
         
       'UnitPrice' to get a preceding £ sign
       'Qty'  to be preceded with the word "off"      
       'RunningTotal' to get a preceding £ sign
       'Orderdate' to display date("j-M-Y", strtotime('orderdate'))[/b]

[b]I tried a case statement built from previos reference, but cannot find which contains the data to modify. Thanks[/b]

echo "<td align='left'><b><font face='Arial' size='1'>". $data . "</font></b></td>";

     }
   }
 }else{
   echo "<tr><td colspan='" . ($i+1) . "'>No Results found!</td></tr>";

[onlyican]

in that case do something like

[code]
<?php
while($rows = mysql_fetch_assoc($result)){
echo "<td>".$row["fieldname"]."</td>\n"
."<td>".$row["another_fieldName"]."</td>\n"
}
?>
[/code]

Where fieldname is the name of the field in the database

[sasa]

try[code]foreach ($rows as $k => $data) {
switch ($k) {
case 'UnitPrice':
case 'RunningTotal':
$data = '&pound; '.$data;
break;
case 'Qty':
$data = 'off '.$data;
break;
case 'Orderdate':
$data = date("j-M-Y", strtotime($data));
}
echo "<td align='left'><font face='Arial' size='5'>". $data . "</font></td>";
}[/code]

[cyprus]

Yet again sasa thanks. Just had to swop the "off", ie cart before the horse, but that was minor as it all works, excellent, thanks again