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.

[Xenon]

use this code:

PHP Code:

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

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


[cinq]

Thanks for the quick reply Xenon,
works like a charm

[Xenon]

you're welcome