Here is an example
Code: Select all
$rs=@mysql_query($sql);
$sql="select DISTINCT KEYWORD1 FROM PENPAL";
##$num=mysql_numrows($rs);
while($row=mysql_fetch_array($rs))
{
$keyword1=$row[KEYWORD1];
$keyword2=$row["KEYWORD2"];
$keyword3=$row["KEYWORD3"];
$keyword4=$row["KEYWORD4"];
$keyword5=$row["KEYWORD5"];
$keyword6=$row["KEYWORD6"];
$keyword7=$row["KEYWORD7"];
$keyword8=$row["KEYWORD8"];
$keyword9=$row["KEYWORD9"];
$keyword10=$row["KEYWORD10"];
?>
<tr><td>Keyword</td>
<td><select size="1" name="keyword1"><option value="0">Select...</option>
<option value="<?php echo $keyword1?>"><?php echo $keyword1 ?></option>
</select>
</td>
</tr>
<!--
<tr><td>Keyword</td>
<td><select size="1" name="keyword2"><option value="0">Select...</option>
<option value="<?php echo $keyword2?>"><?php echo $keyword2 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword3"><option value="0">Select...</option>
<option value="<?php echo $keyword3?>"><?php echo $keyword3 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword4"><option value="0">Select...</option>
<option value="<?php echo $keyword4?>"><?php echo $keyword4 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword5"><option value="0">Select...</option>
<option value="<?php echo $keyword5?>"><?php echo $keyword5 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword6"><option value="0">Select...</option>
<option value="<?php echo $keyword6?>"><?php echo $keyword6 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword7"><option value="0">Select...</option>
<option value="<?php echo $keyword7?>"><?php echo $keyword7 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword8"><option value="0">Select...</option>
<option value="<?php echo $keyword8?>"><?php echo $keyword8 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword9"><option value="0">Select...</option>
<option value="<?php echo $keyword9?>"><?php echo $keyword9 ?></option>
</select>
</td>
</tr>
<tr><td>Keyword</td>
<td><select size="1" name="keyword10"><option value="0">Select...</option>
<option value="<?php echo $keyword10?>"><?php echo $keyword10 ?></option>
</select>
</td>
</tr>
-->
<tr>
<td>
<?php echo $keyword1 ?>
</td>
</TR>
<!--
<td>
<?php echo $keyword2 ?>
</td>
<td>
<?php echo $keyword3 ?>
</td>
<td>
<?php echo $keyword4 ?>
</td>
<td>
<?php echo $keyword5 ?>
</td>
<td>
<?php echo $keyword6 ?>
</td>
<td>
<?php echo $keyword7 ?>
</td>
<td>
<?php echo $keyword8 ?>
</td>
<td>
<?php echo $keyword9 ?>
</td>
<td>
<?php echo $keyword10 ?>
</td>
</tr>
-->
<?php
}
?>