single field from db into variable

[DaveC426913]

$sql = "SELECT LastName FROM myTable WHERE `UID` = ".$UID.";
$resultA = mysql_query($sql);
$LastName = mysql_result($resultA,0,"LastName");

I know this is like, PHP101, but I can never seem to quite get the right answer.

How DO you get a single field from a single row of the db into a variable?

 

[vacunita]

Try:

$row=mysql_fetch_array($resultA);
$LastName=$row['LastName'];

[code]

After you issue the query.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[DaveC426913]

Well, yeah - that's the way I've been doing it - but it's so graceless! You're getting an entire array so get one cell. How about even fetch_row?

 

[jpadie]

from your code snip above all the three options below should work

$sql = "SELECT LastName as LastName FROM myTable WHERE `UID` = ".$UID.";
$resultA = mysql_query($sql) or die ("cannot perform query ".mysql_error());
if (mysql_num_rows($resultA) !== 0) :
$lastname[] = mysql_result($resultA, 0 , 0); //first column of first record

$lastname[] = mysql_result($resultA, 0 , "LastName"); //better to use aliases to avoid caps issues
or
$lastname[] = mysql_result($resultA, 0); //defaults to first row
endif;

echo "Last name returned from each option is <br/><pre>";
print_r ($lastname);
echo "</pre>";