creating a result page from a result page...

RichardO

(developing using DWmx6.1, php on mysqlserver)

I have a contact management database (4500 records) where each record contains many columns = a lot of data to look at in one go.

So... I have created a search page to look for "Company" or "Name" which then returns a recordset with a primary ID number and a summary of 5 other fields.

This recordset is then displayed on a results page in a dynamic repeating table which just shows simple record lines.

My aim is to then be able to go from the results page to another detailed result page based on the ID of a specific selected record.

I understand how to generate the recordset from a text box but cannot find out how to create a recordset from a dynamic repeating table.

Does anyone know how to do this please?

bogu

U should have a page where u extract the details of a contact, here you would need to know wich contact, so your link should be something like this:

details.php?id=contact_id

contact_id - would be the uniq ID for that contact

RichardO

Awww - I'm not sure what you mean..

do you have to create a hyperlink on the dynamic table results?

RichardO

I guess I'm not making myself clear.

what I'm trying to do is create a filtered recordset, based on a primary filter recordset.

So, the first recordset would produce a dynamic table results page, showing just a few columns but then, you would be able to select one line record which would create another recordset and another result page for more detail.

So for instance, the first recordset called 'searchlookup' would be something like;

SELECT CONTACTID, COMPANY, FULLNAME
FROM contacts
WHERE CONTACT LIKE '%colname%' OR COMPANY LIKE '%colname%'

$HTTP_POST_VARS['searchbox']

The seond recordset should be something like

SELECT *
FROM contacts
WHERE CONTACTID = 'searchlookup.CONTACTID'

But all i get at the moment is a result from the last row in the primary recordset as it hasn't recognised which row was selected in the first result dynamic table.

Does this make more sense?