billshackle Posted April 25, 2006 Share Posted April 25, 2006 Ok so here is my issue. I have two tables on one database. One stores my general contact info such as name, address etc etc. I have another table which stores notes on each of the names in the database. When i submit a note to the database it records the id number of the page it has come from. What i want to do is output these notes on the same page as the contact so e.g. the contact's page will be www.pageurl.com/contacts.php?id=2343 and i want to pull every note submitted with 2343 out of my notes table. Is there any easy way to do this?Thanks in advance. Cheers Quote Link to comment Share on other sites More sharing options...
wisewood Posted April 25, 2006 Share Posted April 25, 2006 [code]"SELECT * FROM notes_table WHERE client_id = $_GET[id]"[/code] Quote Link to comment Share on other sites More sharing options...
billshackle Posted April 25, 2006 Author Share Posted April 25, 2006 thank you - very much appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.