Selecting from two tables in the one query...
Posted: Sun Dec 10, 2006 10:56 pm
I have a shopping cart script and I'm setting up inventory control.
On the inventory control page, it selects the attributes added to that product. In another table, it records the attributes name and type (the types are drop down box, radio, text box and text area).
What I want to do is select the attributes added to the product and but also check what type it is. If it is a tetx box or text area, I do not want it to be retreived from the database.
I know you can select info from two tables from one query but I don't know how... Does anyone have a tutorial on how that works?
On the inventory control page, it selects the attributes added to that product. In another table, it records the attributes name and type (the types are drop down box, radio, text box and text area).
What I want to do is select the attributes added to the product and but also check what type it is. If it is a tetx box or text area, I do not want it to be retreived from the database.
I know you can select info from two tables from one query but I don't know how... Does anyone have a tutorial on how that works?