[development] node_load using cck fields

Steve Edwards killshot91 at gmail.com
Tue Mar 22 16:47:03 UTC 2011

Here is the magic incantation:



On Mar 22, 2011, at 9:45 AM, larry at garfieldtech.com wrote:

> You can only load nodes in D6 individually by ID.  However, you can run raw SQL queries to find nodes meeting certain criteria, then run node_load() on those IDs.  I forget the functions off hand but there is a magic incantation to get the right field column info and build a query string yourself.
> That said, if you're going to be displaying the node(s) then just use Views.  It will take much less time and be much more stable, and offer better theming options.
> In Drupal 7, you'd either use Views or the new EntityFieldQuery.
> --Larry Garfield
> On 3/22/11 11:40 AM, Lluís Forns wrote:
>> I want to load a node using cck fields instead of nid or core fields.
>> Is there a "no-sql" way of doing this? I have read that maybe I could
>> achieve it using views, but I think it would be an overkill.
>> What I want to achieve is something like this:
>>     $inscripcio = node_load(array(
>>         'type' =>  'inscripcio',
>>         'field_alumne' =>  $nid_alumne,
>>         'field_convocatoria' =>  $nid_convocatoria,
>>     ));
>> any hint?
>> If I could get which tables use a cck type and how to join them, maybe
>> I could code a "generic" way to do this, so if cck-type is changed,
>> there is no problem.

More information about the development mailing list