Есть 2 таблицы
http://joxi[dot]ru/gmveyXjFMYzbra
и
http://joxi[dot]ru/DmBEbY7ixeQorP
они связаны между собой.
Из них нужно сделать выборку с такой логикой
Из таблицы "Size" нужно выбрать `size_id`,`size_name` такие `id` которых нет в таблице "material_format" под определенным `id_density`. Делаю так.
PHP:
скопировать код в буфер обмена
function view_list_not_format($id_density_mat){
$result = $this->msql_select_static("
SELECT
size.`size_id`,
size.`size_name`
FROM
`size`,`material_format`
WHERE
size.`size_id` != material_format.`id_size`
AND
material_format.`id_density` = ".$id_density_mat."
");
return $result;
}
$id_density_mat - приходит idдля выборки
Но почему то не получается. Выводит вот
Array ( [0] => Array ( [size_id] => 1 [size_name] => 210x297 (A4) ) [1] => Array ( [size_id] => 1 [size_name] => 210x297 (A4) ) [2] => Array ( [size_id] => 1 [size_name] => 210x297 (A4) ) [3] => Array ( [size_id] => 2 [size_name] => 297x420 (A3) ) [4] => Array ( [size_id] => 2 [size_name] => 297x420 (A3) ) [5] => Array ( [size_id] => 2 [size_name] => 297x420 (A3) ) [6] => Array ( [size_id] => 2 [size_name] => 297x420 (A3) ) [7] => Array ( [size_id] => 3 [size_name] => 320x450 (SR A3) ) [8] => Array ( [size_id] => 3 [size_name] => 320x450 (SR A3) ) [9] => Array ( [size_id] => 3 [size_name] => 320x450 (SR A3) ) [10] => Array ( [size_id] => 4 [size_name] => 330x450 ) [11] => Array ( [size_id] => 4 [size_name] => 330x450 ) [12] => Array ( [size_id] => 4 [size_name] => 330x450 ) [13] => Array ( [size_id] => 5 [size_name] => 430x305 ) [14] => Array ( [size_id] => 5 [size_name] => 430x305 ) [15] => Array ( [size_id] => 5 [size_name] => 430x305 ) [16] => Array ( [size_id] => 5 [size_name] => 430x305 ) [17] => Array ( [size_id] => 6 [size_name] => 430x610 ) [18] => Array ( [size_id] => 6 [size_name] => 430x610 ) [19] => Array ( [size_id] => 6 [size_name] => 430x610 ) [20] => Array ( [size_id] => 6 [size_name] => 430x610 ) [21] => Array ( [size_id] => 7 [size_name] => 470x650 ) [22] => Array ( [size_id] => 7 [size_name] => 470x650 ) [23] => Array ( [size_id] => 7 [size_name] => 470x650 ) [24] => Array ( [size_id] => 7 [size_name] => 470x650 ) [25] => Array ( [size_id] => 8 [size_name] => 480x650 ) [26] => Array ( [size_id] => 8 [size_name] => 480x650 ) [27] => Array ( [size_id] => 8 [size_name] => 480x650 ) [28] => Array ( [size_id] => 8 [size_name] => 480x650 ) [29] => Array ( [size_id] => 9 [size_name] => 500x700 ) [30] => Array ( [size_id] => 9 [size_name] => 500x700 ) [31] => Array ( [size_id] => 9 [size_name] => 500x700 ) [32] => Array ( [size_id] => 9 [size_name] => 500x700 ) [33] => Array ( [size_id] => 10 [size_name] => 520x720 ) [34] => Array ( [size_id] => 10 [size_name] => 520x720 ) [35] => Array ( [size_id] => 10 [size_name] => 520x720 ) [36] => Array ( [size_id] => 10 [size_name] => 520x720 ) [37] => Array ( [size_id] => 11 [size_name] => 530x740 ) [38] => Array ( [size_id] => 11 [size_name] => 530x740 ) [39] => Array ( [size_id] => 11 [size_name] => 530x740 ) [40] => Array ( [size_id] => 11 [size_name] => 530x740 ) [41] => Array ( [size_id] => 12 [size_name] => 620x940 ) [42] => Array ( [size_id] => 12 [size_name] => 620x940 ) [43] => Array ( [size_id] => 12 [size_name] => 620x940 ) [44] => Array ( [size_id] => 12 [size_name] => 620x940 ) [45] => Array ( [size_id] => 13 [size_name] => 700x1000 ) [46] => Array ( [size_id] => 13 [size_name] => 700x1000 ) [47] => Array ( [size_id] => 13 [size_name] => 700x1000 ) [48] => Array ( [size_id] => 13 [size_name] => 700x1000 ) [49] => Array ( [size_id] => 14 [size_name] => 700x1020 ) [50] => Array ( [size_id] => 14 [size_name] => 700x1020 ) [51] => Array ( [size_id] => 14 [size_name] => 700x1020 ) [52] => Array ( [size_id] => 15 [size_name] => 720x1010 ) [53] => Array ( [size_id] => 15 [size_name] => 720x1010 ) [54] => Array ( [size_id] => 15 [size_name] => 720x1010 ) [55] => Array ( [size_id] => 15 [size_name] => 720x1010 ) [56] => Array ( [size_id] => 16 [size_name] => 720x1020 ) [57] => Array ( [size_id] => 16 [size_name] => 720x1020 ) [58] => Array ( [size_id] => 16 [size_name] => 720x1020 ) [59] => Array ( [size_id] => 16 [size_name] => 720x1020 ) [60] => Array ( [size_id] => 17 [size_name] => 720x1040 ) [61] => Array ( [size_id] => 17 [size_name] => 720x1040 ) [62] => Array ( [size_id] => 17 [size_name] => 720x1040 ) [63] => Array ( [size_id] => 17 [size_name] => 720x1040 ) [64] => Array ( [size_id] => 18 [size_name] => 720x1080 ) [65] => Array ( [size_id] => 18 [size_name] => 720x1080 ) [66] => Array ( [size_id] => 18 [size_name] => 720x1080 ) [67] => Array ( [size_id] => 18 [size_name] => 720x1080 ) [68] => Array ( [size_id] => 19 [size_name] => 780x1080 ) [69] => Array ( [size_id] => 19 [size_name] => 780x1080 ) [70] => Array ( [size_id] => 19 [size_name] => 780x1080 ) [71] => Array ( [size_id] => 19 [size_name] => 780x1080 ) [72] => Array ( [size_id] => 20 [size_name] => 920x640 ) [73] => Array ( [size_id] => 20 [size_name] => 920x640 ) [74] => Array ( [size_id] => 20 [size_name] => 920x640 ) [75] => Array ( [size_id] => 20 [size_name] => 920x640 ) [76] => Array ( [size_id] => 21 [size_name] => 940x650 ) [77] => Array ( [size_id] => 21 [size_name] => 940x650 ) [78] => Array ( [size_id] => 21 [size_name] => 940x650 ) [79] => Array ( [size_id] => 21 [size_name] => 940x650 ) [80] => Array ( [size_id] => 22 [size_name] => 1000x1400 ) [81] => Array ( [size_id] => 22 [size_name] => 1000x1400 ) [82] => Array ( [size_id] => 22 [size_name] => 1000x1400 ) [83] => Array ( [size_id] => 22 [size_name] => 1000x1400 ) [84] => Array ( [size_id] => 23 [size_name] => 1040x720 ) [85] => Array ( [size_id] => 23 [size_name] => 1040x720 ) [86] => Array ( [size_id] => 23 [size_name] => 1040x720 ) [87] => Array ( [size_id] => 23 [size_name] => 1040x720 ) )