Display table according to the search term

ghjk

In my application i have a table for retrieving database values. and also i have a search function. In page load in first time i want to display normal table and when searching i want to display only specific values according to the search term. Could you please tell me how can i do that?

satas

Quote:

Originally Posted by ghjk

In my application i have a table for retrieving database values. and also i have a search function. In page load in first time i want to display normal table and when searching i want to display only specific values according to the search term. Could you please tell me how can i do that?

Try google for

Expand|Select|Wrap|Line Numbers

php mysql

to find out basics. Or try to explain your problem more detailed.

ghjk

Quote:

Originally Posted by satas

Try google for

Expand|Select|Wrap|Line Numbers

php mysql

to find out basics. Or try to explain your problem more detailed.

I'm developing web application using php. one of my page hase 4 text boxes, search function and table.(teble displays database values). In first time user log in to this page he should display all values in the table. But if he search some value then should only display details accoring to that serch term.

EX. first time table has 5 record(default database values). Then he search by country(Search By: xxxx). So it should display 2 records those are in that country.

I want to load the value to same table in both situation.

satas

Okay, but it is a quite typical application described in the most of tutorials.
All you need to do is to execute 2 queries and display the results:

Expand|Select|Wrap|Line Numbers

SELECT * FROM `table_name`;

and

Expand|Select|Wrap|Line Numbers

SELECT * FROM `table_name` WHERE `country`='country_name';

Display table according to the search term

re: Display table according to the search term

re: Display table according to the search term

re: Display table according to the search term

/bytes/development

/bytes/it

/bytes/about