|
Its syntax is: array mysql_fetch_row() (int result)
<?
@mysql_connect("localhost", "root","") or die("Could not connect to MySQL server!");
@mysql_select_db("mydatabase") or die("Could not select database!");
$query = "SELECT * FROM mytable";
$result = mysql_query($query);
print "<table>\n";
print "<tr>\n<th>ID</th><th>Title</th><th>MyValue</th>\n</tr>\n";
while (list($id, $title, $myvalue) = mysql_fetch_row($result)) :
print "<tr>\n";
print "<td>$id</td>\n<td>$title</td>\n<td>$myvalue</td>\n";
print "</tr>\n";
endwhile;
print "</table>";
mysql_close();
?>
|