Woopser
05.12.2006, 17:07
Hallo,
habe hier ein Code was mit OS Shop arbeitet und Daten aus der Datenbank ausliest. Könnte sich das mla Bitte einer anschauen und das evetuell für XTC umschreiben, stehe da ein bißchen auf dem Schlauch.
if (!$id) $id = 0;
$abfrage = "SELECT products_id,products_name,products_description FROM products_description,products_image FROM products,products_to_categories PTC,categories C WHERE PTC.products_id = P.products_id AND PTC.categories_id = C.categories_id AND P.products_status = '1' AND P.products_id > $id ORDER BY P.products_id";
$erg = mysql_db_query("usr_web18_1",$abfrage,$verbindung);
unset($nextid);
while (list($products_id,$products_name,$products_descri ption,$products_image,$categories_id,$categories_n ame) = mysql_fetch_row($erg)) {
****$nextid = $products_id;
****$products_description = nl2br($products_description);
****$products_name = trim($products_name);
****$keywords = autokeywords("$products_name $products_name $products_name $products_name $categories_name $categories_name $categories_name $categories_name $products_description",35);
****$zusatz_keywords = ereg_replace(",","",autokeywords("$products_name $products_name $products_name $products_name $categories_name $categories_name $categories_name $categories_name $products_description",6));
****$url_p1 = killzeugs($products_name);
BIG THX
habe hier ein Code was mit OS Shop arbeitet und Daten aus der Datenbank ausliest. Könnte sich das mla Bitte einer anschauen und das evetuell für XTC umschreiben, stehe da ein bißchen auf dem Schlauch.
if (!$id) $id = 0;
$abfrage = "SELECT products_id,products_name,products_description FROM products_description,products_image FROM products,products_to_categories PTC,categories C WHERE PTC.products_id = P.products_id AND PTC.categories_id = C.categories_id AND P.products_status = '1' AND P.products_id > $id ORDER BY P.products_id";
$erg = mysql_db_query("usr_web18_1",$abfrage,$verbindung);
unset($nextid);
while (list($products_id,$products_name,$products_descri ption,$products_image,$categories_id,$categories_n ame) = mysql_fetch_row($erg)) {
****$nextid = $products_id;
****$products_description = nl2br($products_description);
****$products_name = trim($products_name);
****$keywords = autokeywords("$products_name $products_name $products_name $products_name $categories_name $categories_name $categories_name $categories_name $products_description",35);
****$zusatz_keywords = ereg_replace(",","",autokeywords("$products_name $products_name $products_name $products_name $categories_name $categories_name $categories_name $categories_name $products_description",6));
****$url_p1 = killzeugs($products_name);
BIG THX