<?
require('../members/inc/config.php');
require('../lib/framework.php');

// load the configuration file.
$newsid = $_GET['ID'];

$stmt = $db->query("SELECT * FROM news ORDER BY id = '$newsid' ");
while($myrow = $stmt->fetch(PDO::FETCH_ASSOC)) {

               //now print the results:
               echo "<b>Title: ";
               echo $myrow['Title'];
               echo "</b><br>On: <i>";
               echo $myrow['Date'];
               echo $myrow['Embed'];
               echo "</i><hr align=left width=160>";
               echo $myrow['Hour'];

               // Now print the options to (Read,Edit & Delete the news)
               echo "<br><a href="testonho.php?newsid=$myrow[ID]">Read More...</a>
                || <a href="edit_news.php?newsid=$myrow[ID]">Edit</a>
                 || <a href="delete_news.php?newsid=$myrow[ID]">Delete</a><br><hr>";

             }//end of loop

?>

$stmt = $db->query("SELECT * FROM news WHERE id = '$newsid' ORDER BY id");

$sql = 'SELECT * FROM news ';

 if(!empty($newsid){// caso tenha um id exibe somente ele
    $sql .= ' WHERE id = ? ORDER BY id';
 }

$stmt = $db->prepare($sql);
$stmt->execute(array($newsid)); // aqui faz o bind da interrogação com $newsid
$itens = $stmt->fetchAll(PDO::FETCH_ASSOC); //retorna todas as linhas de uma vez.

foreach($itens as $myrow){
   echo ....
}

$newsid = $_GET['newsid'];

echo "<br><a href="testonho.php?newsid={$myrow['ID']}">Read More...</a>
            || <a href="edit_news.php?newsid={$myrow['ID']}">Edit</a>
             || <a href="delete_news.php?newsid={$myrow['ID']}">Delete</a><br><hr>";

$newsid = $_GET['newsid'];