hello, i\'m quering the database
here is my code
<?php
mysql_connect("localhost", "user", "pass");
mysql_select_db("database");
$query = "select r.id, r.week, r.awayteam, r.hometeam, t.team_id FROM results r, teams t";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td>";
echo "{$row[\'id\']}";
echo "-";
echo "</td>";
echo "<td>";
echo "week";
echo "{$row[\'week\']}";
echo "</td>";
echo "<td>";
echo "{$row[\'awayteam\']}";
echo "</td>";
echo "<td>";
echo "{$row[\'hometeam\']}";
echo "</td>";
}
?>
I get the query results and right now there are only two entries into that table, yet whenever i query the database i get like 30 some results but its just the two that are in the database alternating any help would be appreciated...