2010/5/12 Platonides Platonides@gmail.com:
$n = Sql_query( "SELECT (SELECT COUNT(*) FROM code_rev WHERE cr_repo_id=1 AND cr_timestamp >= '$epoch' $extra AND cr_path LIKE "/trunk/phase3%") + (SELECT COUNT(*) FROM code_rev WHERE cr_repo_id=1 AND cr_timestamp >= '$epoch' $extra AND cr_path="/trunk") + (SELECT COUNT(*) FROM code_rev WHERE cr_repo_id=1 AND cr_timestamp >= '$epoch' $extra AND cr_path="/") );
This query won't work. Each revision has multiple entries on the code_rev table, one for each path. This means you need to use COUNT(DISTINCT cr_id) and need to drop the second and third subqueries. You also need to use single quotes throughout the query, because it's wrapped in double quotes. Furthermore, the correct function name is mysql_query():
$n = mysql_query( "SELECT COUNT(DISTINCT cr_id) FROM code_rev WHERE cr_repo_id=1 AND cr_timestamp >= '$epoch' $extra AND cr_path LIKE '/trunk/phase3%'");
Roan Kattouw (Catrope)