Any better way for "WHERE"??

[szym9341]

Here is my code... any streamline way to accomplish this?

$styles = mysql_query("SELECT *
  FROM styles,
       vendors,
       materials,
       typetypes,
       subtypes,
       genders
    WHERE styles.vendor_id = vendors.vendor_id AND
          styles.material_id = materials.material_id AND
          styles.type_id = typetypes.type_id AND
          styles.subtype_id = subtypes.subtype_id AND
          styles.gender_id = genders.gender_id
      ORDER BY vendor_name, style_code ASC");

[dotbob]

You could use JOINS...

SELECT styles., vendors., materials., typetypes., subtypes., genders. FROM styles
INNER JOIN vendors ON vendors.vendor_id = styles.vendor_id
INNER JOIN materials ON materials.materials_id = styles.material_id
INNER JOIN typetypes ON typetypes.type_id = styles.type_id
INNER JOIN subtypes ON subtypes.subtype_id = styles.subtype_id
INNER JOIN genders ON genders.gender_id = styles.gender_id
ORDER BY vendors.vendor_name, styles.style_code ASC

This is the way that I was taught, the only advantage that I know of is that you can limit what fields to return i.e.

SELECT styles.material_id, styles.subtype_id

instead of using SELECT styles.* - this way you can reduce the amount of fields returned within your result which in theory would speed up execution on a large DB.

HTH