search results displayed as hyperlink

Anon

I have written a LandTax info Search page.
Using MySQL for my database. The search usually returns 20 - 600 results. Each of the records has 25 fields to be displayed.
I need to display the results as Hyperlinks, using the "Name" field as the hyperlink text, so that when a user clicks the hyperlink, it displays 25 fields of info, rather than display all 25 fields for each result on the same page. (i.e. generating a very large page that the user has to scroll through)

Anon

do a query where you get only the uid and name

<?
//querying function done

$linktext="<a href=\"results.php?uid=$uid\">$name</a>";
?>

<?echo $linktext;?>

The results.php page will take the uid argument that you passed in the url and then you can do another query.

<?
$select="select * FROM table where uid=$uid";
$results=,yql_query($select);
// extraction function below
?>
?>

Anon

should be $results=mysql_query($select);

Anon

Alternatively to what suggested, when searching you could load all the 25 fields in an array.

Next, you display what you called your Name field and link it using a form to a full-result page.

Next, you build a form and pass all the data contained in the array to the full-resoult page that actually dislpays the 25 fields.

This, might result a bit longer to develop, but could give you the advantage of providing the results without displaying the UID anywhere in the HTML. If this matters for you as much as it matters for me. Plus you'll have all your data using one querry and let the database rest a bit.

Well, given you already have all 25 fields, you could also add some fancy appropriate icon next to the Name (hypelink) that tells some more of the data in the other fields that will be displayed (a flag for a country for instance ...)

If you go for this, do consider to LIMIT the select query to something reasonable for your pourpose when dislaying the Names, in my opinon, a list of 600 names doesn't really help readers unless there is a specific request for that (to print the results for example).

Vin

Anon

That sounds like the road to victory. Although it will be more complicated, if I were the user searching I'd prefer to see it that way, so... I clock in and goto work.
Thanx for the tips, and just so I dont feel useless, here is a cool tidbit for showing the total number of records found in a search query->

$numrow = mysql_num_rows($result);
echo "$numrow Records found <br>\n";

not much to it but its useful (^_⁾