I was wondering how can I display a members article they created and show it to visitors all while displaying the members info that is associated with that article to the visitors.
I hope I explained it right?
Here is my mysql articles table.
CREATE TABLE authors_articles (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
author_id INT UNSIGNED NOT NULL,
title TEXT NOT NULL,
summary TEXT DEFAULT NULL,
content LONGTEXT NOT NULL,
date_created DATETIME NOT NULL,
date_updated DATETIME DEFAULT NULL,
PRIMARY KEY (id)
);
Here is my authors table.
CREATE TABLE author (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
email VARCHAR(255)
) DEFAULT CHARACTER SET utf8;
For example an author creates an article it displays all the info the author entered when finished but how do I make it display for visitors who visit the articles page? Do I do it by the url?