How to retrieve data from mysql using drop down menu with text search field.

[mmarif4u]

Hi everyone,
I have a little problem in php coding.
i have mysql table guestbook:
Fields are Id,name,email,c omment,datetime .
Now i want to search the database by php query using
a Dropdown menu (for example Name,Id) with a text search field.
What will be the query.
Can anyone help me with details.
thanks.

[ronverdonk]

May I conclude from your question ("What will be the query?") that you already have the drop-down and the textbox? If so, the table query can be defined as something like (search items in $search1 and $search2):

$sql  = 'SELECT Id, Name ';
        $sql .= 'FROM MyTable ';
        $sql .= 'WHERE Name REGEXP "' . $search1 . '" ';
        $sql .= 'AND Id REGEXP "' . $search2 . '" ';
        $sql .= 'ORDER BY Id';

Ronald :cool:

[mmarif4u]

May I conclude from your question ("What will be the query?") that you already have the drop-down and the textbox? If so, the table query can be defined as something like (search items in $search1 and $search2):

$sql  = 'SELECT Id, Name ';
        $sql .= 'FROM MyTable ';
        $sql .= 'WHERE Name REGEXP "' . $search1 . '" ';
        $sql .= 'AND Id REGEXP "' . $search2 . '" ';
        $sql .= 'ORDER BY Id';

Ronald :cool:

Thanks Ronald for reply.
i dont have the complete code in php.
Can u help me here in code.
Thanks.

[rdub]

Did you ever get the complete answer?