Три способа выборки из mysql

$link = mysql_connect($host, $user, $pass) or die("Could not connect: " . mysql_error());
$db_selected = mysql_select_db($base, $link);
$query = "SELECT * FROM `as_items` LIMIT 0, 100";
$res = mysql_query($query);
while ($row = mysql_fetch_array($res)) {
print_r($row);
}
mysql_close($link);

$link = mysqli_connect($host,$user,$pass,$base) or die("Error " . mysqli_error($link));
$query = "SELECT * FROM `as_items` LIMIT 0, 100" or die("Error in the consult.." . mysqli_error($link));
$result = mysqli_query($link, $query);
while($row = mysqli_fetch_array($result)) { 
 print_r($row);
} 

$dbh = new PDO('mysql:host='.$host.';dbname='.$base.'', $user, $pass);
foreach($dbh->query('SELECT * FROM `as_items` LIMIT 0, 100') AS $row) {
 print_r($row);
 }