1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
<?
include_once("./_common.php");
include("./include/common/header.php"); ?>
<script>
function asLink(f,id){
if(f == 'y'){
location.href = "mypageqna_view.php?uid="+id;
}
}
</script>
<div class="location">
<div class="wrap">
<a href="./mall.php" class="home"><span class="screen_out">Home</span></a>
<span>></span><a href="./cscenter.php"><span class="depth1">°í°´¼¾ÅÍ</span></a>
<span>></span><span class="depth2">1:1¹®ÀÇ</span>
</div><!-- //wrap -->
</div><!-- //location -->
<div class="wrap">
<div class="contents">
<? include("./include/cscenter/sub_lnb.php"); ?>
<div class="boardSection">
<table class="qnaTable">
<caption>1:1¹®ÀÇ</caption>
<colgroup>
<col style="width:150px;"><col style="width:200px;">
<col style="width:220px;"><col style="width:160px;">
<col style="width:100px;"><col style="width:160px;">
</colgroup>
<tr>
<th>¹øÈ£</th>
<th>»óÈ£¸í</th>
<th>¼ÒÀçÁö</th>
<th>´äº¯ÀÚ</th>
<th>»óÅÂ</th>
<th>ÀÛ¼ºÀÏ</th>
</tr>
<?
/* ·Î±×¾Æ¿ô ½Ã Àüü ±Û, ·Î±×ÀÎÇϸé Àڱ⠱۸¸ º¸ÀÓ */
if( !isset($_COOKIE['USERID']) || $_COOKIE['USERID'] == "" ) {
$sql = " select a.uid , b.Madd, b.Mcompany, a.proResult, b.Mid, a.fid , b.Mname , a.reg_date from mBoard_as a, member b WHERE a.id = b.Mid and b.Madd != '' and a.thread = 'A' order by a.uid desc limit 20 ";
$result = mysql_query($sql) or die (mysql_error());
} else {
$sql = " select a.uid , b.Madd, b.Mcompany, a.proResult, b.Mid, a.fid , b.Mname , a.reg_date from mBoard_as a, member b WHERE a.id = b.Mid and a.id = '$_COOKIE[USERID]' and a.thread = 'A' order by a.uid desc limit 20 ";
$result = mysql_query($sql) or die (mysql_error());
}
if( mysql_num_rows($result) > 0 ){
while ($Row = mysql_fetch_array($result)){
if( $Row[3] == "A") $proResult = "´ë±â";
if( $Row[3] == "B") $proResult = "Á¢¼ö";
if( $Row[3] == "C") $proResult = "ó¸®Áß";
if( $Row[3] == "D") $proResult = "º¸·ù";
if( $Row[3] == "E") $proResult = "¿Ï·á";
if( $Row[3] == "F") $proResult = "Áú¹®";
if( $Row[3] == "G") $proResult = "¿äû";
$replyRow_0 = "";
$replyRow_1 = "";
$addr = explode(" ", $Row[1] );
$replyQry = " select uid,name from mBoard_as where fid = '$Row[5]' and thread = 'AA' ";
$replyResult = mysql_query( $replyQry);
if( mysql_num_rows($replyResult) > 0){
$replyRow = mysql_fetch_array($replyResult);
$replyRow_0 = $replyRow[0];
$replyRow_1 = $replyRow[1];
}
if($Row[2] == ""){ //ȸ»ç¸íÀÌ ¾øÀº°æ¿ìó¸®.
$_disName = $Row[6];
} else {
$_disName = $Row[2];
}
$reg_date = date('Y-m-d' ,$Row['reg_date']);
?>
<tr <? if(isset($_COOKIE['USERID']) && $Row[4] == $_COOKIE['USERID'] && $replyRow_0 !== "" && $Row[3] == "E"){ echo "onClick=\"asLink('y','$replyRow_0');\" style='cursor:pointer;' bgcolor=#ffffff ";} ?>>
<td><?=$Row[0];?></td>
<td><?=$_disName;?></td>
<td><?=$addr[0]." ".$addr[1];?></td>
<td><?=$replyRow_1;?></td>
<td><?=$proResult;?></td>
<td><?=$reg_date;?></td>
</tr>
<? } } ?>
</table>
<div class="qnaBtn1">
<a href="mypageqna.php">±Û¾²±â</a>
</div><!-- //qnaBtn1 -->
</div><!-- //boardSection -->
</div><!-- //contents -->
</div><!-- //wrap -->
<? include("./include/common/footer.php"); ?>
|