Archive

Posts Tagged ‘query’

MySQL Transpose Row Into Column

Image representing MySQL as depicted in CrunchBase

Image via CrunchBase

This article explain how to transpose a MySQL table from row to column. Suppose that you have a sales table per item per retail outlet per sales date like this:

Original Sales Table

Then, you need to show the total sales per item per retail outlet like the following:

Read more…

  • Share/Bookmark
Categories: MySQL Tags: , ,

PHP Connection to PostgreSQL

Berikut ini langkah langkah yang perlu diperhatikan ketika membuat aplikasi PHP yang connect ke database PostgreSQL.

Function pg_connect

Langkah pertama adalah memanggil function pg_connect() untuk melakukan koneksi ke database server.

$dbconn = pg_connect ($conn_string);

Read more…

  • Share/Bookmark
This site uses a Hackadelic PlugIn, Hackadelic SEO Table Of Contents 1.6.0.