Event Calendar

Hi Ross

thanks for that but i cant understand where the code will go here is ourput

<!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
<h1>Fishing Calendar - List Page Viewer</h1>
<?php foreach ($fishing_calendarRecords as $record): ?>
Record Number: <?php echo $record['num'] ?><br/>
Month: <?php echo $record['month'] ?><br/>
Day: <?php echo $record['day'] ?><br/>
Date: <?php echo date("D, M jS, Y g:i:s a", strtotime($record['date'])) ?><br/>
<!-- For date formatting codes see: http://www.php.net/date -->
Text: <?php echo $record['text'] ?><br/>
_link : <a href="<?php echo $record['_link'] ?>"><?php echo $record['_link'] ?></a><br/>
<hr/>
<?php endforeach; ?>

<?php if (!$fishing_calendarRecords): ?>
No records were found!<br/><br/>
<?php endif ?>
<!-- /STEP2: Display Records -->

thanks

Hi there.

Based on your code, I'll get you to try this:

<?php $lastMonth = ""; ?>
<?php foreach ($fishing_calendarRecords as $record): ?>
<?php if ($record['month'] != $lastMonth): ?>
<?php echo $record['month']; ?>
<?php endif ?>
<?php echo $record['day']; ?>, <?php echo date("D, M jS, Y g:i:s a", strtotime($record['date'])) ?>
<?php endforeach ?>

Just replace all the code you have in your post with everything in my post. Let me know how you make out :)

Hi Ross

I have put that in there have a look what happens now



Hows do i get it into the tables and also get the other feilds to work also.

Hi

That's odd. Could you post me a copy of that page so I can see how the code looks?

Thanks!

Hi Ross

Here is the code

<?php

require_once "cmsAdmin/lib/viewer_functions.php";

list($fishing_calendarRecords, $fishing_calendarMetaData) = getRecords(array(
'tableName' => 'fishing_calendar',
'loadUploads' => '0',
'allowSearch' => '0',
));

?>

<?php $lastMonth = ""; ?>
<?php foreach ($fishing_calendarRecords as $record): ?>
<?php if ($record['month'] != $lastMonth): ?>
<?php echo $record['month']; ?>
<?php endif ?>
<?php echo $record['day']; ?>, <?php echo date("jS", strtotime($record['date'])) ?>
<br />
<?php endforeach ?>


<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" align="center">&quot;Month&quot;</td>
</tr>
<tr>
<td>&quot;Day&quot;</td>
<td>&quot;Date&quot;</td>
<td>&quot;Text&quot;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>

Hi Craig,

If you like I could just have a look at the code directly. Just email CMS and FTP login details and a link to this post to dave@interactivetools.com. Note: email, don't post login details to the forum.

Hope that helps!

Hi Ross

Sorry for the delay here is a copy of the code still cant get this to work here is the link to the page that is being displayed

<?php

require_once "/home/botany/domains/botanybaygamefishing.com.au/public_html/cmsAdmin/lib/viewer_functions.php";

list($fishing_calendarRecords, $fishing_calendarMetaData) = getRecords(array(
'tableName' => 'fishing_calendar',
'loadUploads' => '0',
'allowSearch' => '0',
));

?>


<br />


<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" align="center"><?php $lastMonth = ""; ?>
<?php foreach ($fishing_calendarRecords as $record): ?>
<?php if ($record['month'] != $lastMonth): ?>

<?php endif ?>
</td>
</tr>
<tr>
<td><strong><?php echo $record['month']; ?></strong> &nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="100"> <?php echo $record['day']; ?></td>
<td width="40"><?php echo date("jS", strtotime($record['date'])) ?></td>
<td width="400"><?php echo $record['text'] ?> <?php endforeach ?></td>
</tr>
</table>

Hi Craig

I think you've got most of the code you need, but it's gotten a little mixed up :).

The "if" block you have is what determines whether to display the month name. It basically checks to see if the month of the current record equals the month of the previous record. The problem in your table is that the part that displays the month isn't actually in the "if" block so it just gets displayed every time regardless.

What I'll get you to do first is take this piece of code out of your table:

<strong><?php echo $record['month']; ?></strong> &nbsp;

and move it up a couple lines so that you have this:

<?php if ($record['month'] != $lastMonth): ?>
<strong><?php echo $record['month']; ?></strong> &nbsp;
<?php endif ?>

Next, I just noticed that there is one bit of code missing from my original idea. You need to load the month of the current record into that $lastMonth variable. To do that, you use this:

<?php $lastMonth = $record['month']; ?>

That goes right before the end of the foreach loop like this:

<?php $lastMonth = $record['month']; ?>
<?php endforeach ?>

Try making those two adjustments and let me know how you make out :).