[SOLVED] where am i going wrong???

[joshgarrod]

i have two scripts, the first displays a list of article names generated from a table, the user would then click a link, and depending on which link they click, the script is supposed to use the id number on the next script on the viewArticle page and draw that information from the table and display it. but i keep getting this file does not exist. where am i going wrong please?

 

Article list:

<?php
$con = mysql_connect("localhost","fghm1","ixfgdmghm");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("bncvm", $con);


   $query = "SELECT * FROM `Animals` ORDER BY `ID`";

        $result = mysql_query($query);

$num=mysql_num_rows($result);
$i=0;


while ($i < $num) {
$ArtID=mysql_result($result,$i,"ID");
$Article=mysql_result($result,$i,"Article");
$url="index.php?page=";

echo '<tr><td width=5></td><td align=center><a href="index.php?page=viewArticle">'.$Article.'</a></td></tr>';

++$i;
}
?>

 

View article script

<?php
$con = mysql_connect("localhost","fghjhk","ifghkhjk8");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("sfsgh", $con);

$page = $_GET['ID']; // This will be the ID of the page
$page = mysql_real_escape_string(strip_tags($page));

  $query = mysql_query("SELECT * FROM Animals WHERE `ID` = '$page'");

   if(mysql_num_rows($query)==0){

    die("Sorry, but that page does not exists $row");

      }else{
         
        while($row = mysql_fetch_array($query)){

          echo $row['Article'] . "<br>";
          echo $row['Text'] . "<br>";
             
          }
             
     }

?>

[revraz]

You don't seem to be setting the ID in your URL

 

echo '<tr><td width=5></td><td align=center><a href="index.php?page=viewArticle">'.$Article.'</a></td></tr>';

 

[joshgarrod]

how do u mean

 

[revraz]

Where do you GET this from?

 

$page = $_GET['ID']; // This will be the ID of the page

 

[joshgarrod]

im not sure, someone was helping me earlier but is offline now. do you see what i want to do?

[PHP Monkeh]

Modify this line:

 

echo '<tr><td width=5></td><td align=center><a href="index.php?page=viewArticle">'.$Article.'</a></td></tr>';

 

to be:

 

echo '<tr><td width=5></td><td align=center><a href="index.php?page=viewArticle&ID=$ArtID">'.$Article.'</a></td></tr>';

 

that's on the article list page.

[joshgarrod]

it still says the page doesnt exists?

[revraz]

Is the ID blank when you hover over the link?

 

echo "<tr><td width=5></td><td align=center><a href='index.php?page=viewArticle&ID=$ArtID'>$Article</a></td></tr>";

[PHP Monkeh]

Does your switch/if statement have a condition for page = viewArticle?  Or are you just including $_GET['page'].php

[joshgarrod]

the link just looks like this 'http://www.mysite.co.uk/info/index.php?page=viewArticle&ID=$ArtID'

 

i am not too sure what is going on it, someone was helping me earlier and has gone offline, sorry

[revraz]

Use the code I posted above instead, it needs to be surrounded by double quotes and not single ones.

[joshgarrod]

brilliant guys, thanks v muc for your help. works fine now, thanks