PHP Code:
<?php
<!-- include your db configurations here -->
if( $connect === false )
{
echo "Could not connect.";
die( print_r( sqlsrv_errors(), true));
}
$select = "SELECT TOP(10)name, lv, job, pkc, dkc, exp, jlv, sex, play_time FROM Character WHERE lv > 0 AND permission = '0' AND lv < 181 AND name NOT LIKE '%@%' ORDER BY name ASC";
$query = sqlsrv_query( $connect, $select);
if ( $query )
{
}
else
{
echo "Error in statement execution.";
die( print_r( sqlsrv_errors(), true));
}
$counter = 1;
while( $row = sqlsrv_fetch_array( $query, SQLSRV_FETCH_NUMERIC))
{
<!-- echo the resultse -->
$counter++;
}
sqlsrv_free_stmt( $query);
sqlsrv_close( $connect);
?>