Next Row

[nhwaldron]

OK, so I am an idiot and can't seem to remember how to pull rows from a database and place them in an HTML table--each row/record in the database should be one row in the HTML table.

Thanks for the help.

[Frag]

How about

while(mysql_fetch_row($result)) {
table stuff
}

Frag

[nhwaldron]

When I try that I only get the first row. I don't get any error messges though.

[nhwaldron]

This is what I have so far....I have tried various iterations to this but this is the current one....

$numrows = mysql_num_rows($result);

$myrow = mysql_fetch_array($result);

//set counter variable
$i=1;

while($i <= $numrows)
{
echo"<TABLE BORDER='0' CELLPADDING='2' CELLSPACING='2'>";
       echo"Rows: ".$numrows."; Counter: ".$i;
        echo"<TR>";
                echo"<TD>&nbsp;</TD><TD>&nbsp;</TD>";
        echo"</TR>";
        echo"<TR>";
                echo"<TD VALIGN='TOP'>";
                echo"<!-- IMAGE GOES HERE -->";
                echo"<IMG SRC='./images/$myrow[img]' WIDTH='150'>";
                echo"</TD>";
                echo"<TD>";
                echo"<!-- BIO INFO GOES HERE -->";
                echo"<H5> $myrow[name], <SPAN class='blue'>$myrow[title] </SPAN></H5>";
                echo"<P> $myrow[p1] </P>";
                echo"<P> $myrow[p2] </P>";
                echo"<P> $myrow[p3] </P>";
                echo"</TD>";
        echo"</TR>";
echo"</TABLE>";

//increment counter variable
$i++;
}

[buck2bcr]

I would do this

$numrows = mysql_num_rows($result);



//set counter variable
$i=1;

while($myrow = mysql_fetch_array($result))
{
echo"<TABLE BORDER='0' CELLPADDING='2' CELLSPACING='2'>";
       echo"Rows: ".$numrows."; Counter: ".$i;
        echo"<TR>";
                echo"<TD>&nbsp;</TD><TD>&nbsp;</TD>";
        echo"</TR>";
        echo"<TR>";
                echo"<TD VALIGN='TOP'>";
                echo"<!-- IMAGE GOES HERE -->";
                echo"<IMG SRC='./images/$myrow[img]' WIDTH='150'>";
                echo"</TD>";
                echo"<TD>";
                echo"<!-- BIO INFO GOES HERE -->";
                echo"<H5> $myrow[name], <SPAN class='blue'>$myrow[title] </SPAN></H5>";
                echo"<P> $myrow[p1] </P>";
                echo"<P> $myrow[p2] </P>";
                echo"<P> $myrow[p3] </P>";
                echo"</TD>";
        echo"</TR>";
echo"</TABLE>";

//increment counter variable
$i++;
}

I think that should work. You need to fetch each row seperately, you only fetched the first row and then never fetched the next one.

[nhwaldron]

With one minor modifaction that worked! THANKS!!

[buck2bcr]

No prob, glad to be of some assistance.