news and article posts in one table
| From: | muad shibani | Date: | Thu, 24 Nov 2011 21:55:40 +0000 |
| Subject: | news and article posts in one table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-315803@lists.php.net to get a copy of this message | ||
i wanna to create one table that contains both news and articles posts,
they have similar columns like id, title, content, and date but they are
differ in one column = the source of news or article post
article has writers that have permanent names and pictures obtained from
another table called writers that supposed to be left joined with the news
table, while news posts simply have a source as text like AFP
or Reuters and so one.
How I can solve this ?