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 Link to comment https://forums.phpfreaks.com/topic/8348-selecting-data-by-name-from-mysql/ 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] Link to comment https://forums.phpfreaks.com/topic/8348-selecting-data-by-name-from-mysql/#findComment-30428 Share on other sites More sharing options...
billshackle Posted April 25, 2006 Author Share Posted April 25, 2006 thank you - very much appreciated. Link to comment https://forums.phpfreaks.com/topic/8348-selecting-data-by-name-from-mysql/#findComment-30436 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.