Grazie mille per la chiarificazione, ma purtroppo la query proposta era un esempio.. Invece sulla query reale la cosa si complica e inserendo quel parametro mi svuota il recordset:
codice:
SELECT a.*, a.introtext as text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM #__content AS a INNER JOIN #__categories AS cc ON cc.id = a.catid INNER JOIN #__sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-01 15:33:45' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-01 15:33:45' ) AND s.id > 0 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (cc.id=41) AND (s.id=5) AND s.published = 1 AND cc.published = 1 ORDER BY if(id = 87,1,2), a.ordering ASC
Ps= ho messo 87 io per provare.. Un record con id 87 esiste. Ho controllato manualmente su phpmyadmin.
Come mai mi svuota il recordset secondo te?