if statement i select

prøv:

SELECT ...,IF(debate.subject IS NULL,party.title,debate.subject),... FROM ... WHERE ...

eller:

SELECT ...,IFNULL(debate.subject,party.title),... FROM ... WHERE ...

jeg synes ikke rigtig at det virker?

feltet er som sådan ikke NULL... men det er bare ==''

virker heller ikke..

IF(debate.subject='', party.title, debate.subject)

jeg får ingen fejl, der bliver bare ikke hentet noget data som subject

$sql = "SELECT debate.user_id, debate.time, party.id AS party_id, party.time_cancel, party.time_end, IF(debate.subject='', party.title, debate.subject), user.name, debate_attrib.att_lock, debate_attrib.att_stick, COUNT(debate2.thread_id)-1 AS replies
                FROM ((($DB.debate debate
                    LEFT JOIN $DB.user user ON debate.user_id=user.id)
                    LEFT JOIN $DB.debate debate2 ON debate.id=debate2.thread_id)
                    LEFT JOIN $DB.party party ON debate.id=party.thread_id)
                LEFT JOIN $DB.debate_attrib debate_attrib ON debate.id=debate_attrib.thread_id
                WHERE debate.id='$value'
                GROUP BY debate.id";

lukker