absolutely! sorry, here's my database schema and here's my (not working!) code....
<?php require_once('Connections/systestnew.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<p>Welome
<?= $_SESSION['MM_Username'] ?>
, please choose your area:</span></p>
</p>
<form id="form1" name="form1" method="post" action="resultsclient.php">
<p>
<label for="pc">Area</label>
<select name="pc" id="pc">
<option value="iv1">IV1</option>
<option value="iv2">IV2</option>
<option value="iv3">IV3</option>
<option value="iv4">IV4</option>
</select>
</p>
<p>and the services you would like to receive quotes for: </p>
<table width="200">
<tr>
<td><label>
<input <?php if (!(strcmp($row_Recordset2['Architect'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="Architects" id="Architects" />
Architects</label></td>
</tr>
<tr>
<td><label>
<input <?php if (!(strcmp($row_Recordset2['Builder'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="CheckboxGroup1" value="builders" id="CheckboxGroup1_1" />
Builders</label></td>
</tr>
<tr>
<td><label>
<input <?php if (!(strcmp($row_Recordset2['Painter'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="CheckboxGroup1" value="painters" id="CheckboxGroup1_2" />
Painters</label></td>
</tr>
<tr>
<td><label>
<input <?php if (!(strcmp($row_Recordset2['Roofer'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="CheckboxGroup1" value="roofers" id="CheckboxGroup1_3" />
Roofers</label></td>
</tr>
</table>
<p> </p>
<p>
<input type="submit" name="button" id="button" value="Submit" />
</p>
</form>
<p> </p>
</body>
</html>
