[PHP] pobierz, plaintext 
<?php
$stmt=$PDO->query("SELECT * FROM (SELECT logs.id, logs.log, logs.when, users.nick FROM `logs` LEFT JOIN `users` ON logs.numer=users.numer ORDER BY `id` DESC LIMIT 30) AS logi ORDER BY logi.id;");  
while($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
 if (count($row)==0) die('Brak logów!!');
 echo '[id:'.$row['id'].'] <'.$row['nick'].'> '.date_format(date_create_from_format('Y-m-d H:i:s', $row['when']), 'd/m/Y [H:i:s]')."\r\n".$row['log']."\r\n\r\n";
}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
foreach($row as $k=>$v){
if(empty($v)) die('puste '.$k);
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$stmt = $pdo->prepare(...);
$stmt->execute();
 
$rs = $stmt->fetchAll();
 
if (count($rs) === 0) {
  echo 'zapytanie nie zwróciło żadnych rekordów';
} else {
  foreach ($rs as $row) {
    ...
  }
}
[PHP] pobierz, plaintext