Need some help with sql query to display data

[cinq]

Stuck here , trying to code something.

Pls refer to the below code:

PHP Code:

if ($action=="viewarticle") {
$result2 = $DB_site->query("SELECT title, author, date, content FROM mytable_content WHERE artid=$artid");
  if ($row= mysql_fetch_row($result2)) { 
      
$title=$row[0];
$author=$row[1];
$date=$row[2];
$content=$row[3];

eval("dooutput(\"".gettemplate('myhack_viewart')."\");");
}
} 


I have a table which has fields : title, author, date and content and would like to display it by calling this action on the php file.

But i cant seem to display anything and am pretty sure my template ( myhack_viewart ) is as I want it to be.

Any help here pls ?


edit: doh just realised there's a PHP/mySql forum ... mods pls move this if needed , thanks.