Efficient way of pulling single value from a database??

[xProteuSx]

Right now I am using code such as this:

 

$query = "SELECT somevalue FROM sometable WHERE id=1"

$result = mysql_query($update) or die ('Error in query: ' . mysql_error());

 

$somevalue = '';

 

if (mysql_num_rows($result) == 1)

  {

  while($row = mysql_fetch_assoc($userstatsresult))

    {

    $somevalue = $row['somevalue'];

    }

  }

 

echo $somevalue;

 

Is there a short-hand method to get that single value without the IF/WHILE stuff?

[kney]

#1

 

<?php
    $query = "SELECT something FROM sometable WHERE ID = 1";   
    $result = mysql_query ($query);
    $row = mysql_fetch_array($result);
    $record = $row[0];
?>

 

#2

 

<?php
    $sql = "SELECT something FROM sometable WHERE ID = 1";
    $email = mysql_result(mysql_query($sql), 0, 0);
?>

[xProteuSx]

Very nice.  In your second example, what do the two zero's mean?

[kney]

first 0 is the row number that's being retrieved

second 0 is the name / offset of the field being retrieved

 

http://php.net/manual/en/function.mysql-result.php

[xProteuSx]

Awesome, thank you sir.

[silkfire]

A variant of kney's second solution, it's even a one-liner =)

 

list($email) = mysql_fetch_row(mysql_query('SELECT something FROM sometable WHERE id = 1'));