Categories and multi-categories

[Punktured]

ok, well, you know how to add "date added" so i will show code just to add category.
there is 2 lines which need replaced, and replaced with extra code.


line 1 , replace:

Code:

$data=$data.'<td  valign="top"><a  href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';

with this:

Code:

$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
  {
$category = $row3['category'];
}
$data=$data.'<td  valign="top"><a  href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';

line 2 , replace:

Code:

$data=$data.'<td  valign="top"><a  href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';

with this:

Code:

$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
  {
$category = $row3['category'];
}
$data=$data.'<td  valign="top"><a  href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';