<html>
<head>
<title>EZ Shopper - Check if Category ID is vacant !</title></head>
<body bgcolor = "#FFFFFF">
<?
 /***************************************************************************
 *			checkids.php                   	                    *
 *                     	          				            *
 *   File Info:		  Check category id                                 *
 *   Copyright:       Copyright 2003 http://www.128concepts.com             *
 *						                            *
 ***************************************************************************/

include("./config.php");

echo "<center><img src=images/searching.gif border=0><br><font face=verdana size=3 color=#000080>Check if Category ID is vacant</font></center>";
$table= "category";
$conn = @mysql_connect($server,$user,$password)
	or die("Cannot connect to database");
$rs = @mysql_select_db($database,$conn) 
	or die("Unable to view product image");
$sql = "SELECT catid from $table order by catid";
$products = mysql_query($sql,$conn);
$prods = mysql_num_rows($products);

echo "<br><center><TABLE cellSpacing=0 cellPadding=0 border=0><TR>
      <TD background=./images/border_cnr_tl.gif><IMG height=8 alt= src=./images/px.gif width=8 border=0></TD>
      <TD background=./images/border_top.gif><IMG height=8 alt= src=./images/px.gif width=120 border=0></TD>
      <TD background=./images/border_cnr_tr.gif><IMG height=8 alt= src=./images/px.gif width=8          border=0></TD></TR><TR><TD background=./images/border_left.gif>
       <IMG height=60 alt= src=./images/px.gif width=8 border=0></TD>
       <TD width=120>
       <TABLE cellSpacing=0 cellPadding=4 width=300 border=0>
       <TBODY><tr><td align=center><center><img src=images/mouses.gif border=0><font face = Verdana size =2 color=navy>  Listing all used Category IDs</font></center></td></tr>
<tr><td align=center>....................................................</td></tr><tr><td align=center><font face=verdana size=1 colour=#cccccc>The scroll list below shows all used category ids.</font></td></tr>";

$msg = "<select><option>--START--</option>";
while ($row = mysql_fetch_array($products))
	{
	
		$catid = $row["catid"];
		$msg.= "<option>-- $catid --</option>";
		
	}
	$msg.="<option>-- END --</select>";
	echo "<tr><td align=center width=320>$msg</td></tr>";
echo "</TBODY></TABLE></TD><TD background=./images/border_right.gif>
      <IMG height=60 alt= src=./images/px.gif width=8 border=0></TD></TR>
      <TR><TD background=./images/border_cnr_bl.gif>
      <IMG height=8 alt= src=./images/px.gif width=8 border=0></TD>
      <TD background=./images/border_bottom.gif>
      <IMG height=8 alt= src=./images/px.gif width=121 border=0></TD>
      <TD background=./images/border_cnr_br.gif>
      <IMG height=8 alt= src=./images/px.gif 
      width=8 border=0></TD></TR></TABLE></center><br><br>";
	echo("<center><a href = javascript:window.close('acePopup')>Close Window</a></center>");
?>
  
</body>
</html>