OK i am trying to get my calender to just show 5 events at a time but everytime i try to change this code to only show 5 it kills my script. can someone please help me. as is it works but it shows all my scheduled events. <?php $connection = mysql_connect("localhost","******","******") or die ("connot connect"); $db = mysql_select_db("BIN",$connection) or die ("couldn't connect"); $USERVAR = ow4allu; $sql = "SELECT * FROM calendar_events where USERNAME='$USERVAR' ORDER BY event_start"; $result = mysql_query($sql) or die("cannot connect"); while ($newArray = mysql_fetch_array($result)) { // give a name to the fields $event_start = $newArray['event_start']; $event_title = $newArray['event_title']; echo "<font color=\"#FFFFFF\"><strong>$event_title</strong><br> $event_start </font><br><br>"; } ?>