Jump to content

Getting published articles from mysql


etrader

Recommended Posts

I capture a list of my articles from mysql by this command

mysql_query("SELECT * FROM Text WHERE Key='$key'") 

Now I added a column for published and draft to be identified by 1 and 0, respectively. What is the best way to show only published articles? Adding a WHERE condition? What is the most common method in major CMSes?

 

Thanks  :shy:

Link to comment
https://forums.phpfreaks.com/topic/242737-getting-published-articles-from-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.