Jump to content

Archived

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

cyprus

Changing table data's display

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>";

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
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]

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

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.