Menu
For some reason when I use a column alias, I cannot retrieve the value of a column’s field.
[code=php]
$cat=sqlite_query($handle,”select cd.categories_name from categories_description cd”);
while($cat_row=sqlite_fetch_array($cat)){
$cat_row[‘categories_name’].”<br>”;
$i++;
}
but this works:
[code=php]
$cat=sqlite_query($handle,”select categories_name from categories_description”);
while($cat_row=sqlite_fetch_array($cat)){
$cat_row[‘categories_name’].”<br>”;
$i++;
}
I need to use column aliases for joining tables.