Last added image

strangedar

OK I want to show my visitors the last added gallery image. I have a table called gallery with the following fields id(primary), imgTitle, fileName, author, createDate. At he moment i only have on image in there but im just testing it. Anyway what do I do? I already have the connection i just need to code to select and display it.
This is my first time using php&mysql so keep answers simpl!

martian2k4

You would need a query that is sommat like this!

[PHP]

<?php

$query = mysql_query("SELECT * FROM `table_name` ORDER BY `id` LIMIT 1");

while ( $row = mysql_fetch_array ( $query ) ) {

echo $row["img_title"];

}

?>

[/PHP]

I hope it helps

strangedar

Thanks but just got this
[PHP] $result = mysql_query("SELECT fileName,imgTitle FROM gallery ORDER BY createDate DESC LIMIT 1");
$row = mysql_fetch_array($result);

echo "<img src=\"{$row}\" alt=\"{$row}\" />"; [/PHP]

strangedar

wont link to images in a directory though... do I need to escape the backslash?