SELECT
“ AS Film_Code,
f.Originaltitel AS Film_Title,
CONCAT(f.Originaltitel, IF(f.Titelzusatz “, CONCAT(‚ – ‚,
f.Titelzusatz), “)) AS German_Release_Title,
f.InternVertriebstitel AS US_Release_Title,
f.BeschreibungDE AS German_Release_Synopsis,
f.Hauptdarsteller AS Cast1_Name,
“ AS Cast2_Name,
“ AS Cast3_Name,
“ AS Cast4_Name,
f.Regisseur AS Director1_Name,
“ AS Director2_Name,
f.Produzent AS Producer1_Name,
“ AS Producer2_Name,
“ AS Producer3_Name,
“ AS Producer4_Name,
f.Drehbuch AS Screenwriter1_Name,
“ AS Screenwriter2_Name,
“ AS Screenwriter3_Name,
“ AS Screenwriter4_Name,
f.LaufzeitMin AS German_Running_Time,
“ AS German_Rating,
IFNULL(f.SchweizerVerleih, f.Weltvertrieb) AS German_Distributor,
“ AS German_Open_Date,
“ AS Genre,
“ AS Genre_2,
“ AS Genre_3
FROM tx_qcom_FilmDB_Filme f
INNER JOIN tx_qcom_FilmDB_Festivals fe
ON f.Festival = fe.id
WHERE
fe.Jahr = 2006
AND
fe.deleted = ‚0‘
AND
f.deleted = ‚0‘
AND
f.TeilnahmeBestaetigt = ‚1‘
ORDER BY f.Originaltitel ASC

• Rolf M sagt:

  7. April 2010 um 22:40 Uhr

  So einiges:
  – einen DB-Connect
  – die Query
  – und die Ausgabe
  Schaumal unter http://de3.php.net/manual/de/ref.mysql.php

• lese.rat sagt:

  8. April 2010 um 02:26 Uhr

  Erstelle eine Funktion in PHP wo du die DB connect und die eigentliche Abfrage integrierst. Dann kannst du bequem das SQL Statement per Parameter an die Funktion übergeben.