Need help with Left Join (MySQL)

[MichaelP]

Hey guys, I'm doing a bit of clean up in my stuff and I,m bulilding a new tool to manage my banners...

Here is what I try to accomplish (I know it's easy for a real programmer, which I'm not and never pretended to be)

Table programs : id , name ( ex : 22 , BabesMoney) ... +++

Table banner : id , program_id , site, (ex : 1 , 22 , Babes.Com) ... +++

Now here is the query which I play with... Not working but I know I'm close.. The query itself is pretty self explanatory

$query = "SELECT banner.*, programs.* FROM banner LEFT JOIN programs ON (program_id = programs.id, program = programs.program,) WHERE  blah, blah blah, meh meh meh... ";

So on the print, I want Program = BabesMoney instead of just 22

Thank in advance

[Vapid - BANNED FOR LIFE]

databases are matrices.

[MichaelP]

You're probably better off hiring somebody than spending your time on this.

Well I'd do this if I couldn't do any of it, but now I'm stuck on a simple query, so I won't hire a programmer for a single line of code ...

[donborno]

SELECT banner.id, programs.name, banner.site
FROM banner
LEFT JOIN programs ON banner.program_id = programs.id
WHERE blah, blah blah, meh meh meh...

Probably it's an INNER JOIN unless you have banners which do not reference a program

[MichaelP]

SELECT banner.id, programs.name, banner.site
FROM banner
LEFT JOIN programs ON banner.program_id = programs.id
WHERE blah, blah blah, meh meh meh...

Probably it's an INNER JOIN unless you have banners which do not reference a program

Not quite but Txs.

hey May I hire you for an hour or so? I can pay Paypal... I have a good name here and I want to keep it. Hit me up on ICQ pls @ 139036653

[woj]

Not quite but Txs.

hey May I hire you for an hour or so? I can pay Paypal... I have a good name here and I want to keep it. Hit me up on ICQ pls @ 139036653

If the other guy is busy, icq me: 33375924, I can help out..

[sarettah]

$query = "SELECT banner.*, programs.* FROM banner LEFT JOIN programs ON (program_id = programs.id, program = programs.program,)

Do you actually have that comma before the close paren in there. Because that will screw it for you.

.

[MichaelP]

If the other guy is busy, icq me: 33375924, I can help out..

Thank you Woj for the nice help

Was very fast and effective. Will take yu for work again for sure.

A+

[sarettah]

Thank you Woj for the nice help

Was very fast and effective. Will take yu for work again for sure.

A+

Can't go wrong with WOJ

.

[Bad18yroldvirginteens]

man complicated

[Lace]

Can't go wrong with WOJ

.

I've had friends hire WOJ before and he's always been great!

[Kiopa_Matt]

SELECT banner.id AS banner_id, banner.program_id AS program_id, programs.site AS site_name FROM banner, programs WHERE banner.program_id = programs.id;

You have three columns returned -- banner_id, program_id, site_name.

[seeme]

SELECT banner.id AS banner_id, banner.program_id AS program_id, programs.site AS site_name FROM banner, programs WHERE banner.program_id = programs.id;

You have three columns returned -- banner_id, program_id, site_name.