php $sql = "SELECT * FROM schedule WHERE day = '$day' ORDER BY ID ASC"; while ($hour = mysql_fetch_array($hours)) { ?>
<input type="text" name="course" value="&l
ART_LOOKUP.ARL_SEARCH_NUMBER AS NUMBER, ART_LOOKUP.ARL_KIND, FROM ART_LOOKUP
LEFT JOIN BRANDS ON BRANDS.BRA_ID =SUPPLIERS.SUP_BRAND)作为品牌,ART_LOOKUP.ARL_SEARCH_NUMBER作为数字,ART_LOOKU
如果我有这样的Select语句:然后,我将它与mysql_query我现在怎么能访问这些字段?$ can >T1. the不工作.更新2013:这个问题很古老,但最简单的正确方法是在select语句中为每个字段提供一个别名,因此它们是唯一的。示例:
SELECT T1.TEXT AS MYTEXT, T2.FIELD AS MYFIELD FR