Display only mysql_num_rows results #-# (or similar)

[br3nn4n]

This is probably really really simple, but I can't get it to work on my end...haha.

 

So I have this mysql database. It works great, the stuff outputs how I want. But I'm making a news website and I need to change the articles each month.

 

I'm putting all the articles into one database, then into each page as tables (ie: news, opinion, sports, etc.), then the articles each have their own row. On the homepage here it outputs all 5 articles from the news table, but I only want it to output result numbers (blah) through (whatever).

 

Here's the code used on the page to output the 5:

<?
$query1 = mysql_query("SELECT * FROM news");

while ($result1 = mysql_fetch_array($query1)) {
for ($i = 0; $i < mysql_num_rows($query1) {
echo "<a href=\"index.php?page=news&article=$result1[id]\"><b>$result1[title]</b></a>";
echo "<br /><i>$result1[date]</i>";
echo "<br />By <i>$result1[name]</i>";
echo "<br />$result1[desc]";
echo "<br><br>";
break;
$i++;
}
}
?>

 

I'm only recently getting into dynamic coding (ie: php) and these forums have been a lot of help with other things, so thanks in advance!

[pocobueno1388]

Your not real clear on what your trying to do. It sounds like you may be looking for "pagination", so try googling that.

 

Also, the for loop inside of your while loop doesn't look like it's needed.

[br3nn4n]

Okay then To clarify, mysql_num_rows outputs 5 rows. Although, from that 5 I only want to show results number 3 through 5.

 

That make more sense?

[teng84]

then create a counter inside your loop..

 

Eg++$ctr.. the after you reach your desired number do some stuff ...

[br3nn4n]

Oh okay, so have it count the number of outputted (sp?) results and stop at a whatever number I want?

 

I'm really just figuring this stuff out as I go so any clarification would be great

[teng84]

loophere{
++$count;
if ($count!=3){
	continue;
}
else{
// do your stuff here
}
}

syntax...

[br3nn4n]

Ah, gotcha..now, any way to start the visible output from, say, result 3?

[pocobueno1388]

Just use LIMIT in your query. If you wanted ONLY results 3-5 you would do this:

 

<?php

$query1 = mysql_query("SELECT * FROM news LIMIT 3,5");

?>

[br3nn4n]

Sweet, perfect!

 

Thanks so much!