在PHP中执行Mysql SELECT语句示例

<?php
$con = mysql_connect("localhost","mysql用户名","mysql密码");
if (!$con)
{

	die('无法连接mysql数据库: ' . mysql_error());
}

mysql_select_db("onitroad_blog", $con);

$result = mysql_query("SELECT * FROM Emp");

while($row = mysql_fetch_array($result))

{
	echo $row['Fname'] . " " . $row['LastName'] . " ". $row['Id'];
	echo "<br />";
}

mysql_close($con);
?>

MySQL SELECT语句

SELECT语句用于从一个或者多个表中检索数据。

SELECT语句的语法

SELECT columnName FROM tableName;

或者

SELECT *(for hole table) FROm tableName;