View Single Post
  #6 (permalink)  
Old 08-20-2007, 10:32 AM
brandrocker brandrocker is offline
WebProWorld Member
 

Join Date: Dec 2006
Location: India
Posts: 49
brandrocker RepRank 0
Default Re: MySQL Multiple Select Question

Still not very clear, if I'm not mistaken.
Do you mean?

You have two tables - one for person ( containing individual details, eid is PK)) and the other for comments etc (eid is FK)

Now you want to select comments made by some persons (say comments made by eid 100, 103, 104, 117, 119, 122)

If that be the case try 'OR' in your WHERE CLAUSE (provided you know your eid's already).

Otherwise, please let me know your table structures and exactly what data do you want to select.
Reply With Quote