저기
거기는 웹상으로 다 보여져있어서.........
sql 문 실행에
$host_name="localhost";
$user_name="dasbader";
$user_password ="*****";//-보안상 *표시로 함
$db_name="dasbader";
$connect =mysql_connect($host_name,$user_name,$user_password);
mysql_select_db($db_name,$connect);
$result=mysql_list_table($db_name);
$i=0;
$tablelist="";
while($i<mysql_num_rows($result))
{
$tb_names[$i]=mysql_tablename($result,$i);
$table.="/".$tb_names[$i];
$i++;
}
if(!eregi("zerocount",$tablelist))
{
$que="CREATE TABLE zerocount{
id int(11) DEFAULT '0'NOT NULL auto_increment
count int(11).
data varchar(8),
PRIMARY KEY(id)";
mysql_query($que,$connect);
}
$td=date("Ymd");
$que="select *from zerocount where id= 1;
$result=mu-sql_query($que,$connect);
$check=mysql_fetch-array($result);
if!($check[count])
{
$que ="INSERT INTO zerocont VALUES ('',0,'$td')";
mysql_query($que,$connect);
}
if($HTTP_COOKIE_VARS[zerocount]!=$td)
{
setcookie("zerocount",$td,time()+60*60*24);
$que = "update zerocount SET count=count+1 WHERE id=1";
$result=mysql_query($que,$connect);
$que = "update zerocount SET count=count+1 WHERE date='$td'";
$result=mysql_query($que,$connect);
}
$que="select*from zerocount where id=1";//전체
$result=mysql_query($que,$connect);
$temp=mysql_fetch_array($result);
$count[0]=$temp[count];
$que="select*from zerocount order by id desc limit 2";//오늘 어제
$result=mysql_query($que,$connect);
$temp=mysql_fetch_array($result);
$count[2]=$temp[count];
$tempid=$temp[id];
$que="select*from zerocount where id >1 order by count desc limit 1";//최고
$result=mysql_query($que,$connect);
$temp=mysql_fetch_array($result);
$count[3]=$temo[count];
$que="select*from zerocount where id<$today_id count limit 1";
$result=mysql_qeury($que,$connect);
$temp=mysql_fetch_array($result);
$count[4]=temp[count];
를 써 넣으면
1line에 에러가 납니다.......
음 왜이지..........
이건 어디에서 실행을 시켜야하나요.....?
혹시 telnet 모드에서?
음 잘모르겠습니다
|