# Php/sql, interface change refresh

**URL:** <https://forum.kirupa.com/t/php-sql-interface-change-refresh/217757>\
**Category:** Uncategorized\
**Created:** [March 1, 2007, 6:00pm UTC](https://forum.kirupa.com/t/php-sql-interface-change-refresh/217757 "2007-03-01T18:00:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![randomagain](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@randomagain](https://forum.kirupa.com/u/randomagain)\
**Post date:** [March 1, 2007, 6:00pm UTC](https://forum.kirupa.com/t/php-sql-interface-change-refresh/217757/1 "2007-03-01T18:00:15Z")

</div>

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.**

```auto
 
$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…

```auto
 
<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>

```
