SQL with a Switch Statement ?

[scarface83]

Hi, can you use a switch statement with mysql and how would i do it with the following ?

 

 

require ('db_connect.inc');

$query ="SELECT abs_value, SUM(abs_value) FROM absence_mgt WHERE ID='$vtc_login' GROUP BY abs_value ";


while ($row = mysql_fetch_array($run)) {
                if ($row['abs_value'] == 1) {
                      $late_num = $row;
                }elseif ($row['abs_value'] == 2) {
                  	$sick_num = $row;
                }elseif ($row['abs_value'] == 3) {
                        $sickhf_num =$row;
                }elseif ($row['abs_value'] == 4) {
        	        $awol_num =$row;    
                }
        }

 

 

Thanks

[obsidian]

I believe this is what you're after:

<?php
switch ($row['abs_value']) {
  case 1:
    $late_num = $row;
    break;

  case 2:
    $sick_num = $row;
    break;

  case 3:
    $sickhf_num =$row;
    break;

  case 4:
    $awol_num =$row;    
    break;
}
?>