categories and id (2 tables)

[d-machine]

Hi

I have 2 tables, which were created in order to save stories in categories:

stories:
1) story_id
2) story_category (works as category id)


stories_categories :
1) story_categoryname
2) story_category (works also as category id)

I've tried to print the information in this way:

story_categoryname:
1) story_id
2) story_id
3)story_id

other story_categoryname:
1) story_id
2) story_id

if some category is empty and doesn't have stories it won't be printed.

this the code I've tried and didn't get where I went wrong:



$query1 = "select distinct story_categoryname from stories_categories";
$res1 = mysql_query($query1);
if($res1){
while($cat = mysql_fetch_assoc($res1)){
echo $cat['story_categoryname']."<br/>";
$query2 = "select story_id from stories where story_category in (select story_category from stories_categories where story_categoryname = '".$cat['story_categoryname']."')";
$res2 = mysql_query($query2);
if($res2){
while($story_id = mysql_fetch_assoc($res2)){
echo $story['$story_id'].'<br/>';
}
}
}
}else{
print mysql_error();
}



Thank you

[motormichael12]

You could try modifying this (given to you in another topic)

$result = mysql_query("SELECT mytable1.name, mytable1.lastname, mytable2.shirtcolor FROM mytable1, mytable2
WHERE mytable1.lastname = mytable2.lastname") or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>name</th> <th>lastname</th> <th>shirtcolor</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['mytable1.name'];
echo "</td><td>";
echo $row['mytable1.lastname'];
echo "</td><td>";
echo $row['mytable2.shirtcolor'];
echo "</td></tr>";
}

echo "</table>";

[d-machine]

Thank you