Sort categories

[jackjoe]

Script URL: kressnernetwork.de/support/helpdesk
Version of script: 0.931
Version of PHP: 4.3x
Hosting company: Hosteurope
Have you searched THIS FORUM for your problem: yes
(if not please do before posting)
If so, what terms did you try: category

Write your message below:

How could I sort the categories in alphabetically order?

Greetings Jan

[Klemen]

Hi,

Interesting question, might be useful for others too. You will have to edit files index.php, find this code inside:

Code: Select all

$sql = "SELECT * FROM `hesk_categories`";

change it to

Code: Select all

$sql = "SELECT * FROM `hesk_categories` ORDER BY `name`";

That should do the trick.

[jackjoe]

Thanks I've found it quickly.

I have an other question. on start page, if I would write a new ticket, I could not see the recorded date of the ticket:
example:
https://www.kressnernetwork.de/support/ ... .php?a=add

and this is the codeline:

Code: Select all

<li><?php echo $hesklang['recorded_time']; ?></li>

I think in this line is a fault but I dont found them.

Greetings
Jan

[Klemen]

It doesn't display the date, just a message saying it has been recorded. See http://www.phpjunkyard.com/hesk/index.php?a=add

[jackjoe]

Is it possible to display the recorded time and date?

[blair.sawler]

Thanks for the tip on sorting categories for submitting a ticket. I am trying to get the category drop down menu on the admin_main.php screen to sort by name.

How would one go about doing that?

Thanks, the software is great!