multidimensional array min max

Discussion in 'PHP' started by abs0lut01, Jul 26, 2008.

  1. #1
    <?php 
    session_start();
    include 'config.php';
    $post = $_GET['post'];
    $slected = array();
    		if(isset($_POST['checkb'])){
    			if(count($_POST['sa']) > 0){			
    				$do2 = mysql_query("UPDATE ptable SET status='updated' WHERE id='$post'") or die(mysql_error());
    				if($do2){
    				echo 'updated';
    				}
    				foreach($_POST['sa'] as $awrd) {
    		
    				$result = mysql_query("UPDATE ctable SET awarded='yes' WHERE id='$awrd'") or die(mysql_error());
    			   		$slected[] = $awrd;
    					if($result){
    					echo 'awarded'.$usersid;
    					}
    				}		
    			}			
    		} else{
    $result = mysql_query("SELECT status FROM ptable WHERE id=$post") or die(mysql_error());
    while ($row = mysql_fetch_array($result))
    {
    $status=$row['status'];
    }
    if($status!='updated'){
    ?>   
    <form method="post" name="formk" action="<?= $_SERVER['PHP_SELF']. '?' . $_SERVER['QUERY_STRING'] ?>">
    <?php
    $result = mysql_query("SELECT cid, iqid, cost, usersid FROM ctable WHERE post=$post");
    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);
    
    $query = "SELECT MIN(cost), MAX(cost) FROM ctable WHERE post=$post"; 
    $result = mysql_query($query) or die(mysql_error());
    while($row = mysql_fetch_array($result)){
    	$min=$row['MIN(cost)'];
    	$max=$row['MAX(cost)'];
    }
    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($min==$arr[$iqid][$userid]){
    		echo "<td bgcolor=\"#FFFF00\">".$arr[$iqid][$userid]."<input type='checkbox' name='sa[]' value='{$arr2[$iqid][$userid]}'></td>";
    		}else if($max==$arr[$iqid][$userid]){
    		echo "<td bgcolor=\"#00FF00\">".$arr[$iqid][$userid]."<input type='checkbox' name='sa[]' value='{$arr2[$iqid][$userid]}'></td>";
    		}else{
    		echo "<td>".$arr[$iqid][$userid]."<input type='checkbox' name='sa[]' value='{$arr2[$iqid][$userid]}'></td>";
    		}
    	}
    	else echo "<td></td>";	
      }
      echo "</tr>";
    }
    echo '</table>';
    echo '<input type="submit" name="checkb" />';
     echo'</form>';	
    }
    }
    ?>
    PHP:
    i want the lowest cost in every iqid to have background color #FF0000
    any help would be appreciated..
     
    abs0lut01, Jul 26, 2008 IP