Need some help with sql query to display data

[cinq]

Stuck here , trying to code something.

Pls refer to the below 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:

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