Field Collection : Query to get the node id by sending a value of a field collection field value I am having a field collection in a content type called 'client'.
There are,


Client name
Email
Mobile
Address 1
Address 2
Address 3
etc..
as fields. That's it in the client content type.

I am having another content type which basically has a textfield and a dropdown list
The texfield allows to enter a client's name
Once the client's name is filled in the textfield the dropdown list should be filled with  client's addresses
So what I am trying to do here is, programmatically generate the dropdown options by sending the client's name and getting their relevant addresses which was saved using the client content type. 
I'm quite confused with DB structure for field collection values.


Would be great if you can help ASAP 

Thank you.
You could try Field Collection Values

As it says, try 


  To get the values of the individual field items call the entity_load
  function:


&lt;?php
  $node25 = node_load(25);
  $track_1 = entity_load('field_collection_item', array($node25-&gt;field_track[LANGUAGE_NONE][0]['value']));
  $track_2 = entity_load('field_collection_item', array($node25-&gt;field_track[LANGUAGE_NONE][1]['value']));
?&gt;