// include header include("inc_header.php"); // initialize parameter variables $p_itm_pk = init_param("p_itm_pk", ""); // initialize sql fields $l_sql_fields = ("*"); // initialize sql tables $l_sql_tables = ("items"); // initialize sql where expression $l_sql_where_exp = ("(pk = '".$p_itm_pk."')"); $l_sql_where = ("WHERE (".$l_sql_where_exp.")"); // initialize sql order $l_sql_order = (" ORDER BY pk ASC"); // construct sql to retrieve the requested records $l_sql = ("SELECT ".$l_sql_fields." FROM ".$l_sql_tables." ".$l_sql_where." ".$l_sql_order); // retrieve the requested records $rs_itm = mysqli_query($g_db_connection, $l_sql); // get number of records to display $l_recs = mysqli_num_rows($rs_itm); // process the retrieved records if($r_itm = mysqli_fetch_array($rs_itm)) { // retrieve the record data $itm_pk = stripslashes($r_itm["pk"]); $itm_type = stripslashes($r_itm["type"]); $itm_sku = stripslashes($r_itm["sku"]); $itm_image = stripslashes($r_itm["image"]); $itm_monogram = stripslashes($r_itm["monogram"]); $itm_matter = str_replace("...", "", stripslashes($r_itm["matter"])); } ?>
// check to see if there is a monogram
if($itm_monogram != "")
{
?>
}
?>
|
echo($itm_matter) ?> |