[PHP/MYSQL]Not Working ~ News System[PHP/MYSQL]

[Li1M0ST3Rz]

Okay i coded a news system:

        <?php
        include './lib/config.php';
        $_result = mysql_query("SELECT * FROM news");
        while($news = mysql_fetch_array($_result))
        $id = $news['id'];
        {
            if(isset($_GET['id='.$id.'']))
                {
                    $_resulted = mysql_query("SELECT * FROM news WHERE id=".$id."");
                    while($n_news = mysql_fetch_array($_resulted))
                        {
                            echo 'Topic: '. $n_news['topic'] .' <p>'.$n_news['body'].'</p> <p>Author: '.$n_news['author'].'</p>';
                        }
                }
        }
        ?>

and it given me this and the news database filled with an table:

 

[Ept]

<?php
        include './lib/config.php';
        $_result = mysql_query("SELECT * FROM news");
        while($news = mysql_fetch_array($_result))
        {
          $id = $news['id'];
            if(isset($_GET['.$id.']))
                {
                    $_resulted = mysql_query("SELECT * FROM news WHERE id=".$id."");
                    while($n_news = mysql_fetch_array($_resulted))
                        {
                            echo 'Topic: '. $n_news['topic'] .' <p>'.$n_news['body'].'</p> <p>Author: '.$n_news['author'].'</p>';
                        }
                }
        }
        ?>

Try that, it should work.

 

[Ecko]

if(isset($_GET['id'']))

 

[Li1M0ST3Rz]

<?php
        include './lib/config.php';
        $_result = mysql_query("SELECT * FROM news");
        while($news = mysql_fetch_array($_result))
        {
          $id = $news['id'];
            if(isset($_GET['.$id.']))
                {
                    $_resulted = mysql_query("SELECT * FROM news WHERE id=".$id."");
                    while($n_news = mysql_fetch_array($_resulted))
                        {
                            echo 'Topic: '. $n_news['topic'] .' <p>'.$n_news['body'].'</p> <p>Author: '.$n_news['author'].'</p>';
                        }
                }
        }
        ?>

Try that, it should work.

Still dont work..

 

[Sean]

<?php
      include "../lib/config.php";
      $result = mysql_query("SELECT * FROM news");
      while($news = mysql_fetch_array($result)) {
          $id = $news['id'];
          if(isset($_GET[' " .  $id . "'])) {
              $resulted = mysql_query("SELECT * FROM news WHERE id='" . $id . "'");
              while($news = mysql_fetch_array($resulted)) {
                  echo 'Topic: '. $news['topic'] .' <p>'.$news['body'].'</p> <p>Author: '.$news['author'].'</p>';
              }
          }
      }
?>

 

[Li1M0ST3Rz]

<?php
      include "../lib/config.php";
      $result = mysql_query("SELECT * FROM news");
      while($news = mysql_fetch_array($result)) {
          $id = $news['id'];
          if(isset($_GET[' " .  $id . "'])) {
              $resulted = mysql_query("SELECT * FROM news WHERE id='" . $id . "'");
              while($news = mysql_fetch_array($resulted)) {
                  echo 'Topic: '. $news['topic'] .' <p>'.$news['body'].'</p> <p>Author: '.$news['author'].'</p>';
              }
          }
      }
?>

not working to thanks for helping.

 

[Sean]

Can you post your config.php please

 

[Li1M0ST3Rz]

<?php
#################################
# ==    Mysql connection  ==  #
#################################
 
mysql_connect("localhost", "root", "Lol123") or die(mysql_error());
mysql_select_db("supreme") or  die('<div class="msgError">Connection couldnt connect wow fix it!.</div>');
//////////////////////////////////
//    ==        Site Config        == //
////////////////////////////////
$_site['lname'] = 'SupremeCMS';
$_site['sname'] = 'Supreme';
$_site['copyright'] = 'Copyright &copy; 2012';
$_site['version'] = '1.0';
 
?>

 

[Ryabs]

Okay i coded a news system:

        <?php
        include './lib/config.php';
        $_result = mysql_query("SELECT * FROM news");
        while($news = mysql_fetch_array($_result))
        $id = $news['id'];
        {
            if(isset($_GET['id='.$id.'']))
                {
                    $_resulted = mysql_query("SELECT * FROM news WHERE id=".$id."");
                    while($n_news = mysql_fetch_array($_resulted))
                        {
                            echo 'Topic: '. $n_news['topic'] .' <p>'.$n_news['body'].'</p> <p>Author: '.$n_news['author'].'</p>';
                        }
                }
        }
        ?>

and it given me this and the news database filled with an table:

Thought you were great at coding?

 

[Weasel]

        <?php
        include ('./lib/config.php');
        $result = mysql_query("SELECT * FROM news");
        $id = $_GET['id'];
        while($news = mysql_fetch_array($_result))
        {
            if(isset($id))
                {
                    $_resulted = mysql_query("SELECT * FROM news WHERE id='.$id.'");
                    while($n_news = mysql_fetch_array($_resulted))
                        {
                            echo 'Topic: ". $n_news['topic'] ." <p>".$n_news['body']."</p> <p>Author: ".$n_news['author']."</p>';
                        }
                }
        }
        ?>

 

[Li1M0ST3Rz]

Thought you were great at coding?

this is stupid and not showing

 

[Sean]

<?php
    require_once('../lib/config.php');
    if (isset($_GET["id"])) { $article  = $_GET["id"]; } else { $article=1; };
    $start = ($article-1) * 1;
    $sql = "SELECT * FROM news ORDER BY id ASC LIMIT $start, 1";
    $result = mysql_query($sql);
    while ($row = mysql_fetch_assoc($result)) {
        echo 'Topic: '. $row['topic'] .' <p>'.$row['body'].'</p> <p>Author: '.$row['author'].'</p>';
    }
?>

 

[Li1M0ST3Rz]

<?php
    require_once('../lib/config.php');
    if (isset($_GET["id"])) { $article  = $_GET["id"]; } else { $article=1; };
    $start = ($article-1) * 1;
    $sql = "SELECT * FROM news ORDER BY id ASC LIMIT $start, 1";
    $result = mysql_query($sql);
    while ($row = mysql_fetch_assoc($result)) {
        echo 'Topic: '. $row['topic'] .' <p>'.$row['body'].'</p> <p>Author: '.$row['author'].'</p>';
    }
?>

it worked thanks

 

[Sean]

it worked thanks

You're Welcome