View Single Post
03-03-2008, 03:42 AM
Join Date: Nov 2007
It sounds like you need a really good lesson in
Typically a record will have a PRIMARY KEY, a unique value that represents that specific record. It can be an integer or other unique field, but since MySQL has become so popular, it's usually an auto-incremented integer value that retains it's uniqueness in the table.
To the matter of blogs, they're often times related on the date field, obviously because they're meant to be a representation of your life or viewpoint on a specific day (or day / time). You'd probably perform a SELECT statement on those columns you want to display (blog_title, blog_content, post_date, post_time, etc) based on the date and order by the last 5 or 10 records entered (again based on date).
Read up some on relational databases and SQL, then select an RDBMS like MySQL or SQLite (or Postgresql, another excellent free database system) and tinker with it.
I reject your reality, and substitute my own.
View Public Profile
Send a private message to SOCK
Find More Posts by SOCK