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,comment,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):

Expand|Select|Wrap|Line Numbers

 $sql  = 'SELECT Id, Name ';

        $sql .= 'FROM MyTable ';

        $sql .= 'WHERE Name REGEXP "' . $search1 . '" ';

        $sql .= 'AND Id REGEXP "' . $search2 . '" ';

        $sql .= 'ORDER BY Id';

Ronald :cool:

mmarif4u

Quote:

Originally Posted by 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):

Expand|Select|Wrap|Line Numbers

 $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?

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

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

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

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

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about