[Q] Can I access MySQL alias from PHP???

[cyanblue]

Howdy... 🙂

Is it possible to get the value of MySQL alias returned back to PHP???

For example, this is the SQL query that I will be calling from the PHP...

$sql = "select (1 + 2) as c;";

and I want the value of that 'c' available in PHP... How can this be done???

If I broaden this question abit, can I combine two select commands into one???

$sqlA = "select * from theTable;";
$sqlB = "select (1 + 2) as c;";

and I want both calls made at once... Is it possible???

Thank you very much...

[hkucsis]

Use sth like:

$sql = "select (1 + 2) as c";
$result = mysql_query($sql) ;
$row = mysql_fetch_array($result) ;
echo $row["c"] ;

[cyanblue]

Ah... Thanks alot... I'll check that out... 🙂

Any idea on combining two SQL commands into one stuff???