database not updated when using custom fields

tsz42

First I just want to say that I've created custom fields before and they worked just fine and were updating the database. These were custom fields which required users to enter in text.

My problem now is when I create a drop-down menu nothing is being updated/populated in the database after the ticket is created.

So far, I've only added the new field to 4 places (SQL db, includes/class.ticket.php, staff/newticket.inc.php, staff/viewticket.inc.php).

In class.ticket.php I added around line 1200 the part about:

$extId=Ticket:();

$sql= 'INSERT INTO '.TICKET_TABLE.' SET created=NOW() '.

So far, I've been mimicking the code for 'source'.

So, I'm not sure what to do next. Anyone care to share their ideas?

Thank you in advance =)

tsz42

nm, I fixed it.

I shouldn't have been copying the code for 'source'.

',source='.db_input($source).

I didn't put in the $var for my new field in the INSERT INTO portion of class.ticket.php around 1230/1250 like this:

',account_type='.db_input($var).

That seemed to do the trick. Hope I didn't embarrass myself too much!