08. november 2008 - 20:56Der er
4 kommentarer og 1 løsning
Hjælp til ORDER BY
Hej alle.
Hvordan får jeg følgende kode til at sortere efter runja_rundown.pos?
"SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_eng_sot.id AS id,runja_eng_sot.beskrivelse AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_eng_sot ON runja_eng_sot.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND (runja_rundown.id_type='1' OR runja_rundown.id_type='2') UNION ALL SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_vo_tlg.id AS id,runja_vo_tlg.beskrivelse AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_vo_tlg ON runja_vo_tlg.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND (runja_rundown.id_type='3' OR runja_rundown.id_type='4') UNION ALL SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_jin.id AS id,runja_jin.filnavn AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_jin ON runja_jin.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND runja_rundown.id_type='6'"
I dette særtema om aspekter af AI ser vi på skiftet fra sprogmodeller til AI-agenter, og hvordan virksomheder kan navigere i spændet mellem teknologisk hastighed og behovet for menneskelig kontrol.
"SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_eng_sot.id AS id,runja_eng_sot.beskrivelse AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_eng_sot ON runja_eng_sot.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND (runja_rundown.id_type='1' OR runja_rundown.id_type='2') UNION ALL SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_vo_tlg.id AS id,runja_vo_tlg.beskrivelse AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_vo_tlg ON runja_vo_tlg.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND (runja_rundown.id_type='3' OR runja_rundown.id_type='4') UNION ALL SELECT runja_rundown.id_type AS type,runja_rundown.pos,runja_rundown.id_live,runja_live.type,runja_live.oplaeg AS oplaeg,runja_live.nedlaeg AS nedlaeg,runja_jin.id AS id,runja_jin.filnavn AS beskrivelse FROM runja_rundown INNER JOIN runja_live ON runja_rundown.id_live=runja_live.id INNER JOIN runja_jin ON runja_jin.id=runja_rundown.id_element WHERE runja_rundown.id_orders='$order_id' AND runja_rundown.id_type='6' ORDER BY runja_rundown.pos"
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
