Using a link to query a database

makemehatephp

i currently have a table with 14 columns. i would like to display just a few of the values in an html table on a page, and then have a link appear in the last column of the html table, which, if clicked, would display all of the values for a particular record.

the code i have so far is:

<?php

MYSQL_CONNECT
@mysql_select_db("");

$data = mysql_query("SELECT id, firstname, lastname, firm FROM attendees order by id");

print "<div class=\"table\">";
print "<table border=1>";
print "<tr><td>ID</td><td>First Name</td><td>Last Name</td><td>Firm</td><td>Details</td></tr>\n";

while ($myrow = mysql_fetch_array($data)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td><a href=\"%s\">View Details</a></td></tr>\n", $myrow[id], $myrow[firstname], $myrow[lastname], $myrow[firm] );
}

print "</table></div>";
?>

you can see where the link should appear, represented by

<a href=\"%s\">View Details</a>

the values are obtained via:

$myrow[id], $myrow[firstname], $myrow[lastname], $myrow[firm], XXXXX );

i've placed XXXXX where i believe the query should go, but i am not sure how to code it.

i would guess that it would look something like:

$detail = mysql_query("SELECT id, firstname, lastname, firm, street, city, postalcode, country, phone, fax, email, cle, works FROM attendees where .......?? ");

any help would be appreciated.

vallette

Build the link so passes the record id back and use it in the where clause of your query.

<a href="whatever.php?recid=xx">View detail</a>

SELECT id, firstname, lastname, firm, street, city, postalcode, country, phone, fax, email, cle, works FROM attendees where id=$recid

roomyz

sorry if this sounds stupid.

how do you make the page accept the link??

here is my code for making the links
after querying

echo "<table> ";
while ($R = ibase_fetch_row($Q)) {
	$i++;
	array_push($bookcodes, $R[3]);
	echo " 
	<tr>
	<td>$i &nbsp;</td>
	<td valign=\"top\"> </a>
	<td valign=\"top\"><input type=\"checkbox\" name=\"$R[0]\" value=\"\"></td>
	<td valign=\"top\"><a href\"process.php?temp=$R[3]\"><strong>$R[1]</strong> / $R[2]</a></td>
	<tr> ";			
}
echo " </table> <br>";

where $R[3] is the output from the database. is this correct?? When i hover my mouse pointer over the links no address appears in the statusbar although the text is highlighted like a link. and how do i accept the output so that my form processes it?

please give help for a beginner......