MYSQL SELECT - A quicker way?

[Jack99uk]

Just wondering if there's a quicker/shorter way to do the following:

<?
$result = mysql_query("SELECT homepage FROM copy");
$row = mysql_fetch_row($result);
$copy = $row[0];
echo $copy;
?>

(Just pulling some copy for a site's homepage out of the database)

[jpmoriarty]

wow, you're really after optimised code if 4 lines is too much for you...

I suppose you could do:

$result = mysql_result(mysql_query("SELECT homepage FROM copy"),0,0); 
echo $result;

but the more you do stuff like that, the more confusing it gets later on. I think you're better off as it is...

[Jack99uk]

Suppose you're right - that is a bit greedy to want more optimisation ;-)

Was wondering if there was a shortcut along the lines of $var ++ insteatd of $var = $var + 1; for something that's used often - no problem, thanks for your answer!

[nemonoman]

I am often selecting only one value from the database (one field from one row), so I have made this obvious function:

function oneresult($query){
&nbsp;&nbsp;&nbsp;return mysql_result(mysql_query($query));
}

echo oneresult("SELECT homepage FROM copy");