how to choose info from one table to another

[jbrill]

hey,

 

I have a table called "products" in this table is a row for "color" the color row holds the id of a certain color in the "Colors" table.

How would i go about using the sku from the products table to search the colors table for the corresponding colors name?

[esukf]

You need to use a JOIN clause in your sql statement. Something in the line of:-

 

SELECT * FROM products_table INNER JOIN colours_table ON (products_table.colour = colours_table.id);

 

There are various types of joins which you can read up on http://en.wikipedia.org/wiki/Join_(SQL)

[MmmVomit]

Here's another good reference for SQL.

 

http://www.w3schools.com/sql/default.asp

[soycharliente]

Join's confuse me (lol). I usually do something like:

$smut = "SELECT products.color, colors.id, colors.color AS whatyouwant FROM products, colors WHERE products.color = colors.id";

 

Or something to that effect.

[MmmVomit]

Essentially, that IS a join.