Why are the results 0 ?

[Anon]

I'm trying to count stuff here, you know 🙂
This is the query:
SELECT COUNT(*) FROM horse_test WHERE name LIKE 'Te%' && date > date_sub(NOW(), INTERVAL 30 DAY)

And all it returns is 0...
This is the GET code:
$sql2 = "SELECT COUNT(*) FROM horse_test ". $query_count;
$result_count = db_query($sql2);

list($numrec) = db_fetch_array($result_count);
#calc num pages
$numpage = intval($numrec/$record_limit);
if ($numrec%$record_limit) $numpage++; // add one page if remainder

Any ideas?
Thanks, Arni

[[deleted]]

And just what returns 0?

If the query only results one "zero" then there are no records what match your query.

[Anon]

Well, 2 records match my query, but I get this as the result...

[Anon]

Ok, I found a type there...
Now it returns nothing... just simple plain whitespace...

God, please, help me out here :]

[[deleted]]

but, what do you get as a result?
what does the query return?

[Anon]

I just get a whitespace, that's all.. :
And by return, you mean what I try to echo?