Similar SQL queries returning different results...
- by Pablo
Here are the SQL Queries:
$sql1 = "SELECT count(thread) AS total
FROM comments
WHERE thread=1
AND parent_id=0
";
$sql2 = "SELECT count(thread) AS total
FROM comments, users
WHERE thread=1
AND parent_id=0
AND users.user_id=comments.user_id
";
$sql3 =…