LinusIT - 9:14 pm on Mar 4, 2011 (gmt 0)
Thanks for the replies.
The delivery address is stored in the "orders" table and the products are store in orders_products.
The delivery address is on a single line and the products are on multiple lines.
Order ID is numeric.
I will try and implement your suggestion rocknbil, thanks.