php - Simple way to read single record from MySQL

Question

What's the best way with PHP to read a single record from a MySQL database? E.g.:

SELECT id FROM games

I was trying to find an answer in the old questions, but had no luck.

Answer 1

$id = mysql_result(mysql_query("SELECT id FROM games LIMIT 1"),0);