Jump to content

problem displaying bgcolor


abs0lut

Recommended Posts

<?php 
include 'conn.php';
$q= mysql_query("SELECT min(cost) as mincost, iqid FROM ctable GROUP BY iqid, warranty") or die(mysql_error());
while($row = mysql_fetch_array($q)){
$mincost[]=$row['mincost'];
}
?>   
<form method="post" name="form1" action="<?= $_SERVER['PHP_SELF']. '?' . $_SERVER['QUERY_STRING'] ?>">
<?php
$result = mysql_query("SELECT cid, iqid, cost, usersid, warranty, othmsg FROM ctable ORDER BY warranty");
while ($row = mysql_fetch_array($result))
{
  $arr[$row['iqid']][$row['usersid']] = $row['cost'];
  $arr2[$row['iqid']][$row['usersid']] = $row['cid'];
  $uid[] = $row['usersid'];
}
$uid = array_unique($uid);
$qid = array_keys($arr);

echo '<table><tr><td></td>';
foreach($uid as $userid) echo "<td>$userid</td>";
echo '</tr>';
foreach($qid as $iqid)
{
  echo "<tr><td>$iqid</td>";
  foreach($uid as $userid)
  {
    if (isset($arr[$iqid][$userid]))
    {   
	if($arr[$iqid][$userid]==$mincost){
        	echo "<td bgcolor='#FF0000'>".$arr[$iqid][$userid]."
			<input type='radio'  name='iqid[$iqid]' value='{$arr2[$iqid][$userid]}'></td>";
	} else{
		echo "<td>".$arr[$iqid][$userid]."
			<input type='radio'  name='iqid[$iqid]' value='{$arr2[$iqid][$userid]}'></td>";
	}
    }
    else echo "<td></td>";    
  }
  echo "</tr>";
} ?>
</table>
<input type="submit" />
</form>    
<?php }
?> 

please help me display the background color #FF0000 for every lowest cost

Link to comment
https://forums.phpfreaks.com/topic/127619-problem-displaying-bgcolor/
Share on other sites

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.