[Resolved] Problem with a calendar

[badgoat]

Hi,

I have a calendar script which functions correctly.. I would like to be able to click the date in the calendar and be able to see events which are set for that date. Currently when I click a date, every event which has no date set is displayed and nothing else. I am not sure where I went wrong, but I think it is in where I compare the date_string to cal_string. date_string is a date column(0000-00-00) in MySQL. cal_string is pulling month, day, year from the calendar script.
Code below:

$Day = $_GET['Day'];
$Year = $_GET['Year'];
$Month = $_GET['Month'];
$cal_string = $Year . "-" . $Month . "-" . $Day;

$cal_string = $_GET['cal_string'];

$sqlquery = "SELECT id, diwtitle, date_string FROM diw_alpha WHERE date_string = '$cal_string' ORDER BY date_string";
//WHERE date_string = '$cal_string' ORDER BY date_string



$queryresult = mysql_query($sqlquery) or die(" Could not execute mysql query !");
$row = mysql_fetch_row($queryresult);
$date_string = $row[0];
$diwtitle = $row[1];
$id = $row[2];
$tdcount = 1;
$numtd = 1; // number of cells per row
echo '


<TABLE>

<TR>
<TD> Date of Event </TD>
<TD> Title </TD>
<TD> Event ID ></TD>';
while($row = mysql_fetch_array($queryresult)) {
if ($tdcount == 1) echo "<tr>";
echo '<td>'.$row['date_string'].'</td><td><a href="damndiw4.php?id='.$row['id'].'"> '.$row['diwtitle'],'</a></td><td>'.$row['id'].'</td>';
 if ($tdcount == $numtd) {
 echo "</tr>";
 $tdcount = 1;
 } else {
 $tdcount++;
 }
}
//  close up table
if ($tdcount!= 1) {
 while ($tdcount <= $numtd) {
 echo "<td>&nbsp;</td>";
 $tdcount++;
 }
 echo "</tr>";
}
echo "</table>";
?>

[kburger]

Here's your problem:

$cal_string = $_GET['cal_string']; 

You're wiping out what you defined it to be in the previous line. Remove this line. Also, your 'ORDER BY' clause is irrelevant since all results returned will have the same date.

[badgoat]

Hi kburger,

I removed the line as recommended and also removed the ORDER BY part in the query, and I still get only events which have a 0000-00-00 date (date is unset) I am wondering if this because $date_string cannot equal $cal_string for some reason?

[kburger]

Try echoing out your $sqlquery. You didn't show us the form you're using to select the dates. Do $Day, $Year, and $Month have valid values?

[badgoat]

When I echo my query the result is:
SELECT id, diwtitle, date_string FROM diw_alpha WHERE date_string = '--'

The dates are missing. However when I look at the URL, the numbers are correct.

http://localhost/depday.php?year=2005&month=May&day=16

Here is a portion of the calendar script, where I can click on the date to (eventually) go to the events of that date:

//Assign positions to days of week and identify the starting day
switch($day)
  {
  case "Monday" :
  $startpos="2";
  break;

  case "Tuesday" :
  $startpos="3";
  break;

  case "Wednesday" :
  $startpos="4";
  break;

  case "Thursday" :
  $startpos="5";
  break;

  case "Friday" :
  $startpos="6";
  break;

  case "Saturday" :
  $startpos="7";
  break;

  case "Sunday" :
  $startpos="1";
  break;
  }

//next we need to determine how many rows of seven columns we need
$basenum=$startpos+$days-1;
$rows=ceil($basenum/7);

//Next, we draw the calendar body
$rowcount="1";
$daycount="1";
$calendar_day=0;
while ($rowcount<=$rows)
  {
  echo "<tr>";
  $day_column=1;
  while ($day_column<=7)
    {
    echo "<td>";
    if ($daycount<$startpos)
      echo "&nbsp;";
    elseif (($daycount-$startpos+1)>$days)
      echo "&nbsp;";
    else
      {
      $calendar_day=$calendar_day+1;

   echo '   <a href="depday.php?year='.$Year.'&month='.$Month.'&day='.$calendar_day.'"> '.$calendar_day,'</a> ';

//  echo "$calendar_day";
  }
$daycount=$daycount+1;
echo "</td>";
$day_column=$day_column+1;
}
  echo "</tr>";
  $rowcount=$rowcount+1;
  }

//Finally, we finish the table
echo "</table>";

//echo test variables
//echo "start position is $startpos<br/>";
//echo "Month is $Month<br/>";
//echo "Year is $Year<br/>";
//echo "Starting Day is $day<br/>";
    ?>

[kburger]

$Day = $_GET['Day']; 

is not the same as

$Day = $_GET['day']; 

You're also using ...month=May... It will need to be ...month=05...

[badgoat]

I found a few capitalization errors, which, when fixed, allow me to echo the sql query correctly. Now displayed is

SELECT id, diwtitle, date_string FROM diw_alpha WHERE date_string = '2005-May-30'

Yet still, only unset dates are displayed. Does this have to do with the Month being displayed in calendar format and not in numerical format? If so, I am not sure how to edit the calendar code to get it to use two digits instead of the name of the month..

[kburger]

Try this. Change

$cal_string = $Year . "-" . $Month . "-" . $Day;

to this

$cal_string = date("Y-m-d", strtotime("$Month $Day $Year"));

[badgoat]

kburger, you rule 🙂

Thank you kindly!

[kburger]

No problem. Glad to help.