I'm bulding a webside without a very good knowledge of MySql.
And in the blogg/news I want to show the content from the "article" table on my mysql db.
I thought it would be something like this:
Well, I have a table called 'article' with the following fields: aid, author, time, content.
And how can I display the 10 latest rows/articles from that table on the website?
$result = mysql_query("SELECT * FROM `articles` ORDER BY `id` DESC LIMIT 10") or die(mysql_error());
while($array = mysql_fetch_assoc($result)){
echo $array['text'];
}
for example
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
I'm now able to show the content on the page, but now I need to divide each row(/content) from each other.
It is several articles, and now the page looks like this: