Custom content type

1 reply [Last post]
jim8
Offline
Last seen: 10 years 38 weeks ago
Joined: 2011-02-07

I'm struggling to figure out how to retrieve data from fields in a custom content type. I'm trying to use SQL with multiple joins, but I can't get it to work .... I think there must be a better way - can you point me anywhere?

Chris Shattuck
Offline
Last seen: 10 weeks 3 days ago
Joined: 2009-08-16
Probably the simplest route

Probably the simplest route is to do a node_load($nid) to fully load the node and pick out what you need from there. I'm sure you've tried it already, but you could also try using the Views module to grab the specific columns you need. You of course could use a number of JOINs to get the content you'd like, and though it's not working for you now, you'd eventually come up with something that did.

Let me know if that points you in the right direction.

Thanks!
Chris

Add to playlist

Add to , or

Add to new playlist:

Add to playlist
This is a member-only feature
But, it's easy to become a member

Add to cart:


Loading...
Contact us

Below are the supported keyboard shortcuts for our video player.

space
Start / stop video
shift
Go to next video
shift
Go to previous video
Increase or decrease player speed by 20%
Skip ahead or go back by 15 seconds
1...9
Jump to a percentage (2 is 20%, for example)
f
Toggle full screen
Videos Pricing More Search
BuildAModule Logo Icon BuildAModule Logo Icon
Become a member!
$29
1 month
$156
6 months
10% off
$276
12 months
20% off
All memberships come with the following:
24 / 7 access to the entire 1800+ video library
An innovative video player with a rolling transcript
Extensive Drupal and cross-platform training
A thorough and thoughtful training style
Progress tracking
Take notes on specific video sections
Intuitive multi-user management
How many users?
user
Go solo with a single user, or give multiple team members access through one account and get discounts by bundling multiple users into a single membership.