prepare("select id from messages where user = '$name' and msg = '$message'");
$checksql->execute();
$i = 0;
while ($row = $checksql->fetch())
{
$i++;
}
if ($i < 1) {
$insposts = $dbh->prepare("insert into messages (user,msg,time) values ('$name','$message','$time')");
$insposts->execute();
}
}
$getposts = $dbh->prepare("select * from messages order by id desc limit 5");
$getposts->execute();
while ($row = $getposts->fetch()){
echo $row[1].'
'.$row[2].' on '.date('D h:i a',$row[3]).'
';
}
?>