getting one record from the database

[csphard]

Do I always have to get my information from an array even if I am searching for one record.

If you know of a tutorial on getting information from the database I would appreciate it.

Howard

[cahva]

No, you dont have to. You can use mysql_result() function to grab the one field:

$sql = "SELECT name FROM tablename WHERE id=2";
$result = mysql_query($sql);
if (mysql_num_rows($result)>0) {
    $name = mysql_result($result,0);
}

Best turorials are IMHO when you just read the manual. Theres usually lots of examples and read the comments too..

[laserlight]

Note that cahva's example uses the legacy MySQL extension. These days you would more likely use the PDO extension, in which case PDOStatement::fetchColumn would be the relevant function.