Simple Blog - Maybe
I work with a number of systems and come across bits and pieces on t'internet, I some how want to store this kind of information.
Mysql Join to find the course ID and Fullname to which student=2 is assigned to:
SELECT CourseDetails.* FROM CourseAssignment LEFT JOIN CourseDetails ON CourseAssignment.CourseID=CourseDetails.CourseID WHERE CourseAssignment.StudentID=2;
So i need to catergorise the information, add a description and make is searchable so i could search for 'SELECT CourseDetails'.
Ideally it would be a blogging system, however I may think about creating my own system in PHP (Project to learn PHP).