search page

[salomi]

hey!

i have a doubt for that below search page.
In this coding,suppose i select in the dropdown box moviname,i ll fetch only moviename at the same time in the keytype i can type any words .in the statement i need query.

<form id="form1" name="form1" method="post" action="search.php">
<table width="470" border="1">
<tr>
<th width="221" scope="col">search</th>
<th width="233" scope="col"><select name="search">
<option value="movie" >moviename</option>
<option value="songs">songs</option>
<option value="actor">actor</option>
<option value="dirctor">director</option>
</select> </th>
</tr>
<tr>
<td colspan="2"><input type="submit" name="submit" value="Submit" /></td>
</tr>
</table>
</form>
<?php
if(isset($_POST['submit']))
{
$con=mysql_connect("localhost","root","");
mysql_select_db("film");
$sql=mysql_query("select * from tbl_film where release_year>2003 ");
while($res = mysql_fetch_array($sql))
{
echo $res['film_name'];
}
}

?>
</body>

[YAOMK]

i ll fetch only moviename at the same time in the keytype i can type any words .

where is the field for the keytype? what does it intend to do? please be more specific as to what your problem/doubt is.

If the issue is that you don't want a conflict between two inputs, use an if condition to determine what to select from your database.