![]() ![]() I was thinking to separate the tables so i can have update for each classroom alone, i may need to update one of them per day, or 4 times per day for another class room… so i can store that data in that table, then later on display the only latest update of that table by LIMIT 1 which is working just fine Thank you dear, you are right, you idea and approach is absolutely correct. Last time ago, i used simple php display for one table similar to this, and worked, it shows the latest record of one table only, but i want them show in a grid application like a table $result = mysqli_query($con,"SELECT id, date, time, classroom_no, students_all, student_current,comments FROM classroom_1 ORDER BY id DESC LIMIT 1") I could select all tables in sql builder but i am not sure how limit the view of the rows to show me only one latest update of each table… so please help In a grid application, i want to display the data from each table of those 15 tables, each one only the latest raw added to database… so if in classroom table no1 i have 10 records, it will show me the latest updated record only… same thing for class rom table no2…etc up to no.15 Hi guys, i am tying to have simple school mysql db with 15 tables (15 class rooms), each table has unified fields/simple data like this: ID, DATE, TIME, CLASSROOM_NO, STUDENTS_ALL, STUDENTS_CURRENT, COMMENTSĪpproach is to be able to keep updating this data all the time through a form that increment that db, that is fine, it is working fine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |