sorting multiple word array elements

[dawn_green]

I have the following code:
$query = "SELECT * FROM product, media, category, vendor
where product.vendor_id = '" .$vendor."%'
and product.media_id = media.media_id
and product.category_id = category.category_id
and product.vendor_id = vendor.vendor_id";

The product_nm is a multiple word element (ie. Photoshop Filters). I need the rows returned to be ordered by product_nm so that Photoshop Add-Ons, for example, can be output before Photoshop Filters in my html. I have tried various ways of using an "order by" statement and fail to get the alphabetical results.

Any help would be appreciated and please bear in mind that I am not an accomplished PHP programmer.

Thanks.