How can I get a fixed number of Headlines in this PHP script?

Dev Articles Community Forums Sponsor:

SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!

October 14th, 2003, 07:16 PM

banx

Contributing User

Join Date: Feb 2003

Posts: 33

Time spent in forums: < 1 sec
Reputation Power: 6

How can I get a fixed number of Headlines in this PHP script?

Mitch built a Multi-Page Article System script, http://www.devarticles.com/art/1/310 , it works great, but can anyone tell me how I can get a fixed number of headlines to be shown, like 20 or 25 headlines. Instead the entire listing.

THANKS!

Last edited by banx : October 14th, 2003 at 07:18 PM.

October 15th, 2003, 01:32 AM

laidbak

you know how we do

Join Date: Jun 2002

Location: In Tha IE -- San Bernardino COUNTY

Posts: 788

Time spent in forums: 2 h 4 m 2 sec
Reputation Power: 7

Notice the sql query:

PHP Code:


		
			
 $result = mysql_query("select * from articles order by articleId asc");

What you can do is alter this query to only select a certain amount of records using the Limit clause.

Limit takes two parameters ( one is optional ). If you only supply one argument, that argument tells MySql to return at maximum that amount of records.

If you supply two arguments, the first is where to start (the offset of first row), the second argument is the max # of records to retrieve. To return 25 records:

PHP Code:


		
			
 $result = mysql_query("select * from articles order by articleId asc LIMIT limit 0, 25");

This will not skip any records, but will limit the records returned to 25.

__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.

October 15th, 2003, 03:04 PM

banx

Contributing User

Join Date: Feb 2003

Posts: 33

Time spent in forums: < 1 sec
Reputation Power: 6

Thanks for replying!

I tried that but then I get this

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in showarticles.php on line 14

And here is whats on line 14

Quote:

while($row = mysql_fetch_array($result))

Which leaves me to wonder, what could be wrong with line 14?

October 15th, 2003, 03:07 PM

dhouston

Contributing User

Dev Articles Beginner (1000 - 1499 posts)

Join Date: May 2003

Location: Tennessee

Posts: 1,355

Time spent in forums: < 1 sec
Reputation Power: 7

That usually means you haven't connected successfully to the database or that the query is hosed. Echo your query before executing it and try running it at the command line. If it fails, then you've typoed on the query.

October 15th, 2003, 05:11 PM

banx

Contributing User

Join Date: Feb 2003

Posts: 33

Time spent in forums: < 1 sec
Reputation Power: 6

I thought so too. Which is what really had me scratchin' my noggin'.

It turns out, however, in:

Quote:

$result = mysql_query("select * from articles order by articleId asc LIMIT limit 0, 25");

I had LIMIT written twice.

Duh!

Thanks for your help guys! The script looks great now!

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: