Server side table - solved

markwoowoo

Hi, firstly I have to say thank you for datatables - it has been of immense help. I have been tearing my hair out over my script - it's returning empty values and I can't see why. I'm sure this is probably a silly little error, but I just need a fresh pair of eyes! An example of the problem is at www.etindex.com/natabletest1.php. Here is my script minus the usernames etc: [code] <?php
/*
* MySQL connection
*/
$gaSql['link'] = mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password'] ) or
die( 'Could not open connection to server' );

mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
die( 'Could not select database '. $gaSql['db'] );


/*
* Paging
*/
$sLimit = "";
if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' )
{
$sLimit = "LIMIT ".mysql_real_escape_string( $_GET['iDisplayStart'] ).", ".
mysql_real_escape_string( $_GET['iDisplayLength'] );
}


/*
* Ordering
*/
if ( isset( $_GET['iSortCol_0'] ) )
{
$sOrder = "ORDER BY ";
for ( $i=0 ; $i

markwoowoo

Sorry, that url should have been www.etindex.com/na300tabletest1.php

markwoowoo

It was a problem with the array $aRow - a little further coaxing is all it needed.