$Organisation[1] is always going to be empty because you're only selecting one item per row from the DB....

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

Reply via email to