Jump to content


Photo

Calender


  • Please log in to reply
1 reply to this topic

#1 renip9

renip9
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 May 2006 - 05:37 PM

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


}





?>


#2 renip9

renip9
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 May 2006 - 05:55 PM

got it forget it thanks guys




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users