/home/bjcompany/domains/benjabhorn.com/public_html/BJconcrete/control/portfolioList.php


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
<?php 
    $rowPerPage
=20;
            if((!
$_GET['page'])||($_GET['page']==1)){
                        
$_GET['page']=1;
                        
$startRow=0;
            }else{
                    
$startRow=($_GET['page']-1)*$rowPerPage;
            }    
    
####################################################    
        
$query="SELECT  * FROM tbl_portfolio_category WHERE mainCateId='0'   ORDER BY num ASC ";    
        
$resultList=mysql_query($query);
        
$Xrow=mysql_num_rows($resultList);
            

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />

</head>

<body><form action="<?php $_SERVER['PHP_SELF']?>" method="post" name="form1" enctype="multipart/form-data">
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr class="red">
    <td width="4%" height="25" align="center" bgcolor="#D9D9B3"><img src="images/black_icon/16x16/app_window.png" width="16" height="16" /></td>
    <td width="96%" bgcolor="#D9D9B3">รายชื่อผลงาน</td>
  </tr>
  <tr>
    <td colspan="2" class="txt10-black">&nbsp;
    </td>
  </tr>
  <tr>
    <td colspan="2" class="txt10-black"><table width="100%" border="0" cellpadding="1" cellspacing="1">
      <tr class="h3">
        <td height="30" align="center" bgcolor="#E0E0E0">&nbsp;</td>
        <td width="71%" height="30" align="center" bgcolor="#E0E0E0">ชื่อหมวดผลงาน</td>
        <td width="13%" height="30" align="center" bgcolor="#E0E0E0">จำนวน</td>
        <td width="12%" align="center" bgcolor="#E0E0E0">ดูรายละเอียด</td>
      </tr>
      <?php $n=1; while($data=mysql_fetch_assoc($resultList)){ 
                              if(
$n%2){ $bgcolor='#F2F2F2';}else{ $bgcolor=''; }
              
               
?>
      <tr class="txt10-black">
        <td width="4%" height="25" align="center" bgcolor="<?php echo $bgcolor?>"><img src="images/icon/blue.gif" alt="" width="10" height="10" /></td>
        <td align="left"  bgcolor="<?php echo $bgcolor?>"><?php echo $data['cate_name']?><br /></td>
        <td align="center"  bgcolor="<?php echo $bgcolor?>">
         (<?php CountportfolioInMainCate($data['id'])?>)
        
        </td>
        <td align="center" bgcolor="<?php echo $bgcolor?>">
        <a href="main.php?work=showPortfolio&ManCateID=<?php echo $data['id']?>">
        <img src="images/black_icon/16x16/zoom.png" width="16" height="16" style="border:none" /></a>
        </td>
      </tr>
      <tr>
        <td height="1" colspan="4" bgcolor="#DBDBDB"></td>
      </tr>
      <?php $n++; } ?>
      <tr>
        <td colspan="4">&nbsp;</td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
  </tr>
</table>
</form>
</body>
</html>