|
홈
> My Room |
 |
|
|
0)
{
switch($chours)
{
case '0' :
$que = "update counter set zero=zero + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '1' :
$que = "update counter set one=one + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '2' :
$que = "update counter set two=two + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '3' :
$que = "update counter set three=three + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '4' :
$que = "update counter set four=four + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '5' :
$que = "update counter set five=five + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '6' :
$que = "update counter set six=six + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '7' :
$que = "update counter set seven=seven + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '8' :
$que = "update counter set eight=eight + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '9' :
$que = "update counter set nine=nine + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '10' :
$que = "update counter set ten=ten + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '11' :
$que = "update counter set eleven=eleven + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '12' :
$que = "update counter set twelve=twelve + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '13' :
$que = "update counter set thirteen=thirteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '14' :
$que = "update counter set fourteen=fourteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '15' :
$que = "update counter set fifteen=fifteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '16' :
$que = "update counter set sixteen=sixteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '17' :
$que = "update counter set seventeen=seventeen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '18' :
$que = "update counter set eighteen=eighteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '19' :
$que = "update counter set nineteen=nineteen + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '20' :
$que = "update counter set twenty=twenty + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '21' :
$que = "update counter set twentyone=twentyone + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '22' :
$que = "update counter set twentytwo=twentytwo + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
case '23' :
$que = "update counter set twentythree=twentythree + 1 where cdate='$cdate'";
mysql_query($que, $conn);
break;
}
}
else
{
$que = "insert into counter(cdate) values('$cdate')";
mysql_query($que, $conn);
}
}
?>
