Help needed receiving data from the database.

[LeZeNkO]

Heya,

I need some help with this script. I cant seem to get it to show only the "Top Two" fields. and not only that it also gets out of place.

<?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("name", $link);
$qry = mysql_query("SELECT * FROM news", $link);

?></tr><?php

if (mysql_num_rows($qry) > 0) {
for ($j = 0; $j<mysql_num_rows($qry); $j++) {

    ?><?php

    for ($k = 0; $k<mysql_num_fields($qry); $k++) {
        echo "<td bgcolor=000040 align=left><font color=0066FF>" . mysql_result($qry,$j, $k) . "</font></td>";
    }

    ?><?php

}

}

?>

can anyone help?

thx

[fean0r]

you dont seem to have table rows?

<tr><td>text</td></tr>