how order by weigh in drupal sql statement

i have the following drupal sql. Wondering how would i order the following be weight

SELECT node.nid FROM node node  LEFT JOIN content_type_videoclip videoclip ON node.vid = videoclip.vid WHERE node.type in ('videoclip')
frosty1Asked:
Who is Participating?
 
junipllcConnect With a Mentor Commented:
The weight column you're looking for should be in the "menu_links" table, field name is "weight". It doesn't make 100% sense, I know, but I know when I've set up content using the Book content type that's where it was stored.
0
 
JuamezCommented:
If you mean a simple SQL addendum, then you can add this to your query: ORDER BY <name of row> [ascending | descending (optional)]

By what row do you want to order the query exactly?
0
 
frosty1Author Commented:
yeah, i don't know where the weight col is in drupal. Where is this stored
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
JuamezCommented:
I don't know what you mean by weight. Is it a collection of criteria like filesize, video dimensions, ... ?
0
 
frosty1Author Commented:
in drupal, when you add an item to the menu you get give it a weight. it's basically says where in the menu it should go. So i want to use this value to order my select statement
0
 
JuamezCommented:
Oh I see! Maybe you can look in the code of the page that inserts the data into the database, look for the table and column where it puts the new value. I don't have drupal here myself now, so I can't look.
0
 
junipllcCommented:
Were you able to find the weight you needed in that column?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.