What is the purpose of using the for loop? if I may make a suggestion for
using the while loop. The code would look something like this:
<?php
$color=1;
while ($lyric_array = mysql_fetch_array($lyrics)) {
$comments = mysql_query("SELECT * FROM `comments` WHERE `resource_id` =
$lyric_array[0]");
$num_comments = mysql_num_rows($comments);
if ($color == 1) {
$rowcolor = "#DFDFDF";
$color ++;
} else {
$rowcolor = "#FFFFFF";
$color --;
}
echo "<tr bgcolor=\"";
echo "\"><td><a
href=\"view.php?id=$lyric_array[0]\">$lyric_array[1]</a></td>";
echo "<td>$lyric_array[3]</td>";
echo "<td>$num_comments</td>";
echo "<td>$lyric_array[2]</td>";
echo "<td><a href=\"$lyric_array[4]\">Buy at Amazon.com</td></tr>";
$ltotalv = $ltotalv + $lyric_array[3];
}
?>
I was looking at the current code and wasn't seeing the purpose for the for
loop. If I'm incorrect and you are using it for a specific purpose, please
let me know.
-aaron
"Tony Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> OK, the color works, but now I have 2 empty lines!!!!!!!!!!!!!!!!!!!!
>
> "Tony Harrison" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Thanx, I havent tried the loop yet, but the color will work im sure .
> >
> > "Aaron Ott" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > tony,
> > >
> > > regarding problem one, it looks like there is a problem in the code
> near:
> > > for ($g = 0; $g < $num_lyrics; $g ++) {
> > >
> > > try doing:
> > > for ($g = 0; $g <= $num_lyrics; $g ++) {
> > >
> > > As for problem two, it looks like you have your color variable set in
> the
> > > for loop thereby resetting the color variable to 1 with each pass:
> > > for ($g = 0; $g < $num_lyrics; $g ++) {
> > > $color = 1;
> > > if ($color == 1) { $rowcolor = "#DFDFDF"; $color ++; } else {
$rowcolor=
> > > "#FFFFFF"; $color --; }
> > > ...
> > > }
> > >
> > >
> > > "Tony Harrison" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > OK, im having some minor problems with my site.
> > > > In artist.php (http://members.lycos.co.uk/ajohnh/artist.php - Source
> at:
> > > > http://members.lycos.co.uk/ajohnh/source/artist.txt) If for example
> you
> > > view
> > > > lyrics by Weird Al Yankovic
> > > > (http://members.lycos.co.uk/ajohnh/artist.php?id=1) You'll see that
> the
> > > > bottom lyric (The Sage Begins) does not display. Now when you sort
> them
> > by
> > > > views
(http://members.lycos.co.uk/ajohnh/artist.php?id=1&sortby=views)
> > you
> > > > will see that err, The Sage Begins is there, and the other one can
no
> > > longer
> > > > be seen. PLease examine my source and tell me whats wrong. And
another
> > > thing
> > > > about that page. The rows are meant to be alternating between
#DFDFDF
> > > (grey)
> > > > and #FFFFFF (white) - why the hell are they all grey?!?!?!!? It
worked
> > > fine
> > > > in index.php - source at
> > > http://members.lycos.co.uk/ajohnh/source/index.txt
> > > >
> > > >
> > > > Please help !!!!!!
> > > >
> > > >
> > >
> > >
> >
> >
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
