output all the the keywords on to a pull down menu for

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bxm_3
Forum Newbie
Posts: 13
Joined: Sun Nov 20, 2005 6:23 pm

output all the the keywords on to a pull down menu for

Post by bxm_3 »

I wish to output all the possible keywords in the table column on a pull down menu but they are displayed only once.

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
}
?>
but the code displays each keyword in its own pull down menu
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

You've written ten <select> tags; one per "keyword." You only need one <select> with eleven options.
Post Reply