Jump to content

Changing table data's display


cyprus

Recommended Posts

 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>";
Link to comment
https://forums.phpfreaks.com/topic/21854-changing-table-datas-display/
Share on other sites

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]

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.