Calender

[renip9]

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>";


}





?>

[renip9]

got it forget it thanks guys