Sorting in PHP

[dcuellar]

I'm trying to find a way to organize my shopping cart alphabetically.

http://www.unifiedchamp.com/ucforum/cartplog.php?do=viewcategory&cartplogcatid=1

 

Here is a code within the php script that I noticed had ORDER in it.

 

$cartplog_category_infos = $db->query_read("SELECT catid, title, products
	FROM " . TABLE_PREFIX . "cartplog_categories
	ORDER BY displayorder
");

$cartplog['category_list'] = '';

while ($cartplog_category_info = $db->fetch_array($cartplog_category_infos))
{
	$cartplog['category_catid'] = intval($cartplog_category_info['catid']);
	$cartplog['category_products'] = intval($cartplog_category_info['products']);
	$cartplog['category_title'] = htmlspecialchars_uni($cartplog_category_info['title']);

	eval('$cartplog[\'category_list\'] .= "' . fetch_template('cartplog_category_list') . '";');
}

 

Can this be done?

[valtido]

Not sure what you are asking for or what you like to do but here is a somthing maybe it might help.

change

ORDER BY displayorder

TO

ORDER BY title ASC

to order it by title (a-z)

OR

ORDER BY title DESC

to order it by title (z-a).

 

 

If this dont help try and look up for MYSQL ORDER BY on google loool and try and make sense of that

PS. oh n remember if you want to change it by product change "title" to "products"

 

PS

 

[dcuellar]

Can I make it an option for the user to choose?

[dcuellar]

I just tried it and it did not work...

 

I've included the full PHP script above if you don't mind taking a look at it.

 

I basically want to organize by titles, not by ID numbers. For example, instead of 1, I want it to be sorted by F for Floyd Maywe...

 

Any help with this would be greatly appreciated.

[dcuellar]

Ok. by putting the code above in that code I arranged something else...so obviously that is not where I need to place it.

 

Let me keep on looking.

[dcuellar]

I imagine it has to be somewhere within this:

 

$cartplog['category_list'] = '';

while ($cartplog_category_info = $db->fetch_array($cartplog_category_infos))
{
	$cartplog['category_catid'] = intval($cartplog_category_info['catid']);
	$cartplog['category_products'] = intval($cartplog_category_info['products']);
	$cartplog['category_title'] = htmlspecialchars_uni($cartplog_category_info['title']);

	eval('$cartplog[\'category_list\'] .= "' . fetch_template('cartplog_category_list') . '";');
}

$db->free_result($cartplog_category_infos);

 

But I don't see where.

[valtido]

I wasnt having a go at you mate just said that so i was clear

find this file.on your server.

 

cartplog.php

 

and look for "ORDER BY catid"

 

if you find that then change it to "ORDER BY title"

 

hope it helps

 

also on cartplog.php look for include() function coz they may have included other pages.

[dcuellar]

lol of course not. I appreciate your help...alot!!

[dcuellar]

There was nothing on the cartplog.php

 

Could it be within a template?

[dcuellar]

I did a search within templates for that code and found nothing.

 

I'm thinking, could it be arranged by date or order it was created? I don't know if that's possible or what code I'd be looking for.

[valtido]

find a function on your script

 

function fetch_template($something)
{
      CODES here 
SELECT blablabla FROM bla bla bla

}

 

find that and post a sample loool there should be a SELECT within the function

 

[dcuellar]

This whole time I thought I had my whole script up there...lol

 

Here it is. there are several instances of SELECT. I'm just not sure which will affect which.

 

Code deleted.

[valtido]

ok i think i found it not sure thought if not just check and let me know i have another look

 

replace

if ($_REQUEST['do'] == 'viewcategory')
{
$vbulletin->input->clean_array_gpc('r', array(
	'cartplogcatid' => TYPE_UINT,
));
$cartplog['categoryid'] = $vbulletin->GPC['cartplogcatid'];

$cartplog_product_infos = $db->query_read("SELECT productid, thumb, title, price
	FROM " . TABLE_PREFIX . "cartplog_products
	WHERE catid = " . intval($cartplog['categoryid']) . " 

 

 

with

if ($_REQUEST['do'] == 'viewcategory')
{
$vbulletin->input->clean_array_gpc('r', array(
	'cartplogcatid' => TYPE_UINT,
));
$cartplog['categoryid'] = $vbulletin->GPC['cartplogcatid'];

$cartplog_product_infos = $db->query_read("SELECT productid, thumb, title, price
	FROM " . TABLE_PREFIX . "cartplog_products
	WHERE catid = " . intval($cartplog['categoryid']) . " ORDER BY title ASC

 

Just add ORDER BY title ASC at the end that is the difference

[valtido]

it looks like its working now loool

[dcuellar]

Man!!!

 

That worked!!

 

Thanks a bunch!!!

 

Is there any way to allow the option for the user to select whether they want to see it A-Z or Z-A?

 

 

[valtido]

hahaa ye there is but it has a lot more code you will have to put in one sec i might post somin for u

[dcuellar]

cool.

 

Is there anything I can do for you? Do you like Boxing? Put a link of your website on our webpage?

 

You name it.

 

[valtido]

my website is shit loool n that was a minor thing but ermm i can't do that optional thing because that is a very advanced and complicated code that it wud take me a while to understand it.

 

and i would have done it if it was my web loool its coz i need to test it a few times to make sure it works try out different things loool

[dcuellar]

That's fine. Thanks for all your help though!