Hi, newbie
I have got my code working, however I have to apply user interfaces.
Ie a Search and Dropdown
**Question is how do I do this? 
**
I need to input search and/or dropdown, then refresh the page, hence displaying the correct data.
$result = mysql_query('SELECT * FROM sweets WHERE sCategory = "Penny Chews" ');
?>
</head>
<body>
<?php
// print database content
while($row = mysql_fetch_array($result))
{
The following is all wrong but essenially the rig I want…
<form method="get" action="<?php print($_SERVER['PHP_SELF']); ?>">
Search:<input name="Make" id="Make" type="text" value="<?php print($uid); ?>" /><br/>
<select name=navi onChange="go()">
<option value=''>--- Select Catogory---
<option value="Penny Chews">Penny Chews
<option value="Bubblegum">Bubblegum
<option value="Boiled sweets">Boiled sweets
<option value="Tubes of sweets">Tubes of sweets
<option value="Fudge">Fudge
<option value="Chocolate Bars">Chocolate Bars
<option value="Lollies">Lollies
</select>
<input name="submit" type="submit" value="Update" />
</form>
