Simple Database reading

Simple Database reading

Authenticity809Authenticity809 Posts: 2Questions: 0Answers: 0
edited December 2010 in General
Hello I'm trying to make datables read from my database some tables but nothing will show up this is my code:
to be more specific I have 4 colums and I want the default sorting by be by level and reborns. Any help would be greatly appreciated. by the way these stats are showing from the table "Characters" maybe I have to set the table correctly?

[code]

$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 = "20";
if ( isset( $_GET['iDisplayStart'] ) )
{
$sLimit = "LIMIT ".mysql_real_escape_string( $_GET['iDisplayStart']

).", ".
mysql_real_escape_string( $_GET['iDisplayLength'] );
}

/* Ordering */
if ( isset( $_GET['iSortCol_0'] ) )
{
$sOrder = "ORDER BY reborns, level";
for ( $i=0 ; $i[/code]
This discussion has been closed.