Sort by: Option for VbGarage

[BamaStangGuy]

I am wanting to let my users sort through the cars by Car Year, Car Model, Username, and a few other options

Right now it sorts by username only and users have no other way to find a car.

I'm not looking for the code handed to me I am just looking for th ebest place to start.

PHP Code:

// ############################################################################
// ############################# LIST ALL GARAGES #############################
// ############################################################################

if ($_REQUEST['do'] == 'list')
{
    globalize($_REQUEST, array('pagenumber' => INT, 'perpage' => INT));
    
    $perpage = intval($perpage);

    if ($perpage == 0 or $perpage > 200) 
    {
        $perpage = 25;
    }

    if (intval($pagenumber) == 0) 
    {
        $pagenumber = 1;
    }

    $limitlower = ($pagenumber - 1) * $perpage + 1;
    $limitupper = ($pagenumber) * $perpage;
    $counter = 0;

    $garagecount = $DB_site->query_first("
        SELECT COUNT(*) AS garages FROM " . TABLE_PREFIX . "vbgarage_users
    ");

    $numberpages = $garagecount['garages'] / $perpage;
    $numberpages = ceil($numberpages);    
    
    if (!isset($pagenumber) or ($pagenumber < 1) or ($pagenumber > $numberpages))
    $pagenumber = 1;

    $pos = ($pagenumber - 1) * $perpage;

    $result_list = $DB_site->query("
        SELECT * FROM " . TABLE_PREFIX . "vbgarage_users ORDER BY userid ASC LIMIT $pos,$perpage
    ");
    
    $counter = 0;
    $count = 0;

    while ($list = $DB_site->fetch_Array($result_list) AND $counter++ < $perpage)
    {
        $count++;
        $list['lastactivity'] = vbdate($vboptions['dateformat'],$list['lastactivity'],true);

        $user = fetch_userinfo($list[userid]);

        eval('$listbits .= "' . fetch_template('vbgarage_listbits') . '";');
    }
    
    $result_latest = $DB_site->query("
        SELECT * FROM " . TABLE_PREFIX . "vbgarage_images ORDER BY vbgarageid DESC LIMIT 5
    ");
    
    while ($latest = $DB_site->fetch_Array($result_latest))
    {
        eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";');
    }

    $pagenav = construct_page_nav($garagecount[garages],"vbgarage.php?$session[sessionurl]do=$_REQUEST[do]&perpage=$perpage");

    $navbits = construct_navbits(array('' => 'vBGarage'));
    eval('$navbar = "' . fetch_template('navbar') . '";');
    
    eval('print_output("' . fetch_template('vbgarage_listgarage') . '");');
} 


Thats a whole lot of code for me to digest at once. I'm not to familiar with PHP just learning it.

I would a start to rearrange that to allow users to sort by their choice?

Thats

[BamaStangGuy]

Also how does vbgarage handle attachments? I cant find anything in vbgarage and it requires three files. What file and what part does it use to control attachments.

[cinq]

It doesn't control attachments.
Uploaded images are stored as blobs in the database.