MySQL query

ninimac

Hi there hope somebody can help me. I'm new to PHP and MySQL so forgive me!

I'm trying to retrieve articles from a database. The following code works fine but I only want to display one record. When I change the select statement to $query = "SELECT TOP 1 * FROM articles WHERE a_section='ae' order by id DESC"; It goes belly up and I get this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

<?php

$query = "SELECT * FROM articles WHERE a_section='ae' order by id DESC";

$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

echo "<table><tr><td class='arthead'>$row[a_title]</td></tr>".
"<tr><td>".
"<img src='images/$row[a_image]'>$row[a_text]".
"</td></tr>".
"<tr><td class='artfoot'>".
"Published by $row[a_author] on ";
$upload_date=date("d-m-Y g:i",strtotime($row[a_date_stamp]));
echo $upload_date;
echo "</td></tr></table>";
}
?>

Any help would be greatly appreciated!

ninimac

This worked so I'm grand!

SELECT * FROM articles WHERE a_section='ae' order by id DESC LIMIT 1

Creamy Goodness

you don't necessarily need the DESC keyword there as you are limiting the search to 1 record.

so SELECT * FROM articles WHERE a_section='ae' ORDER BY id LIMIT 1 would be fine.

ninimac

Hi Cemo,

I want the latest article in that section to appear and thats decided on its id number - i.e. the largest id number corresponds to the newest article.

I presume I need to include the ORDER BY id DESC for this to work?

Creamy Goodness

yup in that case you would need the DESC keyword, i miss that part in the orignal post.