How to select a record from a table ??

[mikey2230]

Hi, I’m pretty new at this at this and need some advice…

I currently display a table with a “Case Number” and “Name”

What I want to do is be able to select a row from the table and display in a new page all the related details in the database for that case number eg Name, DOB, Address, Status…

This is what I have so far :

---

<?php include 'config.php'; include 'opendb.php'; $result = mysql_query("SELECT * FROM cases"); echo ""; while($row = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; } echo "

Case Number	Surnamename
" . $row['ID'] . "	" . $row['Fname'] . "

"; ?>

---

[PHP_Person]

You should look at the source file of the page to see if it is actually showing the other table rows… there is also mysql_fetch_assoc($result);, but I’m not thinking right now so I don’t know if that will help. ;D

[mikey2230]

Thanks PHP, But each record has 25 bit of data to be shown thats why I want to be able to click on a row and all the relevant data to this, will appear in a new screen !! Like this forum for instance You click on the tread and full data appears on-screen ;D