mysql BD rows color

[ashbai]

Iam getting the DB result well .. but i need to have the result out as rows and one row without Background color and the other have a background color .. the third without and the fourth with a background color, .. etc ...

doing that loop is new for me , can any one help me ..?
my email : [e-mail]
thanx in advance

Ashraf Baroudi,

[[deleted]]

Try something like this:
$iColor=0;
for&nbsp;($iT=0;$iT<10;$iT++)
{
&nbsp;&nbsp;if&nbsp;($iColor++&nbsp;%&nbsp;2)
&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'color<BR>';
&nbsp;&nbsp;}
&nbsp;&nbsp;else
&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'no&nbsp;color<BR>';
&nbsp;&nbsp;};
};

[ashbai]

Thanx .. for ur script and help ..
but what iam asking for : a bit more detailed like:
iam useing the while.... mysql_fetch_array ....
to get the result of select .. and make it rows ..

so .. is it working like that :

$icolor='#f2efe8';
while($row=(mysql_fetch_arraay($Query_Result)){
echo("<p>".$row[]."</p>");
}

please advice me .. thanx in advance ..
A.Baroudi,

[amcgrath]

Try this:

$icolor = ($icolor == "f2efe8" ? "" : "f2efe8")
Put it right under the while statement.

[[deleted]]

A perfect example of compact and totally unreadable code 🙂

[ashbai]

Thanx alot ... it works ..
i make it like that :
while($row=mysql_fetch_array($qry)){
$icolor = ($icolor == "f2efe8" ? "" : "f2efe8");
echo("<p><tr><td style='background-color:#".$icolor."'>".$row[company]."</td></tr></p><br>");
}

🙂
its well don .. thanx ..

A.Baroudi.

[ashbai]

is that supports 10 rows only ..?
and if u can just to explain me :
is the %2 means the no. which allows devided on 2 ..
or some thing like that ..?
and where i have to place this code ..?
it is inside the while ..?

[[deleted]]

$iColor=0;
while($row=mysql_fetch_array($qry))
{
if ($iColor++ % 2)
{
$sColor = 'f2efe8';
}
else
{
$sColor = 'f2efe8';
};

echo("<p><tr><td style='background-color:#".$sColor."'>".$row[company]."</td></tr></p><br>");
}

[ashbai]

yah ..
Great ..
thanx alot ..
its working well ... ! ..

but have u seen what the other solution was ..
i try it and it also works ..
i understand ur way .. and code ..

but his .. works .. but i did not understand it ..
can u help me in that ..?

🙂

thanx alot ..

[[deleted]]

Allen's solution uses PHP shorthand.

It does exactly the same, but in a different syntax.

$icolor = ($icolor == "f2efe8" ? "" : "f2efe8")

It works like this:
(this is not real PHP)

$iColor = IF($icolor == "f2efe8") THEN '' ELSE "f2efe8";

And as you can see it is very difficult to understand.

[amcgrath]

Ha! now that's funny! But it works! and besides, its only a background color, if someone needs to really know what the html is doing, they are in the wrong line of work.

[ashbai]

yes thanx ..
now its clear ...

thanx alot ...