Welcome Guest, Not a member yet? Register   Sign In
A Database Error Occurred
#5

(03-30-2019, 11:04 AM)hc-innov Wrote: You can try this

PHP Code:
public function getFund()
{
return 
$this->db->select('custNo, custName, totalInstal, InstallAmnt')
->
from('fund')
->
where('status''A')
->
where('branch'16)
->
where('totalInstal >''currInstl + 1',false)
->
order_by('custName''asc')
->
get()
->
result_array();

Note the false in where clause for totalInstall <=>The field is not protected (no quote)

Thank you so much it's working.. Smile
Reply


Messages In This Thread
A Database Error Occurred - by Mohamed Rauf - 03-30-2019, 01:50 AM
RE: A Database Error Occurred - by hc-innov - 03-30-2019, 02:54 AM
RE: A Database Error Occurred - by Mohamed Rauf - 03-30-2019, 06:43 AM
RE: A Database Error Occurred - by hc-innov - 03-30-2019, 11:04 AM
RE: A Database Error Occurred - by Mohamed Rauf - 03-31-2019, 03:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB