Battle Books sorted by AR Level

[insert_php]

global $wpdb;

$username = “dibbsolu_wpbob”;
$ARlow = 0.1;
$ARhigh = 12;

echo $stud_name;

// Create connection
$select_db = mysql_select_db(‘dibbsolu_wpbob’) or die (“cant get on it boy!”);

if ($select_db == true) {
echo “Connected successfully”;
}
echo “

“;

echo “Enter the AR level range: “;

$query = “SELECT * FROM junktable WHERE ((ARlevel >= $ARlow) and (ARlevel < $ARhigh)) ORDER BY ARlevel;"; $fetch = mysql_query($query) or die ("couldnt get on user"); echo "

“;

while($row = mysql_fetch_assoc($fetch)) {
echo “

“;
}

echo “

Book	Author	AR Level	AR Points
” .$row[‘book’].”	“. $row[‘author’].”	“. number_format($row[‘ARlevel’],1).”	“. $row[‘ARpoints’].”

“;
[/insert_php]