If I understand what you're asking, just write a simple query.
$picked = ;
$sql = "SELECT * FROM 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 y
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
i
