[SOLVED] nedd assistance with calendar script

[kb9yjg]

Hey all,

 

I have a script that creates time increments dynamically and should be displaying columns right though  Any ones help is greatly appreciated. Code is below.

<?
$stime = strtotime('12am'); 
for ($i = 0; $i < (24 * 4); $i++) { 
    $tod = $stime + ($i * 30 * 60); 
    $display = date('h:i A', $tod); 
    if (substr($display, 0, 2) == '00') { 
        $display = '12' . substr($display, 2); 
    } 
include('inc/connect.inc');
$table="events";
$columns = 7;
$current_column = 1;	
$cols=7;
if ($current_column == 1) {
        echo '<tr><td scope=row align=center>'.$display.'</td>';
    }

$q="select * from $table";
$res=mysql_query($q) or die("Error selecting events. ".mysql_error());
while($row=mysql_fetch_assoc($res)){
if($display=$row['evtime']){
echo '<td align="center"><a title="'.$row['eday'].'<br />'.$row['evtime'].'<br />'.$row['about'].'">'.$row['event'].'</a></td>';
	$current_column++;
if ($current_column > $columns) {
        echo "</tr>";
        $current_column = 1;
    }else{ echo '<td> </td>';
  }
  }else{echo '<td> </td>';}
}
}
if ($current_column>1) {
    for ($col=$current_column; $col<=$columns; $col++) {
        echo "<td> </td>";
    }
echo '</tr>';
} 
?>

 

 

[revraz]

You didn't state what the problem was.

[kb9yjg]

having issues with getting things to populate correctly and look right thats why i directed you to the site address at bitsonline.vndv.com//index.php

[DarkWater]

You never posted the site address before your most recent post.

[revraz]

What you need to do:

 

Describe the problem, say what it does and what you want it to do.

 

Post any errors.

[kb9yjg]

What it does:

 

populates each time slot with the same post

it skips the date it is supposed to be posted on

 

Does not do:

does not fill in accordingly all other timeslots and columns with spaces since theres no data for those cols or slots

Does not stick the time and event in the correct time slot

 

What i want it to do.

 

Fill in all other columns and time slots with spaces so that there are no empty cells

stick the event on the correct date and time

 

This is a weekly event calendar and need to have each column either filled with events or spaces indicating no event is scheduled.

[DarkWater]

Yeah well, we can't help much without any code.  Please post RELEVANT code inside of code tags.

[kb9yjg]

as seen on my original post of this thread

<?
$stime = strtotime('12am'); 
for ($i = 0; $i < (24 * 4); $i++) { 
    $tod = $stime + ($i * 30 * 60); 
    $display = date('h:i A', $tod); 
    if (substr($display, 0, 2) == '00') { 
        $display = '12' . substr($display, 2); 
    } 
include('inc/connect.inc');
$table="events";
$columns = 7;
$current_column = 1;	
$cols=7;
if ($current_column == 1) {
        echo '<tr><td scope=row align=center>'.$display.'</td>';
    }

$q="select * from $table";
$res=mysql_query($q) or die("Error selecting events. ".mysql_error());
while($row=mysql_fetch_assoc($res)){
if($display=$row['evtime']){
echo '<td align="center"><a title="'.$row['eday'].'<br />'.$row['evtime'].'<br />'.$row['about'].'">'.$row['event'].'</a></td>';
	$current_column++;
if ($current_column > $columns) {
        echo "</tr>";
        $current_column = 1;
    }else{ echo '<td> </td>';
  }
  }else{echo '<td> </td>';}
}
}
if ($current_column>1) {
    for ($col=$current_column; $col<=$columns; $col++) {
        echo "<td> </td>";
    }
echo '</tr>';
} 
?>

 

 

[DarkWater]

Woops forgot about that.  Can we see your DB structure?

[kb9yjg]

Here is my table structure. I only am using a single table for this calendar.

CREATE TABLE `events` (
  `eid` int(11) NOT NULL auto_increment,
  `evtime` varchar( NOT NULL,
  `eday` varchar(10) NOT NULL,
  `event` varchar(100) NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY  (`eid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

 

[DarkWater]

Why are you storing the date and time as VARCHAR instead of one DATETIME column which you can then manipulate?

[kb9yjg]

stored it like that because I had some bad luck with formatting dates in previous scripts. I found if they were stored in varchar they could easily be formatted or manipulated. I am willing to learn and figure out why this isn't  working though. Thank you for your time in going through this with me.

[revraz]

For a calendar type of application, using varchar is useless.

 

You need to learn either Unix timestamps or MySQL timestamps.  Don't worry too much about formatting it, that is the easy part.

[kb9yjg]

alright. Thanks for pointing me in the right direction. Now how can I get this thing fixed so it displays a link when appropriate and all cols and cells are filled with a nbsp if no event is present?