Set Variable to One Column

[jhwrightiii]

Is it possible to set a variable from a query that will return one
row ie..

$control = mysql_query("SELECT control FROM table WHERE id = '1'");

[Gordon Burditt]

>Is it possible to set a variable from a query that will return one

row ie..

$control = mysql_query("SELECT control FROM table WHERE id = '1'");

Yes, but $control is a MySQL result handle, not the value.
To get the value (and there are a number of different ways to do this,
and you really need to do some error checking in case there was no
row with id = 1):

$r = mysql_fetch_result($control);
$value = $r[0];
/* we now have the value you wanted in $value */
echo "$value";
mysql_free_result($control);

Gordon L. Burditt

[jhwrightiii]

I appreciate it. I am new in PHP. I knew about the result handle and
was just trying to show an example. In other languages I am able to
do something similar to that example all in one line and is what I was
aiming for. Two extra lines will do though.

Again thanks for you Help.

On Wed, 20 Jul 2005 21:06:58 -0000, go***********@burditt.org (Gordon
Burditt) wrote:

Is it possible to set a variable from a query that will return one
row ie..

$control = mysql_query("SELECT control FROM table WHERE id = '1'");

Yes, but $control is a MySQL result handle, not the value.
To get the value (and there are a number of different ways to do this,
and you really need to do some error checking in case there was no
row with id = 1):

$r = mysql_fetch_result($control);
$value = $r[0];
/* we now have the value you wanted in $value */
echo "$value";
mysql_free_result($control);

Gordon L. Burditt