insert values to one field

$pdf=" SELECT DATE(tran_date) as dateiy,unit_serial,account_no,
      SUM(case when pulse_channel = 1 then unit_qty else 0 end) as val1,
      SUM(case when pulse_channel = 2 then unit_qty else 0 end) as val2,
      SUM(case when pulse_channel = 3 then unit_qty else 0 end) as val3,
      SUM(case when pulse_channel = 4 then unit_qty else 0 end) as val4,
      SUM(unit_qty) as Total
  from count_transactions
  WHERE  DATE(tran_date) BETWEEN '".$start."' AND '".$end."'
  GROUP BY unit_serial";
$result=mysql_query($pdf) or die('Could not connect: ' . mysql_error());
$num=mysql_num_rows($result);
//echo $num;

while($rows = mysql_fetch_array($result)) { 
       $account=$rows['account_no'];
       $unit=$rows['unit_serial'];
       $h1=$rows['val1'];
       $h2=$rows['val2'];
       $h3=$rows['val3'];
       $h4=$rows['val4'];

//print var_dump($rows);
$query2="select * from net_watch_units
         where serial_no=$unit  ";
         $result3=mysql_query($query2);
         $record3=mysql_fetch_assoc($result3);
         $unite=$record3['UnitName'];
         $p1=$record3['pulser1_name'];
         $p2=$record3['pulser2_name'];
         $p3=$record3['pulser3_name'];
         $p4=$record3['pulser4_name'];
         $low1=$record3['pulser1_daily_alarm_low'];
         $low2=$record3['pulser2_daily_alarm_low'];
         $low3=$record3['pulser3_daily_alarm_low'];
         $low4=$record3['pulser4_daily_alarm_low']; 
         $high1=$record3['pulser1_daily_alarm_high'];
         $high2=$record3['pulser2_daily_alarm_high'];
         $high3=$record3['pulser3_daily_alarm_high'];
         $high4=$record3['pulser4_daily_alarm_high'];

$q2="SELECT account_name FROM account_details WHERE auto_id=$account";
                   $res2=mysql_query($q2);
                   $r2=mysql_fetch_array($res2);
                   $noms=$r2['account_name'];  
                   

if($h1>$high1){
   $mes='High usage alarm detected'
   $v1=$h1;
   $p11=$p1;
}
elseif($h2>$high2){
   $mes='High usage alarm detected'
   $v2=$h2;
   $p22=$p2;
}
elseif($h3>$high3){
   $mes='High usage alarm detected'
   $v3=$h3;
   $p33=$p3;
}
elseif($h4>$high4){
   $mes='High usage alarm detected'
   $v4=$h4;
}
elseif($h1>$low1){
   $mes='Low usage alarm detected'
   $v1=$h1;
   $p44=$p4;
}
elseif($h2>$low2){
   $mes='Low usage alarm detected'
   $v2=$h2;
}
elseif($h3>$low3){
   $mes='Low usage alarm detected'
   $v3=$h3;
}
elseif($h4>$low4){
   $mes='Low usage alarm detected'
   $v4=$h4;
}
$sql="INSERT INTO `alarm` (account, unitname, channel, usage, details)
VALUES
('$noms','$unite','$......";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

Select all Open in new window