ninimac
-
Posts
4 -
Joined
-
Last visited
Never
Posts posted by ninimac
-
-
Oh my god....I think I love you!
Thanks a million!
-
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!
Populating form with record from MySQL db
in MySQL Help
Posted
Hi hope someone can help me.
I'm creating a form which allows a use to update a record in an SQL database. I want to populate the form with the current data in that record. I've got it working fine for the input boxes and text areas but don't know how to do it for the drop down box (first in the form).
Any help is greatly appreciated! :-\