[Help] While loop that stops

[Spike121]

I'm fairly new to PHP, and I've made a script that outputs each link that is in my database, until there are no more links left. But for my front page, I want just like, 10 links, is there a way to stop the loop after it reaches 10?

 

do {
echo "<tr><td valign='top' bgcolor='#".$backcolor."'><center><a href='".$row['Address']."' target='_blank'>".$row['Address']."</a><br><br>".$row['Keywords']."</cemter></td>";
echo "<td valign='top' bgcolor='#".$backcolor."'>".$row['Description']."</td></tr>";
} while($row = mysql_fetch_assoc($result));

 

And if you can also help on this one (It's not necessary, but it would be cool) I'm trying to make alternating colors for the background color of the cell ($backcolor). Above that script is:

 

if ($backcolor = "33ADFF") {
$backcolor="FFFFFF";
}
else {
$backcolor="33ADFF";
}

 

1. Should I put it inside the do, while loop, or above it?

2. It doesn't work, but I don't know why. I thought it should. o.o

 

Thanks in advance!

[DeanWhitehouse]

yes in the sql LIMIT 10

[Spike121]

So...

 

$result = mysql_query("SELECT * FROM sites LIMIT 10") 

[DeanWhitehouse]

try it

[Spike121]

Perfect, thanks. Can you do anything about the alternating colors though?

[DeanWhitehouse]

So it is like

red

green

red

green etc.

 

If so then one way could be

 

$i = 0;

while(looping stuff)

{

if($i == 1){

echo "red";

$i = 0;

}

elseif($i == 0)

{echo "green";

$i = 1;

}

}

 

sorry bout the code in a rush

[Spike121]

$i = 0;
do {
echo "<tr><td valign='top' bgcolor='#".$backcolor."'><center><font color='#000000'><a href='".$row['Address']."' target='_blank'>".$row['Address']."</a></font><br><br>".$row['Keywords']."</center></td>";
echo "<td valign='top' bgcolor='#".$backcolor."'>".$row['Description']."</td></tr>";
} while($row = mysql_fetch_assoc($result));
{
if($i == 1){
$backcolor="red";
$i = 0;
}
elseif($i == 0)
{
$backcolor="green";
$i = 1;
}
}

 

That's what I did, is that what you mean? I changed it a bit obviously.

[DeanWhitehouse]

Does it work?

[Spike121]

No

[DeanWhitehouse]

Hmm, i am not sure why not unless it is something to do with the fact you are using do while loop which isn't needed.

[Spike121]

Well, I tried the while loop the first time, but it always skipped the first entry in the database, but when I tried the do while loop, it got the first one aswell, so I stuck with it.