Zend - The PHP Company




Forms

Add Code


Drop down list  

Type: code fragment
Added by: idban
Entered: 03/03/2000
Last modified: 08/12/1999
Rating: *** (10 votes)
Views: 19010
list your database to drop down menu


<?
/* list your database to drop down menu
this is only sample, just modify it for your onw gewd

idban secandri
*/

$hostname "127.0.0.1";     
$username "username";     
$password "password";     
$usertable "tabelname";     
$dbName "dbname";     
MYSQL_CONNECT($hostname$username$password) OR DIE("Unable to connect to database");
@
mysql_select_db"$dbName") or die( "Unable to select database");
?>
<?
echo '<form><select name=$colom_name>';
$XX "data empty!";

$aku mysql_query("SELECT * FROM $usertable WHERE colom_name order by colom_name2 DESC");
 
while (
$row  =  mysql_fetch_array($aku))
   {
        
$colom_name=$row["colom_name"];
        
$colom_name2=$row["colom_name2"];

 echo 
"<option value=$colom_name>$colom_name2n";
    }

if (
$colom_name=""
{
print (
"$XX");
}
echo 
"</select>n";      
echo 
"<input type=submit value="Go..go gadget">n";

print (
"<br><br>");
?>



Usage Example




Rate This Script





Search



This Category All Categories