[RESOLVED] Query Problem

gobbles

Hey All,

Im having some problems with a script of mine.

i have one MySQL table that has the value of an account i.e 'Free Account' = $0, 'Basic Account' = $300 .. then i have another table with the account id which would be 'Free Account' or 'Basic Account' and also a paid which is 'Yes' and 'No'

How could i combine 2 tables into one search.

Here is the table layout

| packages | advertisers |

| | venue_name |

The ID field in the packages table and the PLAN field in the advertisers table are the ones that have the same values.

SELECT * FROM both tables where packages.id = advertisers.plan AND paid = YES

How can i link the two tables and how can there be 2 id fields with different values if that makes any sense.

Cheers

cgraz

SELECT packages.field1
 , packages.field2,
 , advertisers.field3   

   FROM packages 
INNER 
   JOIN advertisers 
      ON advertisers.plan = packages.id 
WHERE packages.paid = 'YES'

If paid is in your advertisers table, just adjust the where clause. You can include whichever fields you like in the SELECT clause with tablename.fieldname format. From your post, I wasn't sure which fields were in what table.

gobbles

and using the mysql_fetch_array function, how would i display the id of the packages table, as its not the packages.id and advertisers.id fields that match, its the packages.id and advertisers.plan that are the matching fields

cgraz

That's what the ON clause does on the INNER JOIN. It links those two fields.

If you want the packages.id, then in your select clause, do

SELECT packages.id FROM ...

and to display, you would access via $row['id'] (assuming you do $row = mysql_fetch_array())...

gobbles

Very good ... Works excellent .. Thank you muchly