ID: 27369 User updated by: nospam at webdragon dot net Reported By: nospam at webdragon dot net -Status: Bogus +Status: Open Bug Type: Documentation problem Operating System: Linux (Fedora Core 1) PHP Version: Irrelevant New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [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
