Jump to content


Photo

Selecting Data By Name from MySql


  • Please log in to reply
2 replies to this topic

#1 billshackle

billshackle
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 25 April 2006 - 07:22 AM

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

#2 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 25 April 2006 - 08:10 AM

"SELECT * FROM notes_table WHERE client_id = $_GET[id]"

wisewood: proven fact, I am both wise, and wooden.

#3 billshackle

billshackle
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 25 April 2006 - 08:33 AM

thank you - very much appreciated.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users