[RESOLVED] Anyone ever had trouble getting mySQL to order alphabetically

[geek_girl_2020]

I have two queries which are pretty much exactly the same - just accessing different tables - they both use ORDER by column_name ASC.

Both queries are ordering based on a column of name fields - none of which are NULL.

This doesn't order the results alphabetically, but works fine otherwise:

$query_product_name = "select * from product where product_id LIKE '".$product_id."' ORDER BY product_name ASC";

And this does work:

$query = "select * from textile_category ORDER BY textile_category_name ASC";

The only difference is that the one that works doesn't have dynamic variable-base input.

I really need the product names to be ordered alphabetically - does anyone have any idea why it isn't working?

Many thanks for any assistance.

[bogu]

Well if product_id is auto increment u realise that u extract only one result that have the product_id = $product_id and u dont need the order by thing ...

If u got more product_id = $product_id (assuming that product_id is not auto increment) then the ORDER BY thing should work ...

Did u try the first query without product_id = $product_id?

[geek_girl_2020]

...hmmm

Thank you very much - you have certainly pointed me in the right direction - my code was looping around taking one row at a time!! so that's why the ORDER BY wasn't going to do anything!!

Many thanks for your help - I will have to go back and restructure my code.

[bogu]

Take care and have fun coding... 😃