Need help with PHP

[ozone1]

Hi guys i have something like "10 most viewed links" on the hompage of my site can anyone tell me what code i need to add to show "Todays most viewed" instead of Overall Mostviewed.

 

Here is my code

 

 

<?php

$result[0] = mysql_query("SELECT * FROM videos ORDER BY view DESC LIMIT 10");

for($i=0;$i<count($result);$i++) {
echo '<td style="width:190px;font-size:12px;text-align:left;" valign="top">';
while($row=mysql_fetch_array($result[$i])) {
$id = $row['id'];
$cat = $row['cat'];
$title = $row['title'];
$numviews = $row['view'];


echo '<li><a href="videos.php?id=' . $id . '">' . $title . '</a></li>';
}
}


?>

 

Help really appreciated. THANKS

[conker87]

I suppose you'd need to make another table or column with todays views and reset it after the day is up?