Using an alias name in select query

[cyprus]

Is it permitted/possible to change a select query statement to create an alias name. I tried below but did not work:

$query = "select Total as runningtotal from orders";

runningtotal being the table field name, Total as I want to be displayed later. Thanks

[onlyican]

SELECT total AS runningtotal FROM orders
means when grabbing the data, you grab the fieldname runningtotal NOT total

[sasa]

try 'select runningtotal as Total from orders'

[cyprus]

Thanks sasa, that did it!! Regards - Thanks onlyican for reply.