Software Gardener
Thursday, May 12th, 2011A very apt analogy, I am a Software Gardener
Here is a quick tip, to get similar result as php’s array implode function inside of MySQL use GROUP_CONCAT() here is a quick example
SELECT store_orders.*,
(SELECT GROUP_CONCAT(item_name) FROM `store_orderitems` WHERE store_orders.id=store_orderitems.order_id) AS items_purchased
FROM `store_orders`
Here is a good article on mysql_ vs mysqli vs pdo, its cleraly stated that mysql_ should no longer be used.
http://www.phparch.com/conferences/webcasts
With recordings of past webcasts.
Thanks PHP Architect
Some slides to think about