Need help with shopping cart order query

[reservoir]

Here is a simplified typical query for order details in a oscommerce type shopping cart query. Customers buying tickets.

order_sql="SELECT o.orders_id,op.orders_id, op.products_quantity
	   FROM orders.o and orders_products.op
	   WHERE o.orders_id=op.orders_id
	   ORDER by o.orders_id and op.products_name";

order_query=tep_db_query(order_sql);

If there was an order and in that order a product was purchased with a quantity of 3.

How can I list the product 3 times? rather than the one time in this query

I want a result like this listing each product relevant to its order quantity and adding another number to denote the next quantity:

ORDER ID PRODUCT NAME

Order ID: 1 - Ticket No 7 - (1)
Order ID: 1 - Ticket No 7 - (2)
Order ID: 1 - Ticket No 7 - (3)

Order ID: 2 - Ticket No 9 - (1)

Order ID: 3 - Ticket No 4 - (1)
Order ID: 3 - Ticket No 4 - (2)

[dagon]

you will have to do that in the php output, in the output loop check the op.products_quantity if its greater than 1 put a little loop in their

[amit_patel]

I think if you want to use query thant mysq REPEAT will be the answer.
Find the detail below

http://dev.mysql.com/doc/refman/5.0/en/repeat-statement.html

[djjjozsi]

you should use a better SQL query then the normal equal relation...
change the o and op to the correct table name.

SELECT o.orders_id, o.products_name, op.products_quantity
FROM op RIGHT JOIN o ON op.orders_id = o.orders_id;