Welcome Guest, Not a member yet? Register   Sign In
Database Error!!
#1

[eluser]Shaileen[/eluser]
I am getting the following error..


A Database Error Occurred

Error Number:

ERROR: syntax error at or near "t1_eu" LINE 5: AND "t1_eu"."seqid" = t1_admin.refid ^

SELECT "mydsl_auth"."username", "t1_admin"."refid", "t1_admin"."admin_date_sent", "t1_eu"."eu_company", "t1_eu"."eu_contact", "t1_admin"."admin_order_sent", "t1_admin"."admin_deleted", "t1_admin"."admin_cancelled", "t1_admin"."admin_active", "t1_admin"."quote_id", "t1_order"."bandwidth_id" FROM "mydsl_auth", "t1_admin", "t1_eu" WHERE "t1_eu"."seqid" like '%searchText%' AND " IS NULL AND "t1_eu"."seqid" = t1_admin.refid AND "mydsl_auth"."user_id" = t1_admin.salesperson AND "t1_admin"."admin_order_sent" = 1 AND "t1_admin"."admin_active" != 0 AND "t1_order"."refid" = t1_admin.refid ORDER BY "t1_admin"."admin_active" desc



and heres my query..Can you please help me fix it?

function query3($user_id, $inyc_limit, $field, $order, $searchField, $searchText, $groupSearch )
{

$this->db->select(array('mydsl_auth.username', 't1_admin.refid', 't1_admin.admin_date_sent', 't1_eu.eu_company', 't1_eu.eu_contact', 't1_admin.admin_order_sent', 't1_admin.admin_deleted', 't1_admin.admin_cancelled', 't1_admin.admin_active', 't1_admin.quote_id', 't1_order.bandwidth_id'));
$this->db->from(array('mydsl_auth', 't1_admin', 't1_eu'));
$this->db->where("$searchField like", "%searchText%");
$this->db->where("$groupSearch");
$this->db->where('t1_eu.seqid = t1_admin.refid');
$this->db->where('mydsl_auth.user_id = t1_admin.salesperson');
$this->db->where('t1_admin.admin_order_sent', 1);
$this->db->where('t1_admin.admin_active !=', 0);
$this->db->where('t1_order.refid = t1_admin.refid');

if (isset($inyc_limit))
{
$this->db->where("$inyc_limit");
}
$this->db->order_by($field, $order);
$query = $this->db->get();
return $query->result();
}


Messages In This Thread
Database Error!! - by El Forum - 03-04-2010, 09:30 AM
Database Error!! - by El Forum - 03-04-2010, 09:45 AM
Database Error!! - by El Forum - 03-04-2010, 09:46 AM
Database Error!! - by El Forum - 03-04-2010, 09:47 AM
Database Error!! - by El Forum - 03-04-2010, 09:48 AM
Database Error!! - by El Forum - 03-04-2010, 09:52 AM
Database Error!! - by El Forum - 03-04-2010, 09:54 AM
Database Error!! - by El Forum - 03-04-2010, 11:15 AM
Database Error!! - by El Forum - 03-05-2010, 09:27 AM
Database Error!! - by El Forum - 03-05-2010, 10:28 AM
Database Error!! - by El Forum - 03-05-2010, 11:32 AM
Database Error!! - by El Forum - 03-05-2010, 11:52 AM
Database Error!! - by El Forum - 03-05-2010, 12:04 PM



Theme © iAndrew 2016 - Forum software by © MyBB