使用PHP在新站点上显示MySQL的记录？ [关闭]

Question

I want to fetch a news (record) from mysql and display in my site using PHP. Here is my code(PHP):

<?php
    include ("header.php");
    mysql_connect ("localhost", "root", "") or die (mysql_error());
    mysql_select_db ("geek-art") or die (mysql_error());
    $newsy = mysql_query ("SELECT * FROM newsy order by id desc");

    // With this WHILE loop, I want to display all of my news :)

    while ($rekord = mysql_fetch_array ($newsy)) {

        $id = $rekord['id'];
        $tytul = $rekord['tytul'];
        $tresc = $rekord['tresc'];
        $autor = $rekord['autor'];
        $data = $rekord['data'];
        $obrazek = $rekord['obr-news'];

        echo '<div class="artykul">';
            echo "<h2><a href=\"index.php?news=$id\">".$tytul.'</a></h2>';
            echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
            echo '<p>'.nl2br($tresc).'</p>';
        echo '</div>';
    }

    // With this WHILE loop, I want to display my news :)

    $newsy_osobne = mysql_query("SELECT * FROM newsy where id=".(int)@$_GET['news']."");
    while($rekordy_osobne = mysql_fetch_array($newsy_osobne)){
        if(isset($_GET['news'])){
            $id = $rekordy_osobne['id'];        
            $tytul = $rekordy_osobne['tytul'];
            $tresc = $rekordy_osobne['tresc'];
            $autor = $rekordy_osobne['autor'];
            $data = $rekordy_osobne['data'];

            echo '<div class="artykul">';
                echo "<h2>".$tytul.'</a></h2>';
                echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
                echo '<p>'.nl2br($tresc).'</p>';
            echo '</div>';
        }else{
            echo 'Nie znaleziono takiego newsa.';
        }
    }
    include ("footer.php");
?>

And I have done a short Video, where I show, what exactly is my problem :)

Answer 1

try this, I've just changed your query limit to 1 if your id is not primary key than it is possibile that multiple records are returned so this will reduce it to one.

// With this WHILE loop, I want to display my news :)

    $newsy_osobne = mysql_query("SELECT * FROM newsy where id='".$_GET['news']."' order by id desc limit 1");
    while($rekordy_osobne = mysql_fetch_array($newsy_osobne)){
        if(isset($_GET['news'])){
            $id = $rekordy_osobne['id'];        
            $tytul = $rekordy_osobne['tytul'];
            $tresc = $rekordy_osobne['tresc'];
            $autor = $rekordy_osobne['autor'];
            $data = $rekordy_osobne['data'];

            echo '<div class="artykul">';
                echo "<h2>".$tytul.'</a></h2>';
                echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
                echo '<p>'.nl2br($tresc).'</p>';
            echo '</div>';
        }else{
            echo 'Nie znaleziono takiego newsa.';
        }
    }