[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
[an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]![]() |
![]() |
![]() |
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||||
![]() |
![]() |
![]() |
Okay, dead end!
/Nis
Guldægget, hvis nogle skulle være interesseret:
(
SELECT pretype_id FROM table1 WHERE pretype_id IS NOT NULL AND type_id =1 AND users_uid =1 ) ) ) ORDER BY table2.type_number )
Burde måske lige tilføje, at jeg skal bruge alle datasæt fra tabel1 og i tilfælde af et pretype_id skal det datasæt der matcher pretype_id fra table2 linkes sammen med tid fra table1. Men alle datasæt fra table2 som ikke er linket ind i table1, skal også med...
Har kastet mig over noget CASE WHEN THEN med en UNION til sidst for at få table2 med...
Og hvorfor spørger nogen. Fordi jeg ellers kommer ud i noget med 3 gange connect + query med tilhørende 3 gange PHP kode!
MySQL er stadig noget hurtigere til at afvikle det end med PHP flettet ind i!
/Nis
![]() |
![]() |
![]() |
||||||||||||
|
||||||||||||||
![]() | ||||||||||||||
|
||||||||||||||
![]() |
![]() |
![]() |