REDAXO Forum

Code: Alles auswählen

$sql = 'SELECT
eventId as id,eventName,shortdesc,DATE_FORMAT(dateStart,"%d.%m.%Y") as eventDateStart,DATE_FORMAT(dateEnd,"%d.%m.%Y") as eventDateEnd,c.categoryName,v.venueName

FROM '.$REX['TABLE_PREFIX'].'423_events as e

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_venues as v
ON (e.rVenue = v.venueId)

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_categories as c
ON (e.rCategory = c.catId)

ORDER BY '.$REX['TABLE_PREFIX'].'423_events.dateStart

;

Code: Alles auswählen

$sql = 'SELECT
eventId as id,eventName,shortdesc,DATE_FORMAT(dateStart,"%d.%m.%Y") as eventDateStart,DATE_FORMAT(dateEnd,"%d.%m.%Y") as eventDateEnd,c.categoryName,v.venueName

FROM '.$REX['TABLE_PREFIX'].'423_events as e

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_venues as v
ON (e.rVenue = v.venueId)

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_categories as c
ON (e.rCategory = c.catId)

ORDER BY '.$REX['TABLE_PREFIX'].'423_events.dateStart DESC

'; /*  hier hat was gefehlt */

Code: Alles auswählen

$sql = 'SELECT
eventId as id,eventName,shortdesc,DATE_FORMAT(dateStart,"%d.%m.%Y") as eventDateStart,DATE_FORMAT(dateEnd,"%d.%m.%Y") as eventDateEnd,c.categoryName,v.venueName

FROM '.$REX['TABLE_PREFIX'].'423_events as e

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_venues as v
ON (e.rVenue = v.venueId)

LEFT JOIN '.$REX['TABLE_PREFIX'].'423_categories as c
ON (e.rCategory = c.catId)

ORDER BY e.dateStart DESC

';