I am having a little trouble getting my form to show when I put it into a function. It will show part of it until the first dropdown menu - which pulls data from the database for options. My guess is I am going about getting that data wrong to put it in the function. If not in a function the form works fine. Any advice would be appreciated.
<?php
require_once('includes/connectdb.php');
require_once('includes/dbal.php');
$query_Character = "SELECT charID, charName FROM eqchar ORDER BY charName ASC";
$Character = mysql_query($query_Character) or die (mysql_error());
$row_Character = $db->fetch_record($Character);
$totalRows_Character = $db->num_rows($Character);
$query_Slot = "SELECT * FROM eqslot ORDER BY slotName ASC";
$Slot = mysql_query($query_Slot) or die(mysql_error());
$row_Slot = $db->fetch_record($Slot);
$totalRows_Slot = $db->num_rows($Slot);
?>
<!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=iso-8859-1" />
<script language="javascript" type="text/javascript" src="niceforms.js"></script>
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="cssmenu.css" rel="stylesheet" type="text/css" />
<link href="forms.css" rel="stylesheet" type="text/css" />
<style type="text/css" media="screen">@import url(forms.css);</style>
</head>
<body>
<?php
require_once('includes/nav.php');
showform();
function showform() {
echo '<div id="contentwrapper">
</div>
<div id="formcolumn">
<form action="process.php" method="post" class="niceform" target="_blank">
<fieldset id="niceform">
<legend>Armor</legend>
<p><label for="armorItem">Item:</label>
<input type="text" id="armorItem" name="armorItem" size="20" /></p>
<p><label for="armorLink">Link:</label>
<input type="text" id="armorLink" name="armorLink" size="20" /></p>
<p><label for="armorSlot">Slot:</label>
<select size="1" id="armorSlot" name="slotID" class="width_90">
<option value=""></option>';
do {
echo '<option value="';
echo $row_Slot['slotID'];
echo '">';
echo $row_Slot['slotName'];
echo '</option>';
} while ($row_Slot = $db->fetch_record($Slot));
$rows = $db->num_rows($Slot);
if($rows > 0) {
mysql_data_seek($Slot, 0);
$row_Slot = $db->fetch_record($Slot);
}
echo ' </select></p>
<p><label for="armorClass">Class:</label>
<select size="1" id="class" name="charID" class="width_90">
<option value=""></option>';
do {
echo '<option value="';
echo $row_Character['charID'];
echo '">';
echo $row_Character['charName'];
echo '</option>';
} while ($row_Character = $db->fetch_record($Character));
$rows = $db->num_rows($Character);
if($rows > 0) {
mysql_data_seek($Character, 0);
$row_Character = $db->fetch_record($Character);
}
echo ' </select></p>
<p><input type="checkbox" name="itemAug" id="armorChk" value="1" />
<label for="armorChk"> Augment </label></p>
<p><label for="armorImage">Image:</label>
<input type="text" id="Image" name="Image" size="12" /></p>
<p><label for="Comment">Comments:</label>
<textarea id="armorComment" name="Comment" rows="10" cols="30"></textarea></p>
</fieldset>
<br />
<input type="hidden" name="_submit_check" value="1"/>
<input name="additem" type="submit" id="additem" value="submit" />
<input name="reset" type="reset" id="reset" value="reset" />
</form></div>';
}
require_once('includes/footer.php');
?>
</div>
</body>
</html>
<?php
$db->free_result($Slot);
$db->free_result($Character);
?>
