From the bottom up
   You have to start some where

Archive for November, 2009

PHP’s implode() in MySQL

Thursday, November 12th, 2009

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`

Web Development | Comments (0)

Mysql Drivers/Extensions: mysql_ is out, use mysqli_ or pdo

Tuesday, November 10th, 2009

Here is a good article on mysql_ vs mysqli vs pdo, its cleraly stated that mysql_ should no longer be used.

Which PHP Driver for MySQL should I use

Web Development | Comments (0)