SELECT OrgName....
If you want the same output in both places, just do this...
echo ( "<option value=\"$Organisation[0]\">$Organisation[0]\n" );
Denis L. Menezes wrote:
<select name="OrgName[]" size=5 id="OrgName" >
<?php //connecting to the database
$link = mysql_connect("localhost","lodestone","trypass");
if ($link){
Print "";
} else {
Print "No connection to the database";
}
if (!mysql_select_db("catapult_com")){
Print "Couldn't connect database";
} else {
Print ""."<br>\n";
}
$sql="SELECT OrgName From TableResults ORDER BY OrgName";
$result=mysql_query($sql);
While($Organisation=mysql_fetch_array($result))
{
Print("<OPTION VALUE=\"$Organisation[0]\">$Organisation[1]\n");
}
?>
</select>
-- By-Tor.com It's all about the Rush http://www.by-tor.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php