[PHP] Catagory list

[Mark Bayfield]

I am trying to make a catagory list that displays a distinct catagory, and
then listing titles under that catagory.
Unfortunatly all the data is in one table, and the catagory field is not set
catagories, so there is duplicates in that field.
The code so far is (but I am probably going about it the wrong way, if you
can see whats wrong with my code plase help, or point me in some direction),

 $query = mysql_query("SELECT DISTINCT catagory from article order by
catagory");
 $query2 = mysql_query ("SELECT * from article ORDER BY catagory");

 for ($index = 0; $index < mysql_num_rows($query); $index++) {
  $Catagory = mysql_fetch_row ($query) or die (mysql_error());
  $name1 =  mysql_fetch_row ($query2) or die (mysql_error());
  $x = $name1;
  $result1 = array_unique($Catagory);
  $result = array_merge($Catagory, $name1);

   print ("$result1[0]<BR>");
   for ($x=0; $x == $result1[0]; $x++) {
   print ("&nbsp;&nbsp;&nbsp;&nbsp;<a
href='update.php?passed=$name1[0]'>$name1[2]</a><br>\n");
   }
     }

I am trying everything to get it do just print the following:

Catagory
    title1
    title2
Catagory1
    title3
    title4

Please help me out....

thanks



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]