mysql_result.php3

来自「linux操作系统中 php 核心编程所有例程 都是一些很不错的案例」· PHP3 代码 · 共 30 行

PHP3
30
字号
<HTML>
<HEAD>
<TITLE>mysql_result</TITLE>
</HEAD>
<BODY>
<?
	// connect to server 
	$mysql_link = mysql_connect("localhost", "httpd", "");

	// select the 'store' database 
	mysql_select_db("store", $mysql_link);

	// get everything from customer table 
	$query = "SELECT * FROM customer c ";
	$query .= "WHERE c.name like 'A%' ";
	$mysql_result = mysql_query($query, $mysql_link);

	// get number of rows 
	$rows = mysql_num_rows($mysql_result);

	for($index = 0; $index < $rows; $index++)
	{
		$name = mysql_result($mysql_result, 
			$index, "c.name");
		print("$name<BR>\n");
	}

?>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?