[Resolved] Event Calendar doesn't display hrefs

BLottman

Attached is the code that displays a 12 month calendar 3 columns by 4 rows. To see the calendar go to my site:

http://www.solidsnstripes.com/eventcalendardisplay.php

The calendar displays all of the dates correctly. However, I want to display a hyperlink for those days where there are one or more events (i.e., records) found in the database for the specific day. Thus, those days where there are no records found, the days would not have an href associated with them.

The EVENTCAL table structure is as follows:

ID int(11) PRI auto_increment
STATE text YES

CITY text YES

ADDRESS text YES

ZIP text YES

TELEPHONE text YES

DESCRIPTION text YES

ACCT text YES

EVENTSTARTDATE date YES

EVENTDAYSDURATION text YES

There are two rows in the table that have dates 2004-07-29 and 2004-07-30 respectively.

Lines 79 through 87, of my code attachment, is supposed to print the hyperlink but I'm having trouble knowing why the count is not functioning.

The original calendar code appears as a code snippet found on the PHPbuilder site at the following link:

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=48

I've modified it to create hyperlinks for each day then modified it again to only create hyperlinks for a day where there are records found. I'd appreciate anyone taking a look to find the cause.

Thanks.

dcav

I did the same thing, just store all the dates you have an event to an array and when you pass through the loop to display the days, explode the dates and compare them to the value of the loop. If it matches, you output a corresponding <a href...

my calendar in action: http://www.sugoidesign.com/cldwi/

sneakyimp

I can think of a few things:

// i'm guessing you have a value in your dbase that matches this date EXACTLY?

$selected_date = "2004-07-29";

// try adding quotes around $selected_date in your query...in sql,
// only INTEGERs don't need quotes...i'm pretty sure that's your
// problem.

// for this, i might try $mycount > 0
$mycount=@mysql_num_rows($myresult);
if ($mycount != 0) {

put some ECHO statements in your code...that will help you narrow down the possibilities...i'm pretty sure it's the quote thing though...like this:
$myresult = "SELECT * FROM EVENTCAL WHERE EVENTSTARTDATE='$selected_date'";

BLottman

I had the ' ' around the $selected_date previously and tried once again but still not displaying an href.

Also plugged the $selected_date as a literal string in the query and that doesn't find the row either.

Could it be that the row is of type date and that the literal string is of the wrong type?

dcav

Since you control your type from your php, you don't really need to specify that field type to DATE in your table. You could just use VARCHAR or TEXT. I am using VARCHAR and querying is much easier. I could do something like this for events of the month

select * from tableEvents
where eventDate LIKE '$yyyy-$mm-%'

Good luck

BLottman

Now I feel like a real meltdown....

I didn't have the following mysql_query statement just before the mysql_num_rows statement.

$result = @($myresult);
$mycount=@mysql_num_rows($result);

That was an exercise in futility.

Thanks for your suggestions.