zero-perfoliate
zero-perfoliate

Author Topic: LEFT JOIN data listing  (Read 291 times)

Offline Goldie_

  • New PHP Members
  • Posts: 2
  • Karma: +0/-0
LEFT JOIN data listing
« on: April 14, 2010, 04:08:10 PM »
I have 2 mysql tables
table "content" with rows "id" and "title"
and table "files" with rows "filename" and "content"

I wanted the PHP to create a list of titles from the "content" table, and that, under each title, list of filenames from table "files", if their "content" is the same number from the id number of a "title".
Like this:

title1
- filename1
- filename2
- filename3
title2
- filename4
- filename5

I used LEFT JOIN and this function

Code: [Select]
$arr_results = array();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    $arr_results[$row['title']][]=$row['filename'];
stringovi koji ce predstavljati filename-ove
}

foreach($arr_results as $title=>$filenames)
{
    echo $title.'<br>';
   
    foreach($filenames as $filename)
    {
        echo '-'.$filename.'<br>';
    }   
}

recently I added "date" row into "files" table and now I need result like this
title1
- filename1 - date1
- filename2 - date2
- filename3 - date3
title2
- filename4 - date4
- filename5 - date5

Can somebody help me? Where and how should I insert "date" row into this function to get all work properly?