How do I show the first X resaults from a Table? - vb.org Archive

		vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
How do I show the first X resaults from a Table?

Reply

#1

Old

03-21-2006, 08:37 AM

DrewM

DrewM is offline

Join Date: Oct 2005

Posts: 564

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

How do I show the first X resaults from a Table?

Well I'm making a new news system and on the home page I only want it to show the first 5 or 6 results. Can some one help me do this?

Reply With Quote

#2

Old

03-21-2006, 07:40 PM

filburt1

filburt1 is offline

Join Date: Feb 2002

Location: Maryland, US

Posts: 6,144

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

<a href="http://dev.mysql.com/doc/refman/5.0/en/select.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/select.html</a>

Look at the LIMIT clause.

Reply With Quote

#3

Old

03-21-2006, 08:29 PM

DrewM

DrewM is offline

Join Date: Oct 2005

Posts: 564

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

thanks

how do I do this with vb?

Reply With Quote

Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 10:23 PM.