PHP - Events System

It's working great, but at some points after one of the random events goes through, I reload the page and it either gives me or takes away some starpoints without showing the message.. but it shows the message all the other times.
Could someone help me debug this and see why it's doing that?

Code: [Select]
<?php
include("config.php");

//To change the odds, change the second number in the rand() function.
$rand = rand(1,3);
if($rand == 1)
{
$sql = "SELECT * FROM randomevents WHERE rarity <= '10'";
$result = mysqli_query($cxn, $sql);
//Write the events in here with the opener: $event[] = "#your event#";
while ($row = mysqli_fetch_assoc($result))
{
$event[] = $row['phrase'];
}

//This will pick a random event and show it
$renum = rand(0,count($event));
$display = $event[$renum];

if ($display == "")
{
$eventdisplay = "";
}
else
{
$eventdisplay = "<table cellspacing=\"0\" class=\"events\" align=\"center\"><br>
<tr><br>
<td><center><b><h1>Random Event</h1></b></center></td><br>
</tr><br>
<tr><br>
<td><img src=\"".$_SERVER['SCRIPT_NAME']."\">
<p><center>".$display."</center></p><br>
</td><br>
</table><br>";

$sql = "SELECT type FROM randomevents WHERE phrase='".$display."'";
$result = mysqli_query($cxn, $sql);
$row = mysqli_fetch_assoc($result);
if ($row['type'] == "gainsp")
{
$rand = rand(200,500);
$sql = "UPDATE members SET starpoints = starpoints+$rand WHERE userid='".$_SESSION['userid']."'";
mysqli_query($cxn, $sql) or die("Query died: updating starpoints");
}
elseif ($row['type'] == "losesp")
{
$rand = rand(50,100);
$sql = "UPDATE members SET starpoints = starpoints-$rand WHERE userid='".$_SESSION['userid']."'";
mysqli_query($cxn, $sql) or die("Query died: updating starpoints");
}
else
{}
}
}
else
{
$eventdisplay = "";
}
?>

Ok, so I have made 12 columns in mysql for each month.........I will have an event manager page that you can select each month that the event will take place in 0 is false 1 is true.........so I need to know how I can edit this code so that if the current month equals whatever month is checked, it will display..........is there a way to do this????????or would I need to use a date format instead of varchar and use a format such as yyyy-mm-dd and value = 0000/mm/00 so that only the month will display and then it could equal current month? Code: [Select]
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{

   $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $startdate, $enddate) = $row;
  
      $as .= "<p><a href=\"viewevent.php?eventid=$eventid\">$startdate - $enddate --- $event</a></p>\r\n";
   }


   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);
   $startdate = $row['startdate'];
      $enddate = $row['enddate'];
     $location = $row['location'];
   $description = $row['description'];
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];
$title1 = $row['title1'];
$title2 = $row['title2'];
$title3 = $row['title3'];
$title4 = $row['title4'];
$title5 = $row['title5'];
$title6 = $row['title6'];
$title7 = $row['title7'];
$title8 = $row['title8'];
$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
$date1 = $row['date1'];
$date2 = $row['date2'];
$date3 = $row['date3'];
$date4 = $row['date4'];
$date5 = $row['date5'];
$date6 = $row['date6'];
$date7 = $row['date7'];
$date8 = $row['date8'];
}
?> Code: [Select]
<table width="410" border="1" cellspacing="0" cellpadding="0">
    <tr>
      <td width="339" bgcolor="#999999" scope="col">EVENTS</td>
    </tr>
    <tr>
      <td class="afasd"><?php echo date("F",strtotime("-0 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="adfaf"><?php echo date("F",strtotime("+1 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="jasdfjs"><?php echo date("F",strtotime("+2 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
  </table>
does this make sense?

I want to only show Events that occur in October.

I'm a little unsure how to modify this code...
Code: [Select]
// Build query.
$q = 'SELECT name, location, dateandtime
FROM topic
WHERE dateandtime=?';

// Prepare statement.
$stmt = mysqli_prepare($dbc, $q);

// Bind variable.
mysqli_stmt_bind_param($stmt, 'i', $id);

Is there a PHP function that I should use?

Or do I just use a conditional?

And not sure if I even need a bound variable here.


Debbie

Hi peps,

I am trying to write a script that allows for events to be executed at any given time that user gives it like 
if the user wants it at 2 am the event will execute at that given time i read some answer they say use cron 
but im using windows how to do it ??
 

Does anybody know of a calendar script that can handle reoccurring events ?
I want to make a calendar that shows the schedule of a teacher in a school.
most classes are weekly but some are only once a month or held irregular.

classes are 50 minuter or sometimes 30 minutes. Preferably I would like to set the start time and end time of a class with a precision of 10 minutes.

The output should be a html page that shows the weekly schedule with the days as columns and the hours as rows.

Anybody knows of something similar or something I could use as a starting point ?

thanks
anatak

I am trying to populate my even calendar with, well, events that are stored in a mysql table.
I came across the following code and modified the query to work in my case.  The code used mysql_query(), but I am using mysqli_query(), and for some reason it gets to that point and dies, but mysqli_error() doesn't even run; I just get "Error1:"

If I take out the query part and only build the calendar it work perfectly.

Does mysqli_query() not work inside a for loop?

This hit my database for every day of the month, is there a better way?
I also thought about running a query to pull all results then doing array_filter() inside the for loop for each day.  Does this even work?  I can't seem to figure it out.

Code: [Select]
.....
for($list_day = '1'; $list_day <= $days_in_month; $list_day++) {
    if($list_day == $today && $month == $nowmonth && $year == $nowyear) {
      $calendar.= '<td class="calendar-day-today">';
      } else {
        $calendar.= '<td class="calendar-day">';
        }
            /* add in the day number */
        $todaydate = $year.'-'.$month.'-'.$list_day;
        $calendar.= '<div class="day-number" onclick=window.location.href="viewday.php?name='.$_SESSION['username'].'&amp;id='.$todaydate.'">'.$list_day.'</div>';   

       $y = 0;
       if(strlen($x) == '1') {$x = $y.$x; }
       
   
/** QUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !!  IF MATCHES FOUND, PRINT THEM !! **/
  $todaydate = $year.'-'.$month.'-'.$list_day;
  $query = "SELECT * FROM health WHERE '$todaydate' >= event_start AND '$todaydate' <= event_end";
  $results = mysqli_query($dbc, $query) or die ('Error1: '.mysqli_error($dbc));
            if (mysqli_num_rows($results) > '0') {
              while($row = mysqli_fetch_array($results)){
              extract($row);
......

I am open to any other suggestions also.
Thanks for the help!

i want to share my problem in my website

For the better understandng of my website, I want to tell all the details.

1. I have a database and i has a 2 tables 1 for the tbllogin which consist of Username and Department, and the second table is caltbl which i use for the calendar events.

2.When my website run the first webpage is the login form. If the Username and Department is correct she can browse the other webpages, like the calendar event.


3. In the calendar event you can see the calendar and when you click the date theirs a link "new event" appear and if theirs no existing event theres a text saying "No Events", when you click the link you can add events. I want that theirs a specific person that can only add events for the restriction of adding events. I want to happen that if the user is xxx and her department is yyy the link shoud appear and she can add events. i want that only to her the link should be appear..

here is my code:

<?php 
$host = "localhost"; 
  
    $username = ""; 
  
    $password = ""; 
  
    $dbCnx = @mysql_connect($host, $username, $password) or die('Could not Connect to the database'); 
  
    $dbName = 'dspi'; 
  
    mysql_select_db($dbName);     
?> 
<script> 
function goLastMonth(month, year){ 
// If the month is January, decrement the year 
if(month == 1){ 
--year; 
month = 13; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year; 
} 
//next function 
function goNextMonth(month, year){ 
// If the month is December, increment the year 
if(month == 12){ 
++year; 
month = 0; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year; 
}  
  
function remChars(txtControl, txtCount, intMaxLength) 
{ 
if(txtControl.value.length > intMaxLength) 
txtControl.value = txtControl.value.substring(0, (intMaxLength-1)); 
else 
txtCount.value = intMaxLength - txtControl.value.length; 
} 
  
function checkFilled() { 
var filled = 0 
var x = document.form1.calName.value; 
//x = x.replace(/^\s+/,""); // strip leading spaces 
if (x.length > 0) {filled ++} 
  
var y = document.form1.calDesc.value; 
//y = y.replace(/^s+/,""); // strip leading spaces 
if (y.length > 0) {filled ++} 
  
if (filled == 2) { 
document.getElementById("Submit").disabled = false; 
} 
else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased 
  
} 
  
</script> 
<html> 
<body> 
<?php 
//$todaysDate = date("n/j/Y"); 
//echo $todaysDate; 
// Get values from query string 
$day = (isset($_GET["day"])) ? $_GET['day'] : ""; 
$month = (isset($_GET["month"])) ? $_GET['month'] : ""; 
$year = (isset($_GET["year"])) ? $_GET['year'] : ""; 
//comparaters for today's date 
//$todaysDate = date("n/j/Y"); 
//$sel = (isset($_GET["sel"])) ? $_GET['sel'] : ""; 
//$what = (isset($_GET["what"])) ? $_GET['what'] : ""; 
  
//$day = (!isset($day)) ? $day = date("j") : $day = ""; 
if(empty($day)){ $day = date("j"); } 
  
if(empty($month)){ $month = date("n"); } 
  
if(empty($year)){ $year = date("Y"); }  
//set up vars for calendar etc 
$currentTimeStamp = strtotime("$year-$month-$day"); 
$monthName = date("F", $currentTimeStamp); 
$numDays = date("t", $currentTimeStamp); 
$counter = 0; 
//$numEventsThisMonth = 0; 
//$hasEvent = false; 
//$todaysEvents = "";  
//run a selec statement to hi-light the days 
function hiLightEvt($eMonth,$eDay,$eYear){ 
//$tDayName = date("l"); 
$todaysDate = date("n/j/Y"); 
$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
if($todaysDate == $dateToCompare){ 
//$aClass = '<span>' . $tDayName . '</span>'; 
$aClass='class="today"'; 
}else{ 
//$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
//echo $todaysDate; 
//return; 
$sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
while($row= mysql_fetch_array($result)){ 
if($row['eCount'] >=1){ 
$aClass = 'class="event"'; 
}elseif($row['eCount'] ==0){ 
$aClass ='class="normal"'; 
} 
} 
} 
return $aClass; 
} 
?> 
<div id="Calendar_Event"> 
<table width="350" cellpadding="0" cellspacing="0"> 
<tr> 
<td width="50" colspan="1"> 
<input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
<td width="250" colspan="5"> 
<span class="title" style="color:#FFFFFF"><?php echo $monthName . " " . $year; ?></span><br> 
</td> 
<td width="50" colspan="1" align="right"> 
<input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
</tr>  
<tr> 
<th>M</td> 
<th>T</td> 
<th>W</td> 
<th>T</td> 
<th>F</td> 
<th>S</td> 
<th>S</td> 
</tr> 
<tr> 
<?php 
for($i = 1; $i < $numDays+1; $i++, $counter++){ 
$dateToCompare = $month . '/' . $i . '/' . $year; 
$timeStamp = strtotime("$year-$month-$i"); 
//echo $timeStamp . '<br/>'; 
if($i == 1){ 
// Workout when the first day of the month is 
$firstDay = date("N", $timeStamp); 
for($j = 1; $j < $firstDay; $j++, $counter++){ 
echo "<td>&nbsp;</td>"; 
}  
} 
if($counter % 7 == 0 ){ 
?> 
</tr><tr> 
<?php 
} 
?> 
<!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td>  
<?php 
} 
?> 
</table> 
</div> 
<div id="New_Event"> 
<?php 
if(isset($_GET['v'])){ 
if(isset($_POST['Submit'])){ 
$sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" . $_POST['calName'] ."','" . $_POST['calDesc'] . "','" . $_POST['calDate'] . "',now())"; 
mysql_query($sql); 
} 
$sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" . $month . '/' . $day . '/' . $year . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
$numRows = mysql_num_rows($result); 
  
$check=mysql_query("SELECT * FROM tbllogin WHERE Username='rhoda.barrera@dunlop.ph' AND Department='MIS'"); 
if (mysql_num_rows($check)>0){  
?> 
<a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a><?php 
}else{ 
echo 'You cannot Add New Event'; 
}?> 
</div> 
<div id="Cal_Event"> 
<?php 
if(isset($_GET['f'])){ 
include 'calForm.php'; 
} 
if($numRows == 0 ){ 
echo ''; 
}else{ 
//echo '<ul>'; 
echo '<h3>Event Listed</h3>'; 
while($row = mysql_fetch_array($result)){ 
?> 
  
<h5><?=$row['calName'];?></h5> 
<?=$row['calDesc'];?><br/> 
Listed On: <?=$row['calStamp'];?> 
<?php 
} 
} 
} 
?> 
</div> 
</body> 
</html> 

Not sure if I posted this in the right board:

As I'm setting up a plugin to parse Google Calendar events, when they are set as All Day events, they "end" at midnight, which pushes them into the next day.  So if an event is to run All Day Friday, Saturday, and Sunday, it actually shows the end date as Monday, since it's midnight.

Any thoughts?

I created a "statistics of site" page, stats.php.
Currently stats.php updates every visit, that's over 25 queries for every visit, with over 9,000 visits a day, I wish to cut down.
What is the best way to make it so all queries are done every hour, therefore requiring less queries to the database?
I assume the best way to go at this would be either to run a time() based script every 60 minutes and:

  - update this to a new field, then stats.php will require 1 query every visit, plus the 1 every hour.
or
  - update a text file and read that each stats.php visit, meaning just the 1 query every hour.

Now, I understand the second option will run much less queries overall, but is it the best way to go? Is there a better way to go about doing this?

Anyone have info on a simple PHP script that can display a particular month where you can insert events such as a birthday or special event? Not looking for anything too complicated or fansy.

thanks

Might anyone know a good tutorial on how I might go about doing this? I found a simple calendar script that works perfectly but now I'm trying make it so I can save an event that has a start and end date that are different then each other for reoccurring to a database then have it display correctly on the calendar when I query the database.

I have no clue if I'm even going about this the right way. I haven't even started diving in to if the event was to reoccur once a week or once a month, I'm just trying to get it so it displays on the start date then displays every day until the end date. Right now I take the current day, month, year that the calendar is looping on and check it against the event day, month, year. If the current calendar day is on or after the event start date then it returns true and if the current calendar day is on or before the event end date it returns true.... so then if it returns true on both then I give it the go ahead to display on that day.

What I have is:
if($current_date['year'] > $event_date['year']) {
                $result = ($return == 'boolean') ? true : 'trail';
            } else
            if($current_date['year'] == $event_date['year']) {
                if($current_date['month'] > $event_date['month']) {
                    $result = ($return == 'boolean') ? true : 'trail';
                } else
                if($current_date['month'] == $event_date['month']) {
                    if($current_date['day'] > $event_date['day']) {
                        $result = ($return == 'boolean') ? true : 'trail';
                    } else
                    if($current_date['day'] == $event_date['day']) {
                        $result = ($return == 'boolean') ? true : 'today';
                    } else
                    if($current_date['day'] < $event_date['day']) {
                        $result = false;
                    }
                } else
                if($current_date['month'] < $event_date['month']) {
                    $result = false;
                }
            } else
            if($current_date['year'] < $event_date['year']) {
                $result = false;
            }
        break;
       
        case 'end':
            if($current_date['year'] < $event_date['year']) {
                $result = ($return == 'boolean') ? true : 'trail';
            } else
            if($current_date['year'] == $event_date['year']) {
                if($current_date['month'] < $event_date['month']) {
                    $result = ($return == 'boolean') ? true : 'trail';
                } else
                if($current_date['month'] == $event_date['month']) {
                    if($current_date['day'] < $event_date['day']) {
                    $result = ($return == 'boolean') ? true : 'trail';
                    } else
                    if($current_date['day'] == $event_date['day']) {
                        $result = ($return == 'boolean') ? true : 'today';
                    } else
                    if($current_date['day'] > $event_date['day']) {
                        $result = false;
                    }
                } else
                if($current_date['month'] > $event_date['month']) {
                    $result = false;
                }
            } else
            if($current_date['year'] > $event_date['year']) {
                $result = false;
            }

I'm trying to show the progress of executing a python script in PHP with a progress bar. I found a link (https://www.htmlgoodies.com/beyond/php/show-progress-report-for-long-running-php-scripts.html) that uses SSE to send progress updates to the client. In the original code, a loop is used to simulate a long script but in my case I'm trying to execute a python script that takes roughly 50 seconds.

index.php

<!DOCTYPE html>
   <html>
      <head>
         <meta charset="utf-8" />
      </head>
      <body>
         <br />
         <input type="button" onClick="startTask()"  value="Start Long Task" />
         <input type="button" onClick="stopTask();"  value="Stop Task" />
         <br />
         <br />
         <p>Results</p>
         <br />
         <div id="results" style="border:1px solid #000; padding:10px; width:300px; height:250px; overflow:auto; background:#eee;"></div>
         <br />
         <progress id='progressor' value="0" max='100' style=""></progress>
         <span id="percentage" style="text-align:right; display:block; margin-top:5px;">0</span>
      </body>
   </html>

process.php

<?php
header('Content-Type: text/event-stream');
// recommended to prevent caching of event data.
header('Cache-Control: no-cache');

function send_message($id, $message, $progress) {
    $d = array('message' => $message , 'progress' => $progress);

    echo "id: $id" . PHP_EOL;
    echo "data: " . json_encode($d) . PHP_EOL;
    echo PHP_EOL;

    ob_flush();
    flush();
}

//LONG RUNNING TASK
// for($i = 1; $i <= 10; $i++) {
//     send_message($i, 'on iteration ' . $i . ' of 10' , $i*10);
//     sleep(1);
$path="test.py";
$test= shell_exec("python " . $path . ""); {
    echo "data: " . json_encode($test) . "\n\n";
    sleep(1)
}

send_message('CLOSE', 'Process complete');
 

Problem: As you can see in process.php I commented the original code and placed a simple python execution in php. I just want to diplay the progress of the script but it is not doing so. What do I have to do to show the progress of the script? Note: I don't think is relavent but the python script just opens up a batch file.

Are there other methods to display the progress bar of a script in php?

Hi guys,

Im having problem on how to achieved this one.. I would like to get the all event of this month (April
) Starting todays date..

Code: (php) [Select]
$now = gmdate("Y-m-d", mktime(gmdate("H")+8, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d")+8,   gmdate("Y")));

  $week = gmdate("Y-m-d", mktime(gmdate("H")+8, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d")+30,   gmdate("Y")));
 
if ($result = mysql_query("SELECT * FROM fiesta WHERE sta_date BETWEEN '$now' AND '$week' ORDER BY sta_date LIMIT 10")){

  if (mysql_num_rows($result)) {

  $return = '';
  while ($row = mysql_fetch_array( $result )) {
       
  $date = date("D",strtotime($row["sta_date"]));

  $return .=  "<a href='sta.php' style='font-size:11px;' title='" . $row['fiesta_brgy'] . " " . $row['fiesta_town'] . "'>" . $row['fiesta_brgy'] . " " . $row['fiesta_town'] . "</a> ($date), ";
   }

    echo rtrim($return, ', ');
  }
}

The result of this query will include the events on May..

How can i display only the event on this month(April)? starting todays date.

Thank you

For the life of me, I cannot find a way to delete, cancel or remove facebook events I created & updated using the FB PHP SDK & the Graph API.

I've tried every single permutation found on facebook's documentation & stack overflow...

Here are some of the clues I have found on my quest..

https://developers.facebook.com/docs/reference/api/#deleting https://developers.facebook.com/docs/reference/api/event/ https://developers.facebook.com/docs/reference/rest/events.cancel/
http://stackoverflow.com/questions/2931387/facebook-sdk-and-graph-api-comment-deleting-error
http://stackoverflow.com/questions/2858748/facebook-api-delete-status
http://stackoverflow.com/questions/3832405/facebook-graph-api-delete-like

Here is what I have tried so far.
function delete_fb_event($event_data, $data)
{
    //load the user for offline access and userid
    $user = $this->load_user($data['aid']);

    if(!empty($user[0]['fb_offline_access']))
    {
        //instantiate Facebook API
        require 'facebook.php';
        $facebook = new Facebook(array(
          'appId'  => 'BLAHBLAHBLAH',
          'secret' => 'BLAHBLAHBLAHBLAHBLAHBLAH',
          'cookie' => true,
        ));

        $fb_event = array(
            "access_token" => $user[0]['fb_offline_access'],
        );

        $result = $facebook->api('/'.$event_data['fb_event_id'], 'DELETE', $fb_event); //Uncaught GraphMethodException: Unsupported delete request
        //$result = $facebook->api('/'.$user[0]['fb_id']."_".$event_data['fb_event_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist
        //$result = $facebook->api('/'.$event_data['fb_event_id']."_".$user[0]['fb_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist  
        //$result = $facebook->api('/'.$event_data['fb_event_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught GraphMethodException: Unsupported post request
        //$result = $facebook->api('/'.$user[0]['fb_id']."_".$event_data['fb_event_id'], 'POST', array( 'access_token' => $user[0]['fb_offline_access'], 'method' => 'delete' )); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist
        return $result;         
    }
    else
    {
        echo "error3"; //no FB offline access
    }       
}   

Quote

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/largemus/public_html/assets/inc/upcoming.php on line 15


i have hidden connection details for this example

Code: [Select]
<?php
$host=""; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name=""; // Database name 
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE user = $session->clientid ORDER BY date ASC LIMIT 3;";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
?>


<div style="width:385px;">

<table style="width: 385px; text-align:center;">
<tr>
<td style="width: 121px"><h3>Client</h3></td>
<td style="width: 100px"><h3>Occasion</h3></td>
<td style="width: 80px"><h3>Location</h3></td>
<td><h3>Date</h3></td>
</tr>
</table>

<table style="width: 385px">
<tr>
<td style="width: 121px">
<p><? echo $rows['clientid']; ?></p>
</td>
<td style="width: 100px">
<p><? echo $rows['occasion']; ?></p>
</td>
<td style="width: 80px">
<p><? echo $rows['location']; ?></p>
</td>
<td>
<p><? echo $rows['date']; ?></p>
</td>
</tr>
</table>

</div>

<?
}
mysql_close(); //close database
?>