drop down menu takes values from database

[fazlionline]

Hi all

Is this possible with PHP to make a dropdown menu which takes its values from a database?

[jlhaslip]

Indeed it is possible.

Content management systems use Databases to list links for all the Categories and the sub-categories and articles of each of those.

Download a CMS to see how it is done. Various CMS's will handle them differently, so check out a couple of them.

[sjhwebdesign]

<?php

$getcategories = mysql_query("SELECT FROM categories ORDER BY name ASC");

?>

<?php

while($categories = mysql_fetch_array( $getcategories ))

{

?>

<?php echo $categories['name']; ?>

<?php

}

?>