staff view

i have a field in my ticket table called "issue"

i have it set in class.ticket.php

var $issue;

$this->issue =$row;

function getIssue(){

return $this->issue;

}

Now on the tickets.inc.php page i would like to call the variable into the ticket over view.

i have <td nowrap><?=Format:($row,30)?></td>

it gives me the place it needs to be but they come up blank and i dont know why. am i calling the variable wrong or something?

i tried $ticket->GetIssue and it blew up my page.

Can some one lend me a hand?

SELECT Query SQL

Have you modified the SELECT Query SQL part?

Cliend-side:

\include\client\tickets.inc.php file, you should change this:

$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name,email '.

',dept_name,status,source,priority_id ,ticket.created ';

become this:

$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name,email '.

',dept_name,status,source,priority_id ,ticket.created, ticket.issue ';

Staff-side:

\include\staff\tickets.inc.php file, you should change this:

$qselect = 'SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '.

',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';

become this:

$qselect = 'SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '.

',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments, ticket.issue ';

Hope it helps you.

Sincerely,

Masino Sinaga

Thank you sir, worked like a charm

Eric Drozenski