4 replies to this topic

[.CJ]

Hey,

Something simple, I'm sure, but can't work it out.

SELECT * FROM members, private_msg WHERE sent_to = members.id ORDER BY is_new AND date DESC LIMIT 0, 20

I wanted to select all from private_msg but I only want the ID and USERNAME from members.

How's this done?

Thanks,

- Chris.

[nitr0x]

I think you're close, but try.

SELECT * FROM `members`, `private_msg` WHERE `private_msg.sent_to` = `members.id` ORDER BY `privatemsg.is_new` AND `private_msg.date` DESC LIMIT 0, 20

You see, you need to say what table your defining in, sent_to from private_msg table, etc.

[.CJ]

I think you mis-read, or I worded it badly, but that's not what I'm after.

Instead of selecting everything from 'members' and 'private_msg' I just want to select the ID and Username fields from 'members' and everything from 'private_msg'

This isn't at all necessary, but it does cut down on query's, which is always good.

Thanks anyway for taking the time.

[nitr0x]

ah... Sorry, my bad.

SELECT `members.id`,`members.username`,`private_msg.*` FROM `members`, `private_msg` WHERE `private_msg.sent_to` = `members.id` ORDER BY `privatemsg.is_new` AND `private_msg.date` DESC LIMIT 0, 20

[.CJ]

Cheers mate.