Ok guys I am trying to pull related results from two tables in mysql here is the query
$query = SELECT * FROM referrers,transactions
Where referrers.referrer = 'goto' and (referrers.timestamp between $Syear$Smonth$Sday000000 and $Eyear$Emonth$Eday235959) and referrers.referrer_ID = transactions.referrer_ID
GROUP BY referrers.keywords
the query is ok but what I want to know is when I use
mysql_fetch_array($resultclicks)
I need to refer to referrers.refererrer_ID and transactions.referrer_ID
what I need to know is how is this returned in the array, what would distinguish the fields referrers.refererrer_ID and transactions.referrer_ID from being different. Don't they both come back referrer_ID
Thanks for the help
Steve
$query = SELECT * FROM referrers,transactions
Where referrers.referrer = 'goto' and (referrers.timestamp between $Syear$Smonth$Sday000000 and $Eyear$Emonth$Eday235959) and referrers.referrer_ID = transactions.referrer_ID
GROUP BY referrers.keywords
the query is ok but what I want to know is when I use
mysql_fetch_array($resultclicks)
I need to refer to referrers.refererrer_ID and transactions.referrer_ID
what I need to know is how is this returned in the array, what would distinguish the fields referrers.refererrer_ID and transactions.referrer_ID from being different. Don't they both come back referrer_ID
Thanks for the help
Steve