Forums
This topic is locked
skip 6
Posted 15 Oct 2001 23:35:38
1
has voted
15 Oct 2001 23:35:38 Keith Slater posted:
Hey Im having a record set return some results and I was wondering what the easiest way is to make it skip the first 6 results and display the restso if I have:
1
2
3
4
5
6
7
8
9
10
In a database
It starts and 7 and displays 7-10
Thanks for the help!!
Keith Slater
Replies
Replied 16 Oct 2001 00:26:11
16 Oct 2001 00:26:11 Tim Green replied:
If your database supports it you can achieve this effect with the SQL Command 'LIMIT'. Check your database SQL documentation.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 16 Oct 2001 15:08:23
16 Oct 2001 15:08:23 Keith Slater replied:
Ah ok thanks.. If my server doesnt allow it how do I make it allow it?? We're using MySQL 4.0.6 and it doesnt appear that LIMIT works on it because it doesnt do anything even if I set it to 0.
Thanks again
Keith Slater
Thanks again
Keith Slater
Replied 16 Oct 2001 15:22:03
16 Oct 2001 15:22:03 Keith Slater replied:
woops it does work on our servers. The only thing is when I have it LIMIT 6 it atually LIMIT's 6 and only displays 6. I guess I'll keep looking into it
Keith Slater
Keith Slater
Replied 16 Oct 2001 15:25:12
16 Oct 2001 15:25:12 Keith Slater replied:
gah I keep answering my own question.. In cast anyone else wanted to know the answer its:
LIMIT 6,6
Keith Slater
LIMIT 6,6
Keith Slater
Replied 17 Oct 2001 07:29:22
17 Oct 2001 07:29:22 Stephen Cox replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>MySQL 4.0.6
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
MySQL 4.0.6?
Stephen Cox
web.net geek for nonprofits and political campaigns.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
MySQL 4.0.6?
Stephen Cox
web.net geek for nonprofits and political campaigns.
Replied 17 Oct 2001 15:04:33
17 Oct 2001 15:04:33 Keith Slater replied:
yea?
Keith Slater
Keith Slater
Replied 18 Oct 2001 01:39:48
18 Oct 2001 01:39:48 Tim Green replied:
I think what Stephen means Keith is that the MySQL 4.x.x versions haven't been released yet. That version number is actually the current stable PHP version.....
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 18 Oct 2001 05:51:07
18 Oct 2001 05:51:07 Keith Slater replied:
yea thats what I mean heheh
Keith Slater
Keith Slater