[SOLVED] Uncouth SQL

[Wolfsoap]

'SELECT date, tags, count(tags) as numberOfTags FROM journal WHERE date BETWEEN "1990-01-01" AND $now GROUP BY tags'

 

This works but doest come back with the right results, i was wondering why.

 

It come backs with the lits of tags and numbers, but it doesn't filter out the dates it should, it just returns every row, regardless of whether the date falls in the criteria or not.

 

Can someone tell me whats up with it please?

[cooldude832]

if you are selected the tags just do mysql_num_rows instead of a count.

[PHP Monkeh]

And $now is?

[Wolfsoap]

Im not bothered about the row counting that all works fine, it the date filtering that dosen't.

 

and $now is just the current date in the right format.

[cooldude832]

take your query that php makes to phpmyadmin and see what it outputs there

$q = 'SELECT date, tags, count(tags) as numberOfTags FROM journal WHERE date BETWEEN "1990-01-01" AND NOW(); GROUP BY tags'
echo "<Br /><br />".$q."<br /><br />";

[Wolfsoap]

Neat. That worked.

 

Regards,

Cool Dude 832.