Displaying today's event

albynas

Hi,

I want to display todays event. What Iam doing wrong?

<HTML>
<BODY>

<?php

include "connect.php";

$datenow = date(Ymd);

$sql = "SELECT * FROM news WHERE date='$datenow'";

$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
nl2br($row["text"]);
}
?>

</BODY>
</HTML>

intenz

<?php
require_once( 'connect.php' );
$date = date( 'Ymd' );
$query = mysql_query( "SELECT * FROM news WHERE date = '$date'" );
while( $myrow = mysql_fetch_assoc( $query ) )
{
	echo nl2br( $row['text'] );
}
?>

albynas

So the problem was with 'Ymd'. Thanks 🙂