Wow, our posts crossed in the mail and you suggested the same approach that I discovered independently! (Great minds think alike, right?) I'm working remotely, the server is many states away, and I don't have a local developement environment. I'm modifying the actual working site, though I try to develop new modules in segregated files and rename the or cut and paste the changes into the live files. I don't have the resources to create a local development.
As I've said, I'm using phpMyAdmin with a browser working remotely. I'll see if the query works without the renaming modification after I build some php code to use it. I'm curious about why the front-end can introduce this problem. The query should be the same. The results from mysql should be the same. The display of the results, I can sort of understand, but why just the one column? I wonder what other surprises phpMyAdmin has in store for me. (I'll be using a lot of queries that self-reference the same table: "Places" where a record could be for a town, that belongs to another record for a county, that belongs to another record for a state, etc..) Thanks for the assistance! James At 7:01 PM -0500 1/12/02, Roger Baklund wrote: ---snip--- >ok... you are obviously using some kind of front-end tool, not the mysql >client. The is a html character, in a browser it looks like a space >character. It is used in html to prevent a linebreak at that position. > >Some frontend tools may have a problem with multiple fields with the same >name. Try this: > >SELECT L.Name as LName, C.Name as CName ... > >> Here are the dumps: > >I took a quick look, seems ok. I think the above name issue is your problem. >You should always try your queries in the mysql client, to eliminate >problems related to the front-end tool or script. > >-- >Roger --------------------------------------------------------------------- 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