my looping in my first script, from table STY_REPORT_200501 ....I'm including the value -----1st query (looping)----- $query = "select a.*, b.sty_descr as styname from STY_REPORT_200501 a left join STY_ITEM b on a.std_item=b.sty_code where a.std_nis=111 -----end looping------------
the result is -----result------ std_nis std_class std_item std_value 111 1 1 8 -----1st row 111 1 2 7 -----2nd row 111 1 5 6 -----3rd row 111 1 4 9 -----4th row ----end result------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
