hi, try your first SELECT statement, but with
ORDER BY table1.table1_row maybe this helps (I didnt try it). Anton Tichawa > -----Original Message----- > From: Bruno Faé [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 5:44 PM > To: [EMAIL PROTECTED] > Subject: Query Error > > > Hi ! > > I´m trying to query some news with multiple rows in my database. I´m > receiving an error when i use: > > "SELECT table1.*, table2.table2_row FROM table1,table2 ORDER BY > table1_row" > > but, if I try: > > "SELECT table1.table1_row, table2.table2_row FROM > table1,table2 ORDER BY > table1_row" > or > "SELECT table1.*, table2.table2_row FROM table1,table2" > > it works fine, and I don´t understand why it always work and now is > returnig a error. > > I don´t have any idea of what is happennig. > I think it´s a PHP problem. > > Thank You for Help. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php