Large Daily News Table and Need to Limit Number of Returns on Select Statement

[vworld]

Hi Everyone,

I'm new SQL and although I can create a database, update it, insert, select etc....I've come across a challenge that I'm hoping someone can help me with. I've got a daily news table with about 2,700 rows or news items. I would like to give my users the ability to view the items in the table sorted by date, category, and source of news.

Here's where the I run up against the challenge...I have created a select statement for the table but I it will return too many items! How can I limit the number of items returned from the database? I'm sure there is a simple solution to the problem I just can't seem to find it...

Thanks in advance for any help.

V

[mad-onion]

Simple is an understatement

Say you have the query
"select * from table"
you can make it
"select * from table limit 10"
That will select the first 10 items in the db.

Or you may want to select the 8 most recent items (if there is a date column with the timestamp the item was posted)
"select * from table ORDER BY date DESC LIMIT 8"

Hope that helps

[vworld]

THANK YOU soooooo Much!

That really does help and I knew I was just missing something. =-)

if ($orderby == 'date'):
$sql = "select * from dailynews ORDER BY date DESC LIMIT 10'";

Again, thanks a million....

V

[mad-onion]

Not a problem, happy to be of assistance