[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: сохранить сортировку при использовании IN
Kusss
Входящий массив
Array
(
[0] => 46
[1] => 45
[2] => 63
)


$sql = "
SELECT
id, no_print, img, to_widht, to_height, print_width, print_height,
points_down_width, points_down_height
FROM
`print_basic_add`
WHERE
basic_id = 0 AND
id IN ("
.implode(',', $array['basic_id']).")
"
;

как сохранить сортировку входящего массива ?

На выходе
Array
(
[45] => Array
(
[id] => 45
[no_print] => 0
[img] => 2-women-t-shirt_1.jpg
[to_widht] => 283
[to_height] => 228
[print_width] => 296
[print_height] => 441
[points_down_width] => 14
[points_down_height] => 31
)

[46] => Array
(
[id] => 46
[no_print] => 0
[img] => 2-women-t-shirt_2.jpg
[to_widht] => 354
[to_height] => 113
[print_width] => 174
[print_height] => 258
[points_down_width] => 9
[points_down_height] => 19
)

[63] => Array
(
[id] => 63
[no_print] => 1
[img] => f9hr24y6A3.jpg
[to_widht] => 218
[to_height] => 327
[print_width] => 437
[print_height] => 655
[points_down_width] => 0
[points_down_height] => 0
)

)
Игорь_Vasinsky

$sql = "
SELECT
id, no_print, img, to_widht, to_height, print_width, print_height,
points_down_width, points_down_height
FROM
`print_basic_add`
WHERE
basic_id = 0 AND
id IN ("
.implode(',', $array['basic_id']).")
ORDER BY FIELD(id, "
.implode(",",$array['basic_id']).")
"
;


_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker
Kusss
Спасибо, буду знать.
Быстрый ответ:

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2024 Invision Power Services, Inc.