REEOrder Module (Custom ordering of entries)

Replace: field_id_14, with the field ID of the ordering field you’ve created. Find it in exp_weblog_data

Replace: lesson-order, with the custom field name that you used for the ordering field.

Must be wrapped within exp:weblog:entries.

PREV
{exp:query sql="SELECT url_title AS ut FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id WHERE ewd.field_id_14 < {lesson-order} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' ORDER BY field_id_14 DESC LIMIT 1"}    
<a href="/index.php/exampletemplate/{ut}/">PREVIOUS</a>
{/exp:query}

NEXT
{exp:query sql="SELECT url_title AS ut FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id WHERE ewd.field_id_14 > {lesson-order} AND ewd.weblog_id = {weblog_id} AND STATUS = 'open' ORDER BY field_id_14 ASC LIMIT 1"}
<a href="/index.php/exampletemplate/{ut}/">NEXT</a>
{/exp:query}

Let me know how it goes.

MySQL ERROR:

Error Number: 1064

Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '

0002
AND ewd.weblog_id = 2 AND STATUS = 'featured' ORDER BY field_id_46 ' at line 1

Query: SELECT url_title AS ut FROM exp_weblog_titles ewt INNER JOIN exp_weblog_data ewd ON ewd.entry_id = ewt.entry_id WHERE ewd.field_id_46 <

0002
AND ewd.weblog_id = 2 AND STATUS = 'featured' ORDER BY field_id_46 DESC LIMIT 1

{exp:weblog:entries weblog="features" orderby="order_features"  dynamic="off" sort="asc" disable="member_data|pagination|trackbacks" status="open|featured|first"}
                                <li><a href="http://{title_permalink=">{title}</a></li>
{/exp:weblog:entries}

{exp:weblog:entries weblog="features"orderby="order_features"  sort="asc"  disable="member_data|trackbacks" status="open|featured|first"}
                                <h3>{title}</h3>
                                {features_short}
                                {features_full}
{exp:weblog:prev_entry weblog="features" orderby="order_features"   sort="asc"  status="open|featured"}    
                                <a href="http://{path=">previous ‹ {prev_entry->title}</a>
{/exp:weblog:prev_entry}
{exp:weblog:next_entry weblog="features" orderby="order_features"  sort="asc" status="open|featured"}    
                                <a href=”http://{path=">next › {next_entry->title}</a>
{/exp:weblog:next_entry}


                            </div>
{/exp:weblog:entries}

function create_custom_field_menu($weblog_id)
    {
        global $DB, $DSP;
        
        // get field_group for this weblog
        $field_group_query = $DB->query("SELECT field_group 
                                        FROM exp_weblogs 
                                        WHERE weblog_id = '$weblog_id'");
        
        $field_group_id = $field_group_query->row['field_group'];
        
        $gypsy_enabled = $DB->query("SELECT count(*) AS count FROM exp_extensions WHERE class = 'Gypsy' AND enabled ='y'");
        
        if($gypsy_enabled->num_rows > 0) 
        {
            // use group_id to get custom field_id, or see if it's a gypsy field
            $custom_field_id_query = $DB->query("SELECT field_id, field_name, field_label, group_id
                                                FROM exp_weblog_fields 
                                                WHERE group_id = '$field_group_id'
                                                OR gypsy_weblogs LIKE '%$weblog_id%' ORDER BY field_order ASC");
        }
        else
        {
            // use group_id to get custom field_id
            $custom_field_id_query = $DB->query("SELECT field_id, field_name, field_label, group_id
                                                FROM exp_weblog_fields 
                                                WHERE group_id = '$field_group_id' ORDER BY field_order ASC");
        } 
        
        $custom_field_id = $DB->query("SELECT * FROM exp_reeorder_prefs WHERE weblog_id = '$weblog_id'");
        if ($custom_field_id->num_rows == 0)
        {
            $cf_id = '';
        } else {
            $cf_id = $custom_field_id->row['field_id'];
        }
        
        $dropdown_menu = $DSP->input_select_option(0, '---');
        foreach ($custom_field_id_query->result as $row) {
            
            if ($row['field_id'] == $cf_id) {
                $dropdown_menu .= $DSP->input_select_option($row['field_id'], '('.$row['field_id'].') ' .$row['field_name'], 'y');
            } else {
                $dropdown_menu .= $DSP->input_select_option($row['field_id'], '('.$row['field_id'].') ' .$row['field_name']);
            }
            
        }
        
        return $dropdown_menu;
    }