[SOLVED] Retrieving only 1 record from a MySQL DB

[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!

[AndyB]

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

[ninimac]

Oh my god....I think I love you!

 

Thanks a million!