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!