display data in an html table

[kevinritt]

This is actually 2 questions. I am managing a website for daily homework. I have a form that teachers fill in for each day of the week. The database uses the ID as primary with auto increment. What I'd like to do is call the latest homework entry by day and have the homework display when the 'Homework' page is opened. Students will not need to see any past week's homework but I want to keep it in the database.
To get the last entry someone suggested using select LAST_INSERT_ID FROM
QUESTION 1: Will this work? Suggestions?
QUESTION 2: How do I get the database data to display in a table that has each day of the week and each subject (e.g. math, science, etc..)?

Thanks
😃

[kevinritt]

Any ideas???????/

[twilliamsen]

question 1. no that won't work

question 2. with arrays.

Pick up a book on PHP and mysql. A good I liked is PHP Fast & Easy PHP Programming by Julie Meloni. It is a good book, a bit outdated, but it will give you the concepts for it. She is good at walk-throughs and explaining it

[kevinritt]

Thank you 😃