Joomla! Documentation™

The "API15" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Description

Description

Syntax

genericordering($sql, $chop= '30')

Parameter Name	Default Value	Description
$sql		SQL with ordering As value and 'name field' AS text
$chop	'30'	The length of the truncated headline

Defined in

libraries/joomla/html/html/list.php

Importing

jimport( 'joomla.html.html.list' );

Source Body

function genericordering( $sql, $chop = '30' )
{
        $db =& JFactory::getDBO();
        $order = array();
        $db->setQuery( $sql );
        if (!($orders = $db->loadObjectList())) {
                if ($db->getErrorNum()) {
                        echo $db->stderr();
                        return false;
                } else {
                        $order[] = JHTML::_('select.option',  1, JText::_( 'first' ) );
                        return $order;
                }
        }
        $order[] = JHTML::_('select.option',  0, '0 '. JText::_( 'first' ) );
        for ($i=0, $n=count( $orders ); $i < $n; $i++) {

                if (JString::strlen($orders[$i]->text) > $chop) {
                        $text = JString::substr($orders[$i]->text,0,$chop)."...";
                } else {
                        $text = $orders[$i]->text;
                }

                $order[] = JHTML::_('select.option',  $orders[$i]->value, $orders[$i]->value.' ('.$text.')' );
        }
        $order[] = JHTML::_('select.option',  $orders[$i-1]->value+1, ($orders[$i-1]->value+1).' '. JText::_( 'last' ) );

        return $order;
}

Examples

<CodeExamplesForm />