sorting by category

mysql, php, category, rows, tables,

[beebob1]

Ok i have a table with a row that stores three options input from a dropdown option-select list in a form.

Row's Name: Colour
Either: RED, GREEN or BLUE

Say i want to display only one of these categories instead of all three how would i implement that..would it be in the following statement:

$result = mysql_query("SELECT * FROM example .... etc

ta in advance

[chronic]

What do your tables look like? Do you have a linking table, or just one table?

If you have (Id, Item, Category) in one table, and Category was a text field, you'd do something like

$result = mysql_query("SELECT * FROM example where Category = '" . $category "'");

[beebob1]

its just one table ie:

id title story color date
1 Tshirt hfdh ddj Red 2008-08-14

The colour row will have either red, green or blue, so "color" is the catagory, colour is a varchar field.

[Etheco]

just do
$q = mysql_query("SELECT * FROM table ORDER BY color");
You can add ASC or DESC after color to force it to go ethier way.

[beebob1]

ok so how can i get it just to show only entries with the color Red for example

[StoutFiles]

I would never use a SELECT * if you're not working with every column. It's just extra processing it has to do; if you have a lot of traffic you'll notice the extra time it takes.

[beebob1]

ok, sorry im new to php but working hard to understand it all, what would be a preferred way of doing this?

[beebob1]

would it be better to create a sub catagory table somehow?

[Paul Bedford]

Unless I'm missing something wouldn't this work

$q = mysql_query("SELECT * FROM table where color='Red'");

[eeek]

I would never use a SELECT * if you're not working with every column. It's just extra processing it has to do; if you have a lot of traffic you'll notice the extra time it takes.

True, but for examples here, where we do not know the details of the application, it is fine.

[beebob1]

thanks Paul bedford, what yu said produces the result i was after