Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
C++ JAVA
-
crazzybg
- Турист

- Posts: 210
- Joined: Sun Dec 11, 2011 10:30 pm
Post
by crazzybg » Sat Jan 16, 2016 2:37 pm
Здравейте.
Възможно е да е не уместен въпроса но има ли вариант с една заявка да
потърся примерно минимум и максимум id да речем че искам от ID 10 до ID 13 да ми изведе с while резултат на тези 3 ID ?
-
anonimen
- Web-tourist

- Posts: 1607
- Joined: Mon Jun 11, 2012 6:07 pm
-
Answers: 165
- Location: Parse error: unexpected "}" in /home/index.php on line 26
Post
by anonimen » Sat Jan 16, 2016 3:38 pm
[sql]where id >= 10 and id <= 13[/sql]
-
SVTerziev
- Нов

- Posts: 158
- Joined: Fri Jul 13, 2012 12:32 am
-
Answers: 34
Post
by SVTerziev » Sat Jan 16, 2016 3:52 pm
[sql]SELECT `id` FROM `table` WHERE `id` BETWEEN '10' AND '13'[/sql]
-
Fakeheal
- Гуру

- Posts: 2718
- Joined: Sat Apr 17, 2010 6:37 am
-
Answers: 351
- Location: /r/eyebleach
-
Contact:
Post
by Fakeheal » Mon Jan 18, 2016 7:30 am
SVTerziev wrote:[sql]SELECT `id` FROM `table` WHERE `id` BETWEEN '10' AND '13'[/sql]
ID-то най-вероятно е int, не са нужни кавичките.
[sql]SELECT `id` FROM `table` WHERE `id` BETWEEN 10 AND 13[/sql]