cyprus Posted September 24, 2006 Share Posted September 24, 2006 while ($rows = mysql_fetch_assoc($result)) { echo "<tr>"; foreach ($rows as $data) [b]I AM TRYING TO DISPLAY CERTAIN COLUMN VALUES HEREDIFFERENTLY 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 More sharing options...
onlyican Posted September 24, 2006 Share Posted September 24, 2006 in that case do something like[code]<?phpwhile($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 Link to comment https://forums.phpfreaks.com/topic/21854-changing-table-datas-display/#findComment-97608 Share on other sites More sharing options...
sasa Posted September 24, 2006 Share Posted September 24, 2006 try[code]foreach ($rows as $k => $data) { switch ($k) { case 'UnitPrice': case 'RunningTotal': $data = '£ '.$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] Link to comment https://forums.phpfreaks.com/topic/21854-changing-table-datas-display/#findComment-97610 Share on other sites More sharing options...
cyprus Posted September 24, 2006 Author Share Posted September 24, 2006 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 Link to comment https://forums.phpfreaks.com/topic/21854-changing-table-datas-display/#findComment-97623 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.