Make dynamic links from a php page.

kamleshwaran

Hi there,

I have a whole list of records which i got from my MYSQL table on a PHP page. Now the problem is, how do I link those results to another page for viewing in detail.

eg., This is the display on the php page

Sno Proj Name Proj ID.

1 alpha proj AP33
2 Beta Proj 3333
3 Gamma 3343

Now I want to link "ALpha Proj" to a view page which will run a query and display the details abt it.

How do I go about this...some body please help me...I've almost gone bonkers..
😕

Thanks in advance.

-Kamleshwaran.G

Kudose

$q = mysql_query("SELECT projID FROM table") or die(mysql_error());
$r = mysql_num_rows($q);
for($i=0; $i<=$r; $i++){
$f = mysql_fetch_assoc($q);
$projID = $f['projID'];
echo "<a href='show.php?projID=$projID'>$projID</a>"; 
}

Kudose

$projID = $_GET['projID'];
$q = mysql_query("SELECT * FROM table WHERE projID='$projID'") or die(mysql_error());
extract(mysql_fetch_array($q));

echo "Sno: ".$sno;
echo "<br>Proj Name: ".$projName;
echo "<br>Proj ID: ".$projID;

echo "<input type='button' value='<-Back' onClick'history.back()'>";

Hope that helps.