Please help me..It s urgently required.Please help me.I have three types of electrical meters data with their testing dates saved in database with their id.Meters specifications are 11kv,33kv and >33kv meters.11kv meters should br tested once a year,33kv twice a year and >33kv trice a year.If i click on a link written as such
1.Click to see the uninspected meters(11 KV) 2.Click to see the uninspected meters(33 KV) 3.Click to see the uninspected meters(>33 KV)
The control should go to the database.Then starting from today's date(reportin date or system date),it should check whether in the last 1 yr(Exactly from 1 yr before),11kv has one testing data or date.If not it should show all 11kv meters which are not tested for a single time in last 1 yr.
Same for 33KV meters.By clicking on that link it should find at least two testing dates of the corresponding meters in the database.If<2 found,it should show in a tabular form.
Same for >33kv
We can use ajax where instead of a link a radio button can fetch the data and can populate a table.If ajax can be used,it would be a greater advantage.After fetching data it should populate a table.Please help mee.