When the ustumer logs in is this possible to show the number count on the amount of tickets open and under the closed view, even on all view.

And put a 1,2,3 ect. infront of the tickets to show the ticket lines ?

Any Idea how to do this

6 months later

Yes.

Put this in somewhere at the top, just not in an if statement.

$q_open = mysql_query("SELECT * FROM ".TICKET_TABLE." WHERE email=".db_input($thisclient->getEmail())." AND status='open'");

$q_closed = mysql_query("SELECT * FROM ".TICKET_TABLE." WHERE email=".db_input($thisclient->getEmail())." AND status='closed'");

$q_all = mysql_query("SELECT * FROM ".TICKET_TABLE." WHERE email=".db_input($thisclient->getEmail()));

Then put the following in where you want it to show up.

All Tickets: <?=mysql_num_rows($q_all)?>

Open Tickets: <?=mysql_num_rows($q_open)?>

Closed Tickets: <?=mysql_num_rows($q_closed)?>

If you really want to number the lines, after

<?

$class = "row1";

$total=0;

Add

$line_number = 1;

Then change

<td align="center" title="<?=$row?>" nowrap>

<a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?>" href="view.php?id=<?=$row?>">

<b><?=$row?></b></a></td>

To

<td title="<?=$row?>" nowrap>

<table border="0" cellpadding="0" cellspacing="0"><tr><td style="border; padding-right;"><?=$line_number?></td><td style="border;"><a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?>" href="view.php?id=<?=$row?>">

<b><?=$row?></b></a></td></tr></table></td>

Then after the following

</tr>

<?

$class = ($class =='row2') ?'row1':'row2';

Add

$line_number++;

Write a Reply...