[williamh26]

Hi guys i have this two tables:
Topic Table

PHP Code:

topic_id     int(10)     AUTO_INCREMENT  Primary     

sub_id             int(10)                 

topic     varchar(255) 

Problem Table

PHP Code:

problem_id     int(10)     AUTO_INCREMENT  Primary     

topic_id             int(10)                 

problem     varchar(255) 

I want retrieve the problems that are related with in the topic table this way

PHP Code:

<?php

 login();

         $topic_id = $_GET['cat'];

         $query="SELECT  problem_id, problem from problems WHERE topic_id=$topic_id";

         $result=mysql_query($query);

         while($row=mysql_fetch_array($result,MYSQL_ASSOC))

         {



                  $problem_id = $row['problem_id'];

                  $problem = $row['problem'];



             echo "<h3><a href=\"index.php?content=answers&cat=$topic_id\">$problem</a></h3><br>\n";

         }

?>

it returns the same problems in every topic... how I fix that??

PHP Code:

http://localhost/study.com/index.php?content=problems&cat=1 

The problem cat = 1 is returned in every topic