Query into Array Help

sparkydude03

I am working on a site driven by wordpress. I am trying to display the top 14 stories/articles posted, but at different points in the page. The 5 most recent articles will be displayed in one column on the left of the page while the other articles will be displayed under some google ads or something roughly equal in size. Here is what I have for the query:

$sql = 'SELECT *
FROM `wp_posts`
ORDER BY post_date DESC
LIMIT 0 , 14'

What I need now is a way to populate an array with post date, post content, post author, and url of the page where the post is located. Can someone push me off in the right direction?

rsmith

use this:

$result = mysql_query($sql);
$postInfo = mysql_fetch_assoc($result)

This will take the results of the query and put them into an associative array called $postInfo. You can access the key data by saying $postDate = $postInfo['post_date']; or however your columns are named.

Also, do not put quotes around your table name. Set your query like this:

$sql = "SELECT * FROM wp_posts ORDER BY post_date DESC LIMIT 0, 14";

Hope this helps.

liquorvicar

rsmith wrote:
Also, do not put quotes around your table name. Set your query like this:
$sql = "SELECT * FROM wp_posts ORDER BY post_date DESC LIMIT 0, 14";

Quoting your tables (and fields) is actually a good thing to do in MySQL.
try creating a table called select. If you execute a query like

SELECT * FROM select

you'll find that MySQL will throw an error whereas

SELECT * FROM `select`

will work.

I'm not suggesting you call your tables "select" or similar as it's not the most descriptive name for a table, but there's a chance some table name you have now might in future become a reserved word in MySQL.

rsmith

Well maybe it's me but I make sure not to name my tables keywords embedded into MySQL.

liquorvicar

As I said, I wasn't suggesting calling a table "select" but you may pick a table name that's not a reserved word but becomes one in a future version of MySQL.