Help linking Results page to Details page

Hi
I'm using CS5 and Dataassist2, I'm creating a `pet classifieds` and need some help. I have set up a search and results page which work fine, but now wish too link the results page too a `Details page`..So from the results page the customer can click on the photo or name on the search page and be taken too the Details page where all the details for that animal are shown. Thanks in advance for any help guys

Regards Karl

on the results page, create a link to the details page that passes the Primary Key ID column as a querystring:

<a href="detail.php?id=<?php echo $row_YourRecordset['IDColumn']; ?>">detail</a>

On the detail page, create a recordset.

In the filtering section, select the ID column

Set the Type to Querystring variable and enter "id" without quotes for the name.

On your details page create a recordset with the data you want to display. If you click on test in the recordset it should display all the records.

Go to the simple display and in the "filter" dropdown select the unique identifier (usually ID).

Make sure URL parameter is selected. This should auto populate the box next to url parameter with "ID". Please note that I'm just guessing "ID" it's what ever you called the auto increment column of your database. Click OK and close this dialog box

Bind whatever fields you need to the page so it displays your "details".

Go to your results page and highlight some text in the row (or create a "Details" link). Link this to the details page.

Now the tricky bit. Suppose this link is "details.php" you need to add "?id=" and then bind the ID from the recordset on that page so it will look like:

details.phpID=<?php echo $row_rsRecordset['ID']; ?>

Now, if you display the results page in your browser and click on the link it should go to the details page taking the url parameter of the record with it. This will then call the correct record and display it on the page.

HTH

Edit: Ooops, looks like Jason beat me to it :)

No worries John, It's always appreciated when you guys step in too.

1st thanks to you both for a speedy reply too my problem, i have tried what you have said but its not worked for me. I have added the code so you can take a look

<td align="center"><a href="details_page.php?id=<?php echo $row_rs_details[`id`]; ?>">Details</a></td>

When i look at the code the [`id`] part is not turning red which may be the problem

regards Karl

it's because you are using the tick character "`" instead of the apostrophe or single quote chacter "'"


change your code:

<td align="center"><a href="details_page.php?id=<?php echo $row_rs_details[`id`]; ?>">Details</a></td>

to:

<td align="center"><a href="details_page.php?id=<?php echo $row_rs_details['id']; ?>">Details</a></td>

Working like a dream, thankyou very much for your help .

Regards Karl

Nice, good to hear it's working.

Would this be the same if i was getting info from 2 tables which are INNER JOINED using the 'id' value?

yes, the tick character is only valid as a surrounding character for a table name in MySQL. In PHP, it is not valid to use the tick, you need to use the single quote. It is a difference in the two languages.