Location: PHPKode > projects > NOLA > invmarkuplst.php
<? include('includes/main.php'); ?>
<? //invmarkuplst
	echo texttitle('Standard Markup Set List');
	$recordSet = &$conn->Execute("select markupset.description, pricelevel.description, markupsetlevel.markuppercent from pricelevel, markupset left join markupsetlevel on markupset.id=markupsetlevel.markupsetid where markupsetlevel.pricelevelid=pricelevel.id order by markupset.id, pricelevel.id");
	if (!$recordSet->EOF) {
		echo '<table border="1"><tr><th width="10%">Markup Set Description</th><th>Pricing Level</th><th>Markup %</th></tr>';
	} else {
		die(texterror('No valid markup codes found.'));
	};
	while (!$recordSet->EOF) {
		echo '<tr><td width="10%" align="center">'.$recordSet->fields[0].'</td><td align="left">'.$recordSet->fields[1].'</td><td align="left">'.$recordSet->fields[2]."</td></tr>";
		$recordSet->MoveNext();
	};
?>
<? include('includes/footer.php'); ?>
Return current item: NOLA