it's a Short select statements?

Question

Have always wondered if there is a way of doing a quicker select statement than the one below;


$userID = $_GET['userID'];

$result = mysql_query("SELECT name FROM users WHERE userID = $userID");
$row = mysql_fetch_row($result);

echo $row[0];



Can this query be shortened for simple queries like this one where I just want to retrieve a single field from one row?

Answer 1

I think should be better you create one function for make it more simple like below :

function getData($field,$table,$cField,$cVar){

$result = mysql_query("SELECT ".$field." FROM ".$table." WHERE ".$cField." = ".$cVar."");
$row = mysql_fetch_row($result);

return $row[0];
}

So You can call that function,If you want to retrieve a single field from one row like below:

echo getData("nama","users","userID",$_GET['userID']);