PHP MySQL Where子句学习

3. $con = mysql_connect("localhost","peter","abc123");

4. if (!$con)
5. {
6. die('Could not connect: ' . mysql_error());
7. }

8. mysql_select_db("my_db", $con);

9. $result = mysql_query("SELECT * FROM Persons

10. WHERE FirstName='Peter'");

11. while($row = mysql_fetch_array($result))

12. {
13. echo $row['FirstName'] . " " . $row['LastName'];
14. echo "
    ";
15. }

16. ?>

复制代码

输出： Peter Griffin