displaying records from two recordsets on 1 page?

[Php-or-Not-2Php]

Hi.All first of, im new here but should be hanging around for a while as ive just started to get into Mysql & PHP..

Im building a Dynamic Website, which uses 1 Database and a handful of tables with related data...

Ive built a Page that has a dynamic menu which allows the user to select which record he wants to view.. when the form is submitted the Record_ID is passed to the next page via the URL.. everything is Fine .. but here comes my headache.. seeing as im very new to PHP.. I want to display some data from a 2nd Table at the bottom of the page, this is related data to the first table, The first Table contains an ID field pointing to the record in the 2nd table..

now if i used the form on the 1st page to pass both these id`s then everything would be ok.. but for some reason i dont seam to be able to post the 2nd ID correctly as it just draws out the 1st record in the 2nd table..

Is this the best way to do this? or should i just use some kind of SQL select statement to pull the ID from the 1st table to show the correct record from the 2nd table?

I hope this isnt too Confusing and you can follow what i mean...

paul.

[tomhath]

Don't bother with the database on the second page yet. Get the first page working and just display the IDs on the second page. Once that's working you can focus on the SQL.

If you try to do too many things at once you don't know where it went wrong.

[Php-or-Not-2Php]

Its not a question of where its going wrong, the 1st page is working fine.. anyhow after a little bit of playing around ive managed to get the desired result.. Not sure if its the best way to do it or not , but it works..

Basically i took the ID from the First Table that pointed to the record in the 2nd table and stored this in a variable, then used the variable in the Select Statement for the 2nd table..

Works like Clockwork...

😃

Happy Bunny!!

[Roger_Ramjet]

So mark the thread as RESOLVED using the link provided for that purpose.