[eluser]Shaileen[/eluser]
Heres my view :
<div style="float:right; color:#FFFFFF">
<b><?=$title; ?></b><br />
<b><?=$subtitle; ?></b><br />
</div>
<br />
<br />
<br />
<div style="float:none; margin-left: auto; margin-right: auto;">
<!-- put here the main table -->
</div>
<div style="width:751; color:#FFFFFF; margin-left:auto; margin-right:auto;">
<center>Intercom Online © 2003-2010</center>
</div>
<div id = "t1_active_orders">
<table border = 0 >
<tr>
<td width = "25">
ID
</td>
<td width = "25">
Q
</td>
<td width = "450">
Company Name
</td>
<td width = "200">
Contact Name
</td>
<td width = "300">
Email
</td>
<td width = "25">
</td>
<td width = "25">
</td>
<td width = "200">
Bandwidth
</td>
<td width = "200">
Rackspace
</td>
<td width = "75">
SP
</td>
<td width = "25">
Active
</td>
</tr>
<?
foreach($admin as $row) {
$refid = $row[0];
$quote_id = $row[1];
$eu_company = $row[2];
$eu_contact = $row[3];
$email = $row[4];
$bandwidth_id = $row[5];
$person = $row[6];
$admin_date_activated = $row[7];
?>
<tr>
<td><A class='dark'></td>
<td><A class='dark'>
<td><?=$eu_company; ?></td>
<td><?=$eu_contact; ?></td>
<td><?=$email;?></td>
<td><?=$bandwidth;?></td>
<td><?=$person;?></td>
<td><?=$admin_date_activated;?></td>
</tr>
<?
}
?>
</table>
</div>
I am getting the following error :
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: admin
Filename: views/t1_orders_active_view.php
Line Number: 57
A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: views/t1_orders_active_view.php
Line Number: 57
I have used the admin keyword in my controller for the in the following line :
if($AUTH->tick2 == 1)
{
$data['admin'] = $this->t1_orders_active_model->one($AUTH->user_id, $inyc_limit);
}
And here is my function one :
function one($x,$y)
{
$this->db->select('mydsl_auth.username, t1_admin.refid, t1_admin.admin_date_activated, t1_eu.eu_company, t1_eu.eu_contact, t1_admin.quote_id, t1_order.main_email, t1_order.bandwidth_id');
$this->db->from('mydsl_auth, t1_admin, t1_eu, t1_order ');
$this->db->where('t1_admin.admin_active =', '1');
$this->db->where('t1_admin.admin_deleted =', '0');
$this->db->where('t1_admin.admin_cancelled =', '0');
$this->db->where('t1_admin.admin_order_sent =','1');
$this->db->where('t1_eu.seqid = t1_admin.refid');
$this->db->where('mydsl_auth.user_id = t1_admin.salesperson');
$this->db->where('order.refid = t1_eu.seqid ');
$this->db->where('t1_admin.salesperson', $x);
$find_admin = $this->db->get();
foreach($find_admin->result() as $row)
{
list($person, $refid, $admin_date_activated,$eu_company, $eu_contact, $quote_id, $email, $bandwidth_id) = $row;
}
return $find_admin;
}
please help.