This query works:
$query1 = "SELECT referrers.keywords,referrers.referrer_ID, transactions.stoneage_ID, transactions.year , Count(referrers.keywords) AS total
FROM referrers,transactions
Where referrers.referrer = 'goto' and (referrers.timestamp between '20010226000000' and '20010228235959') and referrers.referrer_ID = transactions.referrer_ID
GROUP BY referrers.keywords";
But I don't want to Group by anything but when I take the group by and the count out I get "Supplied argument is not a valid MySQL result resource in php file on line 79"
How can I have it list all of those without the groupby
Steve
$query1 = "SELECT referrers.keywords,referrers.referrer_ID, transactions.stoneage_ID, transactions.year , Count(referrers.keywords) AS total
FROM referrers,transactions
Where referrers.referrer = 'goto' and (referrers.timestamp between '20010226000000' and '20010228235959') and referrers.referrer_ID = transactions.referrer_ID
GROUP BY referrers.keywords";
But I don't want to Group by anything but when I take the group by and the count out I get "Supplied argument is not a valid MySQL result resource in php file on line 79"
How can I have it list all of those without the groupby
Steve