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
$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?
