Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Button to populate listbox

Codes here !

Moderators: macek, egami, gesf

Button to populate listbox

Postby DS928 » Thu Jan 10, 2013 11:25 am

I would like a button to populate my listbox. How would I do this. I have this so far. Also I want the listbox to be empty until the button is pushed. Helpis appreciated. Thank you.

Code: Select all
<?php
$dbc = mysql_connect('', '','')
     or die('Error connecting to MySQL server.');

mysql_select_db('MyDB');

$result = mysql_query("select * from tblRestaurants order by RestName ASC");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>SEARCH</title>


</head>

<body>



<p><center>SEARCH</CENTER></P>
<select name="RestName">
<?php
while ($nt= mysql_fetch_assoc($result)) 
{
     echo '<option value="' . $nt['RestID'] . '">' . $nt['RestName'] . '</option>';

?>
</select>
 
<p> SPACE</p>


<p></p>




<p>Click "SUBMIT" to display the calculation results</p>

<input type="submit" name="Submit" value="Submit" />

<br />


</form>

</body>

</html>
DS928
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Jan 09, 2013 4:44 pm

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.