AW: [php] Werte aus MYsQL-DB auslesen

[Wolfgang Hauck]

Hi Michael,

> > Hallo Liste,
> >
> > wünsche Euch einen schönen Freitag.
> Select t1.irgendwas as bla1,t2.irgendwas as bla2, from tabelle1 t1 left
join
> tabelle1 t2 on t1.id = t2.id ....
>

Nochmal:

Select t1.KatID as bla1,t2.KatID as bla2, from tabelle1 as t1 left join
tabelle1 t2 on t1.id = t2.id ....

    while (odbc_fetch_row($i_result) ) {
     $a_temp_category[$i_index]["KatID1"] = odbc_result($i_result, "bla1");
     $a_temp_category[$i_index]["KatID2"] = odbc_result($i_result, "bla2");

oder
     $a_temp_category[$i_index]["KatID1"] = odbc_result($i_result,
"t1.KatID");

oder
     $a_temp_category[$i_index]["KatID1"] = odbc_result($i_result,
"tabelle1.KatID");


MFG Wolfgang