[PHP] Populating a list box from a database - The code

[Denis L. Menezes]

<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>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php