Re: [php-list] PHP/MYSQL 3 Tables with Group by

2006-07-29 Thread Prinze Adam
Thank you for the reply James, maybe I should explain myself better. Yes, I actually want all in table1.field2 to be listed, group by, and counted - whether it is in table2, table3 or not. From two remining talbes, table2 and table3: all I want is to select 1 field from each. I dont see any

Re: [php-list] MYSQL

2006-07-22 Thread Prinze Adam
Thank you Phill Phill Sparks <[EMAIL PROTECTED]> wrote: It's often good practice with multiple tables to reference them when Yahoo! Groups Sponsor ~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.cli

[php-list] MYSQL

2006-07-21 Thread Prinze Adam
Hello, Is this the right way to join 4 tables? SELECT f1, f2, f3, f4 FROM ( ( FIRST LEFT JOIN SECOND ON idf1= idf2 ) LEFT JOIN third ON idf2= idf3 ) LEFT JOIN fourth ON idf2 = idf4 LIMIT 30 - Yahoo! Music Unlimited - Access ove

[php-list] Help PHP - MYSQL

2006-07-04 Thread Prinze Adam
Hello Guys, I have 2 MYSQL tables. The first one is containing user_ID and the second one is containing author_ID. I want to list and display up to 15 author_IDs at the same time, and whenever author_ID and user_ID are matching, the author_ID will be bolded. I have written some co