[!--quoteo(post=352903:date=Mar 8 2006, 06:18 PM:name=pixeltrace)--][div class=\'quotetop\']QUOTE(pixeltrace @ Mar 8 2006, 06:18 PM) [snapback]352903[/snapback][/div][div class=\'quotemain\'][!--quotec--] thanks man! it work. another question, i need a script that will say that if there are no data on a specific date, lets say today, mar 9, 2006 there will be a note saying that "no new updates" may i know what the script is? because i honestly dont have an idea where to start. hoping for your help on this. thanks again! [/quote] [code] # First step: Receiving your 5 last data $query = "SELECT * FROM ... WHERE ... ORDER BY date DESC LIMIT 5"; $result = mysql_query($query, $databaseconnection); while (@$row = mysql_fetch_array($result)) { # Do something with your received data } // while # Second step: What is the highest date in db? $query = "SELECT MAX(date) AS max FROM ... "; $result = mysql_query($query, $databaseconnection); $row = mysql_fetch_array($result); # date - format in db is datetime? if ($row[max] < date("Y-m-d H:i:s")) { echo "no new updates"; } // if [/code] Code is written without deeper thinking and testing ... sorry, no time ! ;-) webwiese