Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*//все это хорошо, но очень нагромождено
- $tool='(';
- foreach($_GET['tool'] AS $id){
- $tool.=(int)$id.',';
- }
- $tool = substr($tool,0,-1);
- $tool .=')';
- */
- //тут проще так делать
- $tool='('.implode(',',$_GET['tool']).')';
- //с запросом потяжелее мне, надо пробовать. почему сразу не объединять с условием?
- $query="SELECT
- u.name AS name, u.phone AS phone, u.email AS email, u.auto AS auto, t.name AS tool_name, u.image AS image, u.id_user AS id_user FROM vnd_user u
- LEFT JOIN vnd_user_tool ut ON (u.id_user=ut.id_user AND ut.id_tool IN $tool)
- LEFT JOIN vnd_tool t ON (t.id_tool=ut.id_tool)
- WHERE
- status<>0
- ";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement