At first this worked like a charm, but then I made a abstraction layer and now it wont work. It only displays the first result.
function NEWSGET(){
if(!defined('HOME') && (!isset($_GET['comments']))){
global $db, $vp_e, $vp_options, $prefix, $language;
include("templates/".$vp_options['template']."/news_top_temp.txt");
if(!isset($_GET['page'])){
$page = 1;
}else{
$page = $_GET['page'];
}
$from = (($page * $vp_options['displaylimit']) - $vp_options['displaylimit']);
$newsget = "SELECT * FROM ".$prefix['newsprefix']." ORDER BY id desc LIMIT $from, ".$vp_options['displaylimit'];
$query = $db->query($newsget) or $vp_e->F_ERROR('SELECT Error', $newsget, __LINE__, __FILE__);
while($r=$db->fetch_assoc($query))
{
$id = $r["id"];
$n_u_id = $r["n_u_id"];
$n_cat_id = $r["n_cat_id"];
$articlename = $r["articlename"];
$message = $r["message"];
$time = $r["time"];
$keywords = $r["keywords"];
$categoryget = "SELECT * FROM ".$prefix['categoryprefix']." WHERE cat_id='$n_cat_id'";
$resultcatnews = $db->query($categoryget) or $vp_e->F_ERROR('SELECT Error', $categoryget, __LINE__, __FILE__);
while($r=$db->fetch_assoc($resultcatnews))
{
$cat_id=$r["cat_id"];
$cat_name=$r["cat_name"];
$cat_pic=$r["cat_pic"];
}
$authorget = "SELECT * FROM ".$prefix['userprefix']." WHERE id='$n_u_id'";
$resultauthor = $db->query($authorget) or $vp_e->F_ERROR('SELECT Error', $authorget, __LINE__, __FILE__);
while($r=$db->fetch_assoc($resultauthor))
{
$id = $r["id"];
$username = $r["userid"];
$fullname = $r["fullname"];
$avatar = $r["avatar"];
$emailaddress = $r["emailaddress"];
}
include("templates/".$vp_options['template']."/news_temp.txt");
}
}
$db->free();
}
Abstraction functions used.
function query($query){
$this->result = mysql_query($query);
$this->counter++;
return($this->result);
}
function fetch_assoc(){
$array = mysql_fetch_assoc($this->result);
return($array);
}
Hope somebody can help me.
