[PHP-DB] Re: Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Frank Flynn wrote: But if you could be more specific - send the schema and precisely what you were looking to do I could give you an example of how to make it work. I am still having difficulties with my workup and more help would be appreciated . I have two tables CREATE TABLE `cl

[PHP-DB] Re: Highlighting data selected from one table that appear in another

2005-09-01 Thread Frank Flynn
I'm thinking that you need a "LEFT JOIN" (see the mysql documentation) to do this. Basically LEFT JOIN (or RIGHT JOIN) allow you to select all the rows from the table on the left side even if they have no corresponding row on the right side (the values of the columns in the select that bel