Question

如何用php获取sql语句的返回结果

，比如
select uid from pw_members where username ='$username'
这个，获取$username的uid的值，用Php怎么写？

Answer 1

$result = mysql_query("select uid from pw_members where username ='$username'");if($result){ while($row=mysql_fetch_array($result)){ $uid=$row['uid']; } mysql_free_result($result);}echo $uid;

Answer 2

$result = mysql_query("select uid from pw_members where username ='$username'");