returning a link for each db result

[Anon]

I have a mysql database that contains various trips and a php script that returns a table of trip results depending on what the user searches for. In this table I would like a hyperlink for each search result that takes the user to another page that gives more details about that particular trip. I already have the table set up in the database but can't figure out how I could have one script that can return info for each trip. Any ideas?

[reagent]

if each of your trips have a unique identifier, call it with

/tripdetail.php?tripId=324

hth
p.

[Anon]

Instead of using a # for each result, could I have a variable that identifies what ID# it is?

[reagent]

I'm not sure what you mean. I provided it as an example of how to construct a link, but you would want to dynamically build a list of links from the db.

let's say you executed your query and are processing a result set

<? while ($row = mysql_fetch_array($result)) { ?>
<a href="/your.script.php?tripId=<?= $row['trip_id_no'] ?>"><?= $row['trip_name_tx'] ?></a>
<? } ?>

hope you can make some sense of that 😉
p.