passing variable in dynamic pages

cldeans

Dear all

I am coding a site that allows details of clients records to be edited from user friendly pages on a website ...

I got some help from meister (bless his cotton socks) who came up with the code below ...

$sql="SELECT client_name FROM client_login";

// $r becomes the result index - basically a pointer to the results of
// your query.
$r = mysql_query($sql);

// The @ supresses errors that might be given by a bad $r (which is then
// no results were returned by the query)

if(@mysql_num_rows($r))
{
while($row = mysql_fetch_array($r))
{
$rec_str .= "<TR>";
{
echo '<CENTER><a href="clients_details.php?client='.
$row['client_name'].'">'.$row['client_name'].'</a>'."</CENTER></tr><br>\n";
}
}

which works perfectly ...only I cant figure out how to save my next file .... here it is listed as 'client_details.php?client='.$row['client_name']

so how do a save a file with a name that this will link to?

Thanks for your time ...

Anon

Hi Cate

<<Cate:
which works perfectly ...only I cant figure out how to save my next file .... here it is listed as 'client_details.php?client='.$row['client_name']

The filename will be "client_details.php". The thigs after the ? are parameters that will be passed to the script "client_details.php".

For example, say you type in the URL:

http://yourserver.com/example.php?firstname=Peter&surname=Jukel

then in your PHP script (which would be called example.php), you could use the following code:

<body>
Your first name is <?php echo $firstname; ?> and your surname is <?php echo $surname; ?>
</body>

It would translate to:

Your first name is Peter and your surname is Jukel.

Notice how the parameters in the URL automatically become variable names in the PHP code.

HTH

Regards

Peter

cldeans

Peter ..

OK, thanks for clearing that up for me .. well, it isnt finding it. I have client_details.php page on the server, whic I can find if I type in the direct URL, but when linking from client_list.php to client_details.php it gives me a 404 error and says it cant find the page ...

suggestions?