shopper_by_group_list.ihtml

phpShop是一个基于php的分布式电子商务模块

<h2>List User by Group</h2> 
<?php $q = "SELECT * from auth_user_md5, user_info ";
$q .= "where auth_user_md5.user_id=user_info.user_id ";
$q .= "AND auth_user_md5.perms='$perms' ";
$q .= "AND user_info.address_type='BT'";
$q .= "order by auth_user_md5.username"; 
$db->query($q);  
?> 
<table width="100%" border="0" cellspacing="0" cellpadding="2" class="RecordsTable">
  <tr > 
    <td width="23%" class="RecordsTableHeader">Username</td>
    <td width="46%" class="RecordsTableHeader">Full Name</td>
    <td width="31%" class="RecordsTableHeader">Group</td>
  </tr>
  <tr> 
    <td colspan="3"> 
      <hr />
    </td>
  </tr>
  <?php
while ($db->next_record()) { ?> 
  <tr nowrap="nowrap" > 
    <td width="23%"><?php
$url = SECUREURL . "?page=admin/shopper_form&user_id=";
$url .= $db->f("user_id");
echo "<A HREF=" . $sess->url($url) . ">";
echo $db->f("username"); 
echo "</A>"; ?></td>
    <td width="46%"><?php echo $db->f("bill_first_name") . " ";
echo $db->f("bill_middle_name") . " ";
echo $db->f("bill_last_name"); ?></td>
    <td width="31%"><?php echo $db->f("perms");  
?>&nbsp;</td>
  </tr>
  <?php } ?> 
</table>