No results

[timmah1]

Why does this show "cannot get results!" constantly??

 

$events = array();
$query = "SELECT title, DATE_FORMAT(event_date'%Y-%c-%e') AS event_date FROM events WHERE event_date LIKE '$year-$month%'";
$result = mysql_query($query,$db) or die('cannot get results!');
while($row = mysql_fetch_assoc()) {
$events[$row['event_date']][] = $row;
}

 

Thanks in advance

[rajivgonsalves]

if you put the following we will find out

$result = mysql_query($query,$db) or die('cannot get results!:'.mysql_error());

[JAY6390]

DATE_FORMAT(event_date'%Y-%c-%e')

should be

DATE_FORMAT(event_date, '%Y-%c-%e')

[ignace]

typo:

while($row = mysql_fetch_assoc())

 

should be:

while($row = mysql_fetch_assoc($result))

 

use trigger_error() instead of die()

[timmah1]

I always seem to forget that rajivgonsalves

 

Thanks jay, that worked.

 

and thank you ignace, I didn't even see that

Works now!