----- Original Message ----- From: "Viorel Dragomir" <[EMAIL PROTECTED]> To: "Patricio Gigoux" <[EMAIL PROTECTED]>; "mysql groups" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 9:25 AM Subject: Re: JOIN with php
> Can u apply the standard list of rows to your query. > Like: > > $result = pg_exec($db, $query); > while($row = pg_fetch_row($result)) > print_r($row); yes it the same to me script, but i don't get good result > > ----- Original Message ----- > From: "Patricio Gigoux" <[EMAIL PROTECTED]> > To: "mysql groups" <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 4:19 PM > Subject: JOIN with php > > > > Hello: > > I am making a php script, and I have the next problem: > > > > SELECT * > > FROM alo LEFT JOIN alo_resp ON alo.id=alo_resp.id > > > > result is: > > id desc price id desc > > 1 gg 8 1 dd > > 9 > > 3 df 5 3 ff > > > > but if I do the same in mysqlgui > > result is: > > id desc price id desc > > 1 gg 8 1 dd > > 2 ss 9 2 jj > > 3 df 5 3 ff > > > > What is the problem? PHP? > > > > Thank in advance > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]