Search:

I'm glad the query worked.

I do sleep, just not as much as I'd like to.

None of this should be specific to 5. It's pretty generic SQL.

Try using GROUP BY zen_products.products_id instead. MySQL can't figure out which products_id you mean (even though they're JOINed...

If I understand the problem, try adding "GROUP BY products_id" between the WHERE and ORDER clauses. I don't have any linked products in my database to test this with, so all bets are off here.

You...

To change the field order in the results, rearrange the fields in the SELECT statement to reflect that. To change sort order, add fields to the ORDER BY clause.

Keep experimenting with the query....

Sorry about the typo but I'm glad you're closer than you were. As far as I know, only relative paths are stored in the db.

If your images are stored under /home/0be1/cart/images, you could use...

Would something like this do it?

SELECT categories_name "Category", products_url "Url", products_name "Name", products_description "Desc", products_image "Image", products_price "Price" FROM...

I just had the same problem.

It looks like CSS buttons impose a 30 character limit on the alt tag. Look in includes/languages/icon_names.php for the ICON_UPDATE_ALT define.
Change it to something...