Showing End time

[SkyRanger]

I am working on a code that I started along time ago but having problem showing the end time, could somebody please have a look at my code to see what I am missing. 

 

Thanks

 

$getEvent_sql = "SELECT id, event_title, event_shortdesc,
                date_format(event_start, '%l:%i %p') as fmt_date, date_format(event_end, '%l:%i %p') as fmt_enddate FROM
                calendar_events WHERE month(event_start) = '".$m."'
                AND dayofmonth(event_start) = '".$d."' AND
                year(event_start)= '".$y."'  ORDER BY event_start";
$getEvent_res = mysql_query($getEvent_sql, $mysql)
                or die(mysql_error($mysql));

if (mysql_num_rows($getEvent_res) > 0){
        $event_txt = "<ul>";
        while($ev = @mysql_fetch_array($getEvent_res)){
                $evid = $ev["id"];
			$event_title = stripslashes($ev["event_title"]);
                $event_shortdesc = stripslashes($ev["event_shortdesc"]);
                $fmt_date = $ev["fmt_date"];
                $fmt_enddate = $ev["fmt_enddate"];
                $event_txt .= "<li><a href=editevent.php?id=$evid>$editevent</a><a href=deleteevent.php?id=$evid>$deleteevent</a><strong>".$fmt_date."</strong>:
                              ".$event_title."<br/>".$event_shortdesc."</li>";
        }
        $event_txt .="</ul>";
        mysql_free_result($getEvent_res);
} else {
        $event_txt = "";
}

mysql_close($mysql);

if ($event_txt != ""){
        echo "<p><strong>Today's Events:</strong></p>
        $event_txt
        <hr/>";
}

[Pikachu2000]

What kind of problem are you having?

[SkyRanger]

The problem I am having is that it will not extract the and show the event_end.  Sorting through the code, I am not sure what the problem is.

[SkyRanger]

Anybody?

[Pikachu2000]

Echo the query string and paste it in to phpMyAdmin (or similar) and see what result it returns for that field.

[SkyRanger]

ok thank will try

[Pikachu2000]

Looking at it again, I see where you assign the value from the array to the variable: $fmt_enddate = $ev["fmt_enddate"];, but I don't see anywhere in the code that you actually try to echo the value.

[SkyRanger]

Hi Pikachu2000 this is what i have so far

 

 

if (mysql_num_rows($getEvent_res) > 0){
        $event_txt = "<ul>";
        while($ev = @mysql_fetch_array($getEvent_res)){
                $evid = $ev["id"];
			$event_title = stripslashes($ev["event_title"]);
                $event_shortdesc = stripslashes($ev["event_shortdesc"]);
                $fmt_date = $ev["fmt_date"];
                $fmt_enddate = $ev["fmt_enddate"];
                $event_txt .= "<li><a href=editevent.php?id=$evid>$editevent</a><a href=deleteevent.php?id=$evid>$deleteevent</a><strong>".$fmt_date."</strong>:
                              ".$event_title."<br/>".$event_shortdesc."</li>";
        }
        $event_txt .="</ul>";
        mysql_free_result($getEvent_res);
} else {
        $event_txt = "";
}

mysql_close($mysql);

if ($event_txt != ""){
        echo "<p><strong>Today's Events:</strong></p>
        $event_txt
        <hr/>";
}

 

[Pikachu2000]

I still don't see anywhere in the code that you try to echo the value . . .

[SkyRanger]

if ($event_txt != ""){
        echo "<p><strong>Today's Events:</strong></p>
        $event_txt
        <hr/>";
}

[Pikachu2000]

But $event_txt contains no reference to $fmt_enddate, so it won't be anywhere in that string.

[SkyRanger]

With you saying that, I looked back over my script again and realized I forgot to put the ".$fmt_enddate." into the string.  Thanks Pikachu2000