If I understand what you're asking, just write a simple query. $picked = <your_selection>; $sql = "SELECT * FROM <your_table> WHERE cat = '$picked'"; $result = mssql_query($sql) or die ("My_Error_Message"); $row = mssql_fetch_assoc($result); $id = $row['id']; $name = $row['name']; $cat = $row['cat']; echo $id; // shows your record id on the screen. On 7/5/07, elk dolk <elkdolk@xxxxxxxxx> wrote:
Hi all, My DB has the following columns: id, name ,cat. I want to select a cat i.e. cat=zzz when the query is finished I should see a specific record within this cat which is defined by id, like id=yyy Any idea how to do this? Is there a function or something like record pointer in MySQL ? cheers --------------------------------- Shape Yahoo! in your own image. Join our Network Research Panel today!