Im thinking about taking on a chat room php based project. I want to make sure my logic is right though. This is very raw so please feel free to contribute if you see any problems that might occur.
Insert username and password into Username table.
Search Username table to validate username and password. Create session.
enter message into chatroom1 table. Retrieve messages periodically by new message entered organized by timestamp.