<?php

$a = parse_ini_file("/etc/cez.ini", true);
extract($a["Production"]);

$table_name = "Products";

$connection=mysql_connect($hostname, $username, $password) or die(mysql_error());

$db = mysql_select_db($database, $connection); 

$sql="select id, siteid, strName, publicSku from $table_name where siteid = 42432  order by publicSku";

$result = @mysql_query($sql,$connection) or die(mysql_error());
?>

<HTML>
<HEAD>
<TITLE></TITLE>
<META name="description" content="">
<META name="keywords" content="">
<META name="generator" content="CuteHTML">
<link rel="stylesheet" href="site.css">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#800080">
<table align="center">
  <tr>
	<td colspan="2" align="center"><form><input style="text-align: center; border: 3px double #999999;border-top-color: #CCCCCC; border-left-color: #CCCCCC; padding: 0.25em;
background-color: #FFFFFF; color: #333333; font-size: 75%; font-weight: bold; font-family: Verdana, Helvetica, Arial, sans-serif; cursor: pointer;"
type="button" name="Close Window" value="Close Window" onClick="javascript:window.close();"></form></td>
  </tr>
  <tr height="145">
	<td colspan="2" style="background-image:url(/images/header.gif);background-repeat:no-repeat">
<div id="headerContact">
<h4>5321 Derry Avenue. Unit A<br />
Agoura Hills, CA 91301<br />
818-765-5362<br />
<a href="mailto:orders@castletoyinc.com">orders@castletoyinc.com</a></h4>
</div>

</td>
  </tr>
  <tr>
  <td colspan="2">
<h3>Select the item number to see Certificate of Conformity. </h3>
<p>(If you do not find the certificate for the item you are interested in, it will be uploaded soon.  Please check back. <a href="mailto:orders@castletoyinc.com">orders@castletoyinc.com</a>)
  </td>
  </tr>
  <tr>
	<td><u>Item Number</u></td>
	<td><u>Item Name</u></td>
  </tr>
  <tr><td></td><td></td></tr>
<!--List-->
<?php
while ($row = mysql_fetch_array($result)) {
  echo '<tr><td><a href="CertConform/'.$row['publicSku'].'.pdf" target="_blank">'.$row['publicSku'].
	'</a></td><td>'.$row['strName']."</td></tr>\n";
}
?>
  <tr>
	<td colspan="2"align="center"><form><input style="text-align: center; border: 3px double #999999;border-top-color: #CCCCCC; border-left-color: #CCCCCC; padding: 0.25em;
background-color: #FFFFFF; color: #333333; font-size: 75%; font-weight: bold; font-family: Verdana, Helvetica, Arial, sans-serif; cursor: pointer;"
type="button" name="Close Window" value="Close Window" onClick="javascript:window.close();"></form></td>
  </tr>
</table>

</BODY>
</HTML>
