Re: Problem regarding 'select...as...'
| From: | Vince LaMonica | Date: | Mon, 12 Jun 2000 22:40:27 +0000 |
| Subject: | Re: Problem regarding 'select...as...' | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-361@lists.php.net to get a copy of this message | ||
On 2000-06-12, Bernie Huang stated:
} "select equip_attr[1], equip_attr[2]
} as year, make
} from vehicle_tb;"
}
} which gives me the following error:
}
} "ERROR: Attribute 'make' not found"
}
} Is there something wrong with my "as" usage? Thanks
Try:
"select equip_attr[1] as year, equip_attr[2] as make"
instead.
HTH,
/vjl/