Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Creating secondary recordset from primary recordset

Explorer ,
Nov 20, 2006 Nov 20, 2006
Having created the first simple recordset (recordlookup) based on a search text box and displaying it in a dynamic table (only selected columns), I then embedded a post form with a submit in the table.

How do I then create a secondary recordset "recorddetail", based on a single selected row from "recordlookup"?

I attach some code I have tried, but it always returns the recordset, with the variable set at "1", rather than using the ID that I wanted.

Am I getting my syntax right for the variable or do I have to look at this another way?
TOPICS
Server side applications
266
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Explorer , Nov 20, 2006 Nov 20, 2006
Cracked it...

Had to use a URL variable in the link relating to each record....

/recorddetail.php?CONTACTID=<?php echo $row_recordlookup['CONTACTID']; ?>

The detail page can then use a single record recordset from the URL variable, identified by the linked info.

I know this is pretty basic for most but I only just learning!

Thanks for the help
Translate
Explorer ,
Nov 20, 2006 Nov 20, 2006
LATEST
Cracked it...

Had to use a URL variable in the link relating to each record....

/recorddetail.php?CONTACTID=<?php echo $row_recordlookup['CONTACTID']; ?>

The detail page can then use a single record recordset from the URL variable, identified by the linked info.

I know this is pretty basic for most but I only just learning!

Thanks for the help
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines