viewticket.inc.php

Bung

Hi Friends:

I have created a new field in newticket.inc.php, his field names category and is a combo-box. At the same time, i have created a new field in the ticket_table with the same name (category) as enum with three options ('monitor','software','IBM').

When i open a ticket i select any option from this field and it records into the table.

My problem is this, in viewticket.inc.php i have created the category field to show the category of the ticket and i have the next source:

<tr>

<th>Categoria:</th>

<td><? $services= db_query('SELECT categoria FROM'.TICKET_TABLE.' ORDER BY categoria');

while (list($categoria) = db_fetch_row($services)){?>

<option value="<?=$categoria?>" <?

if($_POST==$categoria) echo

'selected="selected"';

?>><?=$categoria?></option>

<? } ?>

</tr>

The problem that i have is that i get the category of the all tickets in the table. How i can select the category for each them?

Thanks a lot for your time and the answers

Bung

Please

Plaese I need help, Answer me!!!!!

I think that the problem is the time to show the results.

Platinum

Hi Bung...

Your problem is that the SQL is doing exactly what you asked of it, select all the values from the field "catergoria" in the ticket table.

There's three ways to fix your problem, the first two is only going to work in the short term: its very bad, inefficient and is only included here for reference, 1) You only want 1 of each of the items in "Category", so you could add DISTINCT after the word "SELECT" (SELECT DISTINCT categoria FROM...)

2) Just hard code the values in the element - easiest

3) You create a new reference table "Category" which contains your three (or however many you want) and "SELECT" the items from there. This way, when you want to add more (which you will) you can just add them to the db like any other record and osTicket will automatically be up to date.

Bung

Thanks

Thanx a lot for your reply. It´s Working!!!!!!

Platinum

You're welcome.

It might be nice for you to post your working mod so others with a similar need to you can benefit.

Bung

Thanks

Thanks for your reply.

When i have the aplicattion implemented i gonna upload the source