Location: PHPKode > scripts > Editable select input > editable-select-input/readme_db.txt
If you want to use the values stored into a table of a mysql db, it is very simple. Add, for example, a wrapper (in this example the ez_sql.class You find it in the site phpclasses.org)

include ("include/ez_sql.php");

After, you query your db as


if ( $mails = $db->get_results("SELECT mail FROM mail") )
{
	// Loop through the resulting array on the index $users[n]
	foreach ( $mails as $mail )
	{
		// Access data using column names as associative array keys
		$str.=$mail->mail.";";
        }
}
$select->print_select("mail",$str);
?>  

The select is at this point with the values of db

At the post of form you insert the value in the db if it is not present

if(isset($_POST['mail'])) {
//verifica se la mail inserita era giĆ  nel db o no
if (!( $n = $db->get_var("SELECT count(*) FROM mail WHERE mail = '$_POST[mail]'") ))
{
	// Insert into the database
	$db->query("INSERT INTO mail (mail) VALUES ('$_POST[mail]')");
}  
.... other instructions
}
Return current item: Editable select input