I've been trying something different but can anyone say why the <option> code returns a 0 (zero).
function template_ventChoose()
{
global $context, $settings, $options, $scripturl, $modSettings, $txt, $row_vcmusicians;
include 'ventChoose.php';
echo'
<form action="', $scripturl, '?action=profile2" method="post" accept-charset="', $context['character_set'], '" name="creator" id="creator" enctype="multipart/form-data">
<select name="T5a_musicians">
<option value="', $row_vcmusicians['musicians'], '"', $row_vcmusicians['musicians'] == $row_vcmusicians['musicians'] ? ' selected="selected"' : '', '>', $row_vcmusicians['musicians'], '</option>';
while ($row_vcmusicians = mysql_fetch_assoc($vcmusicians));
$rows = mysql_num_rows($vcmusicians);
if($rows > 0) {
mysql_data_seek($vcmusicians, 0);
$row_vcmusicians = mysql_fetch_assoc($vcmusicians);
}
echo'
</select>';
This is a new method of populating the menu. It works in htm except I had to edit the option a bit because it's within a function. Here's the working code in htm ..
<select name="T5a_musicians" id="T5a_musicians">
<?php
do {
?>
<option value="<?php echo $row_vcmusicians['musicians']?>"><?php echo $row_vcmusicians['musicians']?></option>
<?php
} while ($row_vcmusicians = mysql_fetch_assoc($vcmusicians));
$rows = mysql_num_rows($vcmusicians);
if($rows > 0) {
mysql_data_seek($vcmusicians, 0);
$row_vcmusicians = mysql_fetch_assoc($vcmusicians);
}
?>
</select>