+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: unable to display values from array in a view (/showthread.php?tid=69450)
Pages:
1
2
RE: unable to display values from array in a view - nadeem14375 - 11-25-2017
tried to pick the last_query, and the result is strange:
echo $this->anotherDb->last_query();
die();
SELECT `payment_amount` FROM `payments` WHERE `payment_student` = '44' AND date_format(fee_month,"%d-%m%Y") >= date_format(curdate(),"00-%m-%Y") AND `payment_status` =0
Let me remove that date check too.
RE: unable to display values from array in a view - nadeem14375 - 11-25-2017
without that date check, the same error.
RE: unable to display values from array in a view - Wouter60 - 11-26-2017
I already suggested in this thread:
https://forum.codeigniter.com/thread-69443.html
to use a JOIN statement to fetch the data in one query.
Besides that, you can't compare dates that are converted to an international date format string. "26-01-2017" is greater than "04-11-2017", but that's not the result that you want, do you?