if ($_GET['code'] == 5306712000) {
$hostname = "localhost";
$database = "hillcrestjewelers";
$username = "hcjewel";
$password = "SPark11ng";
$MYSQL = mysql_connect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database);
$items = array("itemnumber",
"metal",
"type",
"style",
"cstone",
"cshape",
"cclairty",
"ccolor",
"cweight",
"cscert",
"sstone",
"sshape",
"ssshape",
"sclairty",
"scolor",
"sweight",
"misc1",
"misc2",
"misc3",
"chain",
"length",
"width",
"cost",
"retail",
"status",
"memo",
"memo_number",
"memo_status",
"date"
);
$data = mysql_query("select * from `jewelery` order by `itemnumber` asc;");
$l = 0;
while ($l <= (mysql_num_rows($data)-1)) {
?>
$item = mysql_fetch_array($data);
foreach ($items as $key) {
echo('
' . str_replace('&', '&', $item[$key]) . '
' . "\n");
};
mysql_data_seek($data);
$l ++;
?>
};
};
?>