phpeveryday.com

PHP Adodb Query Tutorial: We have done with our pivot table at here. At that practice, we show pivot table using html built in function at adodb. May be you want build your own display. Not to simple like that. So, you need query. There is about trick to get query for building pivot table without confusion.

You just add $db->debug = true; line code.

 <?php 
     include('adodb/adodb.inc.php'); 
     include('adodb/tohtml.inc.php'); 
     include('adodb/pivottable.inc.php'); 	
 		
     $db = ADONewConnection('mysql'); 
     $db->Connect('localhost', 'root', 'admin', 'test');
     $db->debug = true;
 
 	$sql = PivotTableSQL(
 		$db, 'cities c, products  p, sales s',
 		     'city',
                     'product',
 		  's.products = p.id and s.cities = c.id'
 		 );
 	$recordset = &$db->Execute($sql);
 	
 	rs2html($recordset);
 	
 	$recordset->Close();
 
 ?>

Now point your browser again to http://localhost/test/adodb/pivot.php

Just copy it!