shorter select statements?

[ale1981]

I 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?

[metrostars]

That is simple. You can't get it any more simple than that. unless you want to put LIMIT 0, 1 on the end, although it isn't necessary if userid is a primary field anyways.

[ale1981]

Yes I know it is simple, its just i have always wondered if there is a simpler way!

 

Thanks for your reply.

[ale1981]

I have actually found an easier way (well for me anyway!);

 

$userID = $_GET['userID'];

$result = mysql_query("SELECT userName FROM users WHERE userID = $userID");
$userName = mysql_result($result, 0);

echo $userName;

 

... not quite the same!!