[SOLVED] help with INNER JOIN

[digitalgod]

hey guys,

 

I'm having problems using INNER JOIN was just wondering if someone could give me a hand.

 

I have 2 tables, productsaffiliates and affiliates , I need to query the first table and be able to display it's info plus the info of the affiliate that's attached to that table...

 

so productsaffiliates looks like this

 

+-----------+--------------+------------+--------+----------+---------+

| id             | productid      | affiliateid     | mysite  | unitcost  | unitprice |

+-----------+--------------+------------+--------+----------+---------+

| 1             | 1                  | 1              | 0         | 160         | 180       |

+-----------+--------------+------------+--------+----------+---------+

 

and affiliates looks like this

 

+-----------+--------------+------------+-----------+------------+

| id             | username      | password    | firstname   | lastname    |

+-----------+--------------+------------+-----------+------------+

| 1             | test              | test123      | John         | Smith         |

+-----------+--------------+------------+-----------+------------+

 

so when I do

 

SELECT DISTINCT productsaffiliates.id, productid, affiliateid, unitcost, unitprice, mysite

FROM productsaffiliates

INNER JOIN affiliates ON productsaffiliates.affiliateid = affiliates.id

WHERE productsaffiliates.productid =1

 

if I echo $prereq["firstname"] I get an undefined index but if I echo $prereq["unitcost"] I do get the 160

 

what am I doing wrong?

 

[digitalgod]

sorry my stupid mistake, forgot to select those fields.... I'm too tired I guess hehe