ID: 27369 Updated by: [EMAIL PROTECTED] Reported By: nospam at webdragon dot net -Status: Open +Status: Closed Bug Type: Documentation problem Operating System: Linux (Fedora Core 1) PHP Version: Irrelevant New Comment:
This bug has been fixed in the documentation's XML sources. Since the online and downloadable versions of the documentation need some time to get updated, we would like to ask you to be a bit patient. Thank you for the report, and for helping us make our documentation better. Previous Comments: ------------------------------------------------------------------------ [2004-02-23 15:21:02] nospam at webdragon dot net on the contrary, what's changed is _clarity_ it's either this, or TWO SQL queries, thus: 1. Query with duplicate field names SELECT t1.field, t2.field FROM t1, t2 2. Query with aliased duplicate field names SELECT t1.field AS foo, t2.field AS bar FROM t1, t2 since the Query presented in the existing docs is quite obviously one that does _not_ have duplicate field names in the result, since they are _already aliased in the example presented_, therefore the requested change. It presents the information in a slightly clearer manner with a minimum of additional bytes of info and is less confusing. Lest you forget, this documentation is not for people who already KNOW what you're talking about intimately. It's for people who haven't got a clue (or haven't had their coffee yet). The more clearly you can present your instructions, the fewer stupid questions and confused users you'll have. QED ------------------------------------------------------------------------ [2004-02-23 15:05:19] [EMAIL PROTECTED] I don't see any interess in this patch, as nothing is changed. ------------------------------------------------------------------------ [2004-02-23 13:07:55] nospam at webdragon dot net Description: ------------ Following is a patch to the documentation to make the aliasing issue slightly clearer. I (in my caffeine deprived state) not only failed to realize that you were referring to aliasing via mysql, but didn't notice that the query below was doing that very thing in mysql. This patch makes this slightly clearer. (hopefully linewrapping won't bollix this) Reproduce code: --------------- --- function.mysql-fetch-array.html 2004-02-08 16:43:54.000000000 -0500 +++ function.mysql-fetch-array.new.html 2004-02-23 13:08:26.000000000 -0500 @@ -144,7 +144,7 @@ ></A ><P ><B ->Example 1. Query with duplicate field names</B +>Example 1. Query with aliased duplicate field names</B ></P ><TABLE BORDER="0" @@ -154,7 +154,7 @@ ><TD ><PRE CLASS="sql" ->select table1.field as foo, table2.field as bar from table1, table2</PRE +>SELECT table1.field AS foo, table2.field AS bar FROM table1, table2</PRE ></TD ></TR ></TABLE @@ -432,4 +432,4 @@ ></DIV ></BODY ></HTML -> \ No newline at end of file +> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27369&edit=1
