Simple way to read single record from MySQL

mysql, php

Solution

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

Problem

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.

Original source