Master Details Page

sonny100

Hi guys,

At the moment, I have a search page that returns results in a table. The coding for which is:

echo "<TABLE BORDER=1>";
for ($i=0; $i<$num_rows; $i++)
{
$array=mysql_fetch_array($result);
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>", $array['firstname'], $array['email'], $array['location'], $array['age']);
}
echo "</TABLE>";

This returns my results in a neat little table.

The next step is to link the first column in each row to a details page on that particular row. I know that I need to pass the variable via the URL but I have two questions...

1) I can't seem to add a hyperlink to the first column (in this case $array['firstname']. How do I do this with the current code?

2) Once I have set the hyperlink to go to the details page, how can I be sure that the row that is clicked on will be the one that is passed to the next page? I'm thinking that it may just pass the first value returned by the original query if that makes sense.

Any help would be greatly appreciated!

Thanks

coldwerturkey

thats a terrible method of printing your query. Looking at it I don't believe it works at all, it's just printing the same query results.

I highly recommend using something more traditional like,

echo "<TABLE BORDER=1>"; 
$query = "SELECT * FROM table";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
	echo "
		<TR>
			<TD><a href='?id={$row['id']}'>{$array['firstname']}</a></TD>
			<TD>{$row['email']}</TD>
			<TD>{$row['location']}</TD>
			<TD>{$row['age']}</TD>
		</TR>";
}
echo "</TABLE>";

sonny100;10911209 wrote:
1) I can't seem to add a hyperlink to the first column (in this case $array['firstname']. How do I do this with the current code?

just with your standard link tags, see above.

sonny100;10911209 wrote:
2) Once I have set the hyperlink to go to the details page, how can I be sure that the row that is clicked on will be the one that is passed to the next page? I'm thinking that it may just pass the first value returned by the original query if that makes sense.

find the id via the url,
$id = intval($_GET['id']);

then (granted you are using some form of primary key like id) just put it in your query
"SELECT * FROM table WHERE id = {$id}"