в 10:37, 26 мая 2010

2010-05-26T10:37:34Z

Admin: 1 версия

2010-05-26T07:06:16Z

1 версия

Новая страница

==mysql_fetch_row() fetches rows==



<source lang="html4strict">

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();
?>

</source>

==mysql_fetch_row.php==



<source lang="html4strict">

<?
mysql_connect("localhost","root","");
mysql_select_db("mydatabase");
$query = "SELECT id, title FROM product ORDER BY title";
$result = mysql_query($query);
while (list($id, $title) = mysql_fetch_row($result))
{
echo "Product: $title ($id) <br />";
}
?>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/MySQL Database/mysql fetch row - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия