03-03-2008, 03:42 AM
|
#2 (permalink)
|
|
The Acquainted
Join Date: Nov 2007
Posts: 154
Thanks: 31
|
It sounds like you need a really good lesson in relational databases.
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.
|
|
|
|