[timbaker1991]

Oky, trying to display videos on a website by drawing informtaion from a database table, but only want to display the most recent video, i.e. the last record, I have tried a few solutions but can't get it to work, heres my code if anyone could help me would really appericiate it!


<?php
$con = mysql_connect(" ************ "," ************ "," ********* ");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("clairescou1", $con);

$result = mysql_query(" SELECT (video_url), FROM video");
while($row = mysql_fetch_array($result))
{
echo $row['video_ID'] . " " . $row['video_url'];
echo "<br />";
}

mysql_close($con);
?>

(for obvious reasons i've removed the passwords/address etc!)

[End User]

To do any kind of sorting (first, last, etc) you need to have some sort of key with which to sort by, like an ID or an upload date. You have "video_ID", which hopefully is an auto-incrementing number. If that's the case, then you can use SQL something like this:

SELECT * FROM video ORDER BY video_ID DESC LIMIT 1

This selects 1 row, ordered by the video_ID in descending order. The result is that you should get the highest (most recent) video_ID.

Also, unless you're selecting out more than 1 row, you don't need to use a WHILE loop. You can just do something like this:

PHP Code:

$result = mysql_query("SELECT * FROM video ORDER BY video_ID DESC LIMIT 1");
$row = mysql_fetch_array($result));
echo $row['video_ID'] . " " . $row['video_url']; 

[timbaker1991]

that works great thank you! cheers