Apache/2.0.53 (Win32) PHP/5.2.1
I have a table called "client" in my database.
When I tried to join the "client" table using alias with any table:
"SELECT * FROM client c, asset a WHERE c.id=a.cid"
phpMyAdmin 2.9.2 produce a warning and query failed:
Warning: Cannot modify header information - headers already sent by (output started at C:\Apache\Apache2\htdocs\phpMyAdmin\libraries\header_meta_style.inc.php:27) in C:\Apache\Apache2\htdocs\phpMyAdmin\libraries\common.lib.php on line 1154
Even when I run a query:
"SELECT * FROM client c"
the same warning produced by phpMyAdmin.
However, when you removed the alias or add the word AS (client AS c), the query run normally as expected.
I tried to download and upgrade my phpMyAdmin to version 2.10.0.1, and the query still didn't run (failed). It didn't produce the warning, but didn't do anything.
Logged In: YES
user_id=210714
Originator: NO
Fixed in subversion, thanks for reporting.