okok meine funktion
function getContentCat($catid, $limit ,$domainu = "wert")
{
$db = DB::connect(getDSN("tom"));
$db->setFetchMode(DB_FETCHMODE_ASSOC);
if (DB::isError($db)) {
die ($db->getMessage());
}
if (!empty($catid)) {
if("xy.de"==$domainu){
echo "ok";
$sql = "SELECT web_obj2groups.objgrp, web_obj2groups.objnbr as id, web_groups.type, web_items.name as titel, web_items.preview
FROM web_obj2groups, web_groups, web_items
WHERE web_obj2groups.objgrp = web_groups.objgrp AND web_obj2groups.objgrp = " . $catid . "
AND web_items.objnbr = web_obj2groups.objnbr
AND SUBSTRING(web_items.objnbr,2,3) <> 10
AND web_items.preview <> 'noimage.gif'
GROUP BY web_obj2groups.objnbr ORDER BY web_obj2groups.priority DESC, web_items.name DESC LIMIT 0,".$limit;
}else{
$sql = "SELECT web_obj2groups.objgrp, web_obj2groups.objnbr as id, web_groups.type, web_items.name as titel, web_items.preview
FROM web_obj2groups, web_groups, web_items
WHERE web_obj2groups.objgrp = web_groups.objgrp AND web_obj2groups.objgrp = " . $catid . "
AND web_items.objnbr = web_obj2groups.objnbr
AND web_items.preview <> 'noimage.gif'
GROUP BY web_obj2groups.objnbr ORDER BY web_obj2groups.priority DESC, web_items.name DESC LIMIT 0,".$limit;
}
$res = $db->query($sql);
$result_array=array();
$i = 0;
while($fld = $res->fetchRow()) {
$result_array[]=array('id'=>$fld['id'],
'catid'=>$fld['objgrp'],
'mm_name'=>$fld['titel'], // for compatibility reasons, to be removed
'mm_name2'=>fixProductNameforURL($fld['titel']), // for compatibility reasons, to be removed
'name'=>$fld['titel'],
'name2'=>fixProductNameforURL($fld['titel']),
'image'=>$fld['preview'], // for compatibility reasons, to be removed
'preview'=>$fld['preview'],
'type'=>$fld['type']);
$i++;
}
}
return($result_array);
}
mein Aufruf
$domainu = "xy.de";
$front_vid = getContentCat($front_vid_id, $x, $domainu);