pragmaMx Support Forum pragmaMx Support Forum

Schmankerl aus dem phpNuke-Code

0 Mitglieder und 1 Gast betrachten dieses Thema.

Offline Andi

  • *****
  • 18.832
  • +4/-0
  • Geschlecht: Männlich
Schmankerl aus dem phpNuke-Code
« am: 06 Januar 2003, 14:47:08 »
Das muss ich einfach mal loswerden. Betrifft modules/sections/index.php
Aus 3 DB-Abfragen$result = sql_query("select secname from ${prefix}_sections where secid=$secid", $dbi);
list($secname) = sql_fetch_row($result, $dbi);
$result = sql_query("select artid, secid, title, content, counter from ${prefix}_seccont where secid=$secid $querylang order by title", $dbi);
$result2 = sql_query("select image from ${prefix}_sections where secid=$secid", $dbi);
list($image) = sql_fetch_row($result2, $dbi);

Mache eine Abfrage:$qry = "SELECT ${prefix}_seccont.artid, ${prefix}_seccont.secid, ${prefix}_seccont.title, ${prefix}_seccont.content, ${prefix}_seccont.counter, ${prefix}_sections.secname, ${prefix}_sections.image
FROM ${prefix}_seccont LEFT JOIN ${prefix}_sections ON ${prefix}_seccont.secid = ${prefix}_sections.secid
WHERE ((${prefix}_seccont.secid=$secid)
$querylang
ORDER BY ${prefix}_seccont.title";
$result = sql_query($qry, $dbi);
schön´s Grüssle, Andi