

创建查询
mysql_query(SQL语句);
例:
mysql_query(“insert into abc(yname,yage)values(‘张三’,13)”)
返回资源标识、true和false
SQL语句有结果,则返回资源标识
SQL语句无返回结果,成功则返回true,否则返回false
操作查询结果
mysql_fetch_row($result)
从查询语句返回的结果集中取得一行作为枚举数据
例如:
$str = “select * from tbl”;
$result = mysql_query($str);
$arr = mysql_fetch_row($result);
foreach($arr as $val)
{
echo $val.”<p>”;
}
mysql_fetch_array($result)
从查询语句返回的结果集中取得一行作为关联数组或数
字数组,或二者都有
$str = “select * from tbl”;
$result = mysql_query($str);
$arr = mysql_fetch_array($result);
print_r($arr);
mysql_num_rows($result)
获取查询结果中记录数
$str = “select * from tbl”;
$result = mysql_query($str);
$rows = mysql_num_rows($result );
echo $rows;
