how to retrieve results from Database on specific field

[swcobra]

can anyone help me as how to retrieve information from the database on a specific field. the page on which i am working is here
http://apsi.in/member/directory.htm
i would appreciate if anyone can give me the code in php, by clicking any one of the state name on the right side, i would like to get the data on that state only.

for example click on "Andhra Pradesh", you get the result, but the result which you can see is the complete data from the database, i would like to get only from that particular state.

even in the search option, i am able to get, but from the html form, as you can see the page, i would like it to be from the page itself.

please someone help me for this

Krishna

[Chexx]

I dont know how you have things setup, but maybe the database fields themselves need to be reworked?

Try setting the primary key in the DB as an auto increment ID, the Dr. name after, etc.

Then try:
have your regular sql statements then..

$stateid = $row['state_id']
$statename = $row['stats_name']
<a href=http://site.com/page?state=<? echo $stateid; ?>><? echo $statename; ?></a>

[Thanol]

Hopefully in your database, you have a column that lists the State of that any given entry belongs to. If you did that then all you need to do is add a WHERE statement to your MySQL query.

example:

$state = $_GET['state'];

$result = mysql_query("SELECT * FROM $database_table WHERE state='$state'") or die(mysql_error());
 
$row = mysql_fetch_array( $result );

If your database isn't set up so that there is a column that attaches each entry to a state, I suggest that you edit the database so that it does.

[helloworld]

<a href= "http://site.com?STATE-ID-HERE">STATE NAME HERE</a> 

$stateid = $_SERVER['QUERY_STRING'];
$result = mysql_query("SELECT stateinfo FROM states WHERE stateid = '$stateid'") or die(mysql_error());