Passing multiple URL Parameters

[Heleen]

Hi there,
(Xcuse me for my bad English, I come from the Netherlands :queasy: )

Does anyone know if it is possible to pass multiple URL Parameters?
I mean, when you make master/detailpages in Dreamweaver you can pass the ID to the detailpage.
Is it possible to pass instead of the ID for example a last name and a city, so you get a list of all the people who live in the same city and share the same last name on the detailpage.

And what do I have to change in this code to do that?

Masterpage:
<a href="Detail.php?Lastname=<?php echo $row_rs_Test['Lastname']; ?>">
<?php echo $row_rs_Test['Lastname']; ?>

Detailpage:
<?php
$colname_rs_Detail = "1";
if (isset($GET['Lastname'])) {
$colname_rs_Detail = (get_magic_quotes_gpc()) ? $GET['Lastname'] : addslashes($_GET['Lastname']);
}
mysql_select_db($database_ConnTryout, $ConnTryout);
$query_rs_Detail = sprintf("SELECT * FROM People
WHERE Lastname = '%s'", $colname_rs_Detail);
$rs_Detail = mysql_query($query_rs_Detail, $ConnTryout)
or die(mysql_error());
$row_rs_Detail = mysql_fetch_assoc($rs_Detail);
$totalRows_rs_Detail = mysql_num_rows($rs_Detail);
?>

I hope you guys are smarter than the Dutch programmers 🙂

[pohopo]

I think this is what you want...

<a href="Detail.php?Lastname=<?php echo $row_rs_Test['Lastname']; ?>&City=<?php echo $row_rs_Test['City']; ?>"

You then use $_GET to grab LastName and City

[Heleen]

Thanks for your answer.
I tried it, but unfortunately the Detailpage remains empty.
Do you have an idea of what is wrong there?

<?php
$colname_rs_Detail = "1";
if (isset($GET['Lastname , City'])) {
$colname_rs_Detail = (get_magic_quotes_gpc()) ? $GET['Lastname , City'] : addslashes($_GET['Lastname , City']);
}
mysql_select_db($database_ConnTryout, $ConnTryout);
$query_rs_Detail = sprintf("SELECT * FROM People
WHERE Lastname , City = '%s'", $colname_rs_Detail);
$rs_Detail = mysql_query($query_rs_Detail, $ConnTryout)
or die(mysql_error());
$row_rs_Detail = mysql_fetch_assoc($rs_Detail);
$totalRows_rs_Detail = mysql_num_rows($rs_Detail);
?>