By matthew on

Hi-

I could have sworn that this was easily possible, but it's not working for me for some reason. Check out our site, and look at the drop down menu's at the top.

Those come from the following code...

<li>Advising
<?php
$sql='SELECT node.title, node.nid FROM node INNER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = 2 AND node.status = 1 ORDER BY node.created DESC';
echo "<ul>";
$result = db_query($sql);
while ($anode = db_fetch_object($result)) {
echo '<li><a href="/node/' . $anode->nid . '">' . $anode->title . '</a></li>';
}
echo "</ul>";
?></li>

...so how can I organize the order of the links in the menu? This is very important for my client, and I thought there was a way to order pages by weight (I can't find it). Does anyone have any ideas on how I could set a specific order for the links in these menus?

Should I edit the database and hand enter a specific node.created entry? Is there a way to weight nodes, and order by node.weight?

--Matthew

Comments

matthew’s picture

matthew commented

I was able to change the SQL to 

$sql='SELECT node.title, node.nid FROM node INNER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = 2 AND node.status = 1 AND node.nid != 68 ORDER BY node.votes ASC';

...which once I inputed a specific vote number for each node worked properly. However, this is not a very viable answer, as people would need to dive into the database to make any changes.

Best,

Matthew
Have a great day™