0
 <form action="searchdetail.php" method="post"> 
  SEARCH BY:
    <select name="searchby">
    <option value="gname">Guest Name</option>
    <option value="city">Guest City</option>
    </select>
    <input name="query" type="text" />
    <input name="subval" type="submit" value="Search" />
    </form>

and searchdetail.php

include("config.php");
    if(isset($_POST['subval']))
        { 
            $query = mysql_real_escape_string(trim($_POST['query']));   
            $sql = mysql_query ("SELECT * FROM voucher WHERE gname = '$query'"); 
            echo "<table border=1 width=860 align=center cellsapcing=5 cellpadding=5>";
            echo "<tr>";
            echo "<th>Guest Name</th>";
            echo "<th>Guest City</th>";
            echo "</tr>";
        while ($row = mysql_fetch_array($sql)) 
            { 
                echo "<tr>";
                echo "<td>" . $row['gname'] . "</td>";
                echo "<td>" . $row['city'] . "</td>";
                echo "</tr>";
            }
        }

how can i get combobox value from that page. for example if user selects GUEST CITY from combobox and then he types PORT BLAIR in the input text field. then searchdetail.php page should show the PORT BLAIR guests. how can i do that? i'm little bit confused.. before i have done this but i'm using only textbox. But here i want to pass the id of combobox value too.. any help...

2
Contributors
4
Replies
12
Views
3 Years
Discussion Span
Last Post by Indians
1
$query = mysql_real_escape_string(trim($_POST['query']));   
$field = mysql_real_escape_string(trim($_POST['searchby']));
$sql = mysql_query ("SELECT * FROM voucher WHERE `$searchby` = '$query'");

I'm assuming that your DB fields are the same as the values in the select option values. Consider moving away from mysql - I'm sure I've mentioned this before.

0

i tried. but still its not working. here that combobox values are my table column names. first i want to select my table column name (what user select in that combobox) then i want to get row values(what user types in that text field) from that particular column name.???

Edited by Indians

1

Have you echoed out the query string to see what it gives?

$str = "SELECT * FROM voucher WHERE `$searchby` = '$query'";
echo $str;
$sql = mysql_query ($str) or die(mysql_error());

That's always a good idea...

0

now i got it thanks...
i think this is the problem
before:

$sql = mysql_query ("SELECT * FROM voucher WHERE `$searchby` = '$query'");

now i changed :

$sql = mysql_query ("SELECT * FROM voucher WHERE `$field` = '$query'");

so only i didn't get the results. now its ok...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.