ThLFR

Can you give us an exemple of what the data stored in your DB looks like?

Hello, Try the following 2 steps in controller:motor_development_controller.php : [INDENT]1. Define a parameter for the search function (an array which receives the data you are sending through the redirect() method) [CODE]public function search($student_info)[/CODE] 2. add the following instruction inside the search() function [CODE]$this->set('student_info',$student_info);[/CODE][/INDENT] Hope this helps

Hello, Why not have MySQL do all the calculation with the following query? SELECT sum( total - total_paid) as due FROM `invoices` WHERE `status` in( '9', '10', '11') and DATEDIFF(duedate,eofy) <= 365 The datediff(date1, date2) function returns date1 – date2 expressed as a value in days. BUT date1 and date2 …

Hello, Your 'edit' and 'delete' links call an URL with arguments 'mode' and 'id' passed using the GET method not the post method. Clicking on these links does not submit the form. Therefore, use $_GET['mode'] and $_GET['id'] instead of $_POST['mode'] and $_POST['id']

If you want to get from the database only the customers whose last name matches what was input then you have to modify line 28 and write [CODE] $sql= sprintf("SELECT * FROM customers where lastName='%s'",mysql_real_escape_string($_POST['lastName'])); //my tablename "customers" [/CODE] You could also use the following code to find all customer …