Re: [PHP] Join question

2007-12-02 Thread Crayon Shin Chan
On Saturday 01 December 2007, chris smith wrote: Considering the rest of the off-topic questions that regularly get asked on this list it's a bit much to single out this one particular post. I didn't single it out, it just happened to be at the top of the pile at the the time. It was also

Re: [PHP] Join question

2007-12-02 Thread Crayon Shin Chan
On Sunday 02 December 2007, Daniel Brown wrote: There are a great deal of highly-intelligent people on this list, so why not take advantage of that resource? I do, that's why I'm on the list. So until you've been around enough to truly earn your right to tell someone far more

Re: [PHP] Join question

2007-12-02 Thread tedd
At 6:24 AM +0800 12/3/07, Crayon Shin Chan wrote: It was also helped by the fact that the OP, who is apparently, renowned for programming in rocks since the time before binary was invented, ought to know list etiquette better than most. That's world renowned, if you please. :-) But just to

Re: [PHP] Join question

2007-12-01 Thread Jochem Maas
Crayon Shin Chan wrote: On Friday 30 November 2007, Jochem Maas wrote: ... So let me get this straight, only paid up members of the old boys club are allowed to make off-topic posts? The rest can lump it? if by the rest you mean you, then yes, absolutely, please crawl back under the

Re: [PHP] Join question

2007-12-01 Thread Jochem Maas
Jay Blanchard wrote: [snip] If you try you can probably make a connection from php to everything under the sun, doesn't mean everything under the sun is an appropriate topic for this list. [/snip] The Oracle of PHP - 6 Degrees of Separation I joined PHP to Oracle, Kevin Bacon and

Re: [PHP] Join question

2007-12-01 Thread Jochem Maas
chris smith wrote: On Dec 1, 2007 3:53 PM, Crayon Shin Chan [EMAIL PROTECTED] wrote: On Saturday 01 December 2007, tedd wrote: At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. Really?

RE: [PHP] Join question

2007-12-01 Thread tedd
At 11:07 PM -0600 11/30/07, Jay Blanchard wrote: The Oracle of PHP - 6 Degrees of Separation I joined PHP to Oracle, Kevin Bacon and temperature all in one shot. Sounds like an omelette. :-) Tedd, what did you want to know about joins? I think I got it -- at least for the problem that

Re: [PHP] Join question [solved]

2007-12-01 Thread Daniel Brown
On Nov 30, 2007 10:00 PM, tedd [EMAIL PROTECTED] wrote: At 2:00 PM +1100 11/30/07, Chris wrote: Out of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a version issue. There really

Re: [PHP] Join question

2007-12-01 Thread Daniel Brown
On Nov 30, 2007 11:53 PM, Crayon Shin Chan [EMAIL PROTECTED] wrote: You ought to know by now that there is the php-db list. Even so your question doesn't belong even there because it has zilch to do with php, but it is still slightly more appropriate to post there than here. Put on your

Re: [PHP] Join question

2007-11-30 Thread tedd
At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. -- Crayon Really? No language lives in a vacuum, mate. Especially, a web language. IMO, one of the major attributes that make PHP

Re: [PHP] Join question [solved]

2007-11-30 Thread tedd
At 9:52 AM -0500 11/30/07, Daniel Brown wrote: On Nov 29, 2007 11:17 PM, Robert Cummings [EMAIL PROTECTED] wrote: Rob, The version difference is probably right on the nose. If I remember correctly, you couldn't do that in the long-popular 3.23, which *gasp!* is still used by some web

Re: [PHP] Join question

2007-11-30 Thread Crayon Shin Chan
On Saturday 01 December 2007, tedd wrote: At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. Really? Really. No language lives in a vacuum, mate. Especially, a web language. If

Re: [PHP] Join question

2007-11-30 Thread Crayon Shin Chan
On Friday 30 November 2007, Robert Cummings wrote: I'm sorry, allow me to rephrase... in the past 5 months you've made 2 on-topic useful posts, with the rest either being on-topic for an off-topic thread, or completely off-topic. I see no point in saying more, I've made my point. I know your

Re: [PHP] Join question

2007-11-30 Thread Crayon Shin Chan
On Friday 30 November 2007, Jochem Maas wrote: my guess it took less time to search for 'Crayon' in his mail archive than it took you to write the sentence. Is not so much the actual time taken but rather that he had the free time at all. aparently Rob wasn't saying this ... but I would,

RE: [PHP] Join question

2007-11-30 Thread Jay Blanchard
[snip] If you try you can probably make a connection from php to everything under the sun, doesn't mean everything under the sun is an appropriate topic for this list. [/snip] The Oracle of PHP - 6 Degrees of Separation I joined PHP to Oracle, Kevin Bacon and temperature all in one shot.

Re: [PHP] Join question

2007-11-30 Thread tedd
At 12:53 PM +0800 12/1/07, Crayon Shin Chan wrote: On Saturday 01 December 2007, tedd wrote: At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. Really? Really. No language

Re: [PHP] Join question

2007-11-30 Thread Daniel Brown
That it is, Steve. That it is. And because of the occasion, I feel justified in celebrating by top-posting. TFGIF! On Nov 30, 2007 12:58 PM, Steve Edberg [EMAIL PROTECTED] wrote: At 10:30 AM -0500 11/30/07, Daniel Brown wrote: On Nov 30, 2007 10:22 AM, Jochem Maas [EMAIL

Re: [PHP] Join question [solved]

2007-11-30 Thread tedd
At 2:00 PM +1100 11/30/07, Chris wrote: Out of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a version issue. There really shouldn't be a problem updating a table that also occurs

Re: [PHP] Join question

2007-11-30 Thread Daniel Brown
On Nov 30, 2007 10:22 AM, Jochem Maas [EMAIL PROTECTED] wrote: Daniel Brown wrote: I was tempted to flame Tedd just because he's Tedd. ;-P lol. but then the guy was programming Rocks(tm) way before I was born, that has to count for something :-) Please keep all replies on the

RE: [PHP] Join question

2007-11-30 Thread Andrés Robinet
-Original Message- From: tedd [mailto:[EMAIL PROTECTED] Sent: Saturday, December 01, 2007 2:09 AM To: Crayon Shin Chan; php-general@lists.php.net Subject: Re: [PHP] Join question At 12:53 PM +0800 12/1/07, Crayon Shin Chan wrote: On Saturday 01 December 2007, tedd wrote: At 10

Re: [PHP] Join question [solved]

2007-11-30 Thread Wolf
tedd [EMAIL PROTECTED] wrote: Hi gang: I found why the JOIN didn't work for me in this instance, which was I needed to create a third table and JOIN what I needed in that table from the other two. My problem was that I was trying to alter one of the tables in the JOIN. While

Re: [PHP] Join question

2007-11-30 Thread Daniel Brown
On Nov 30, 2007 8:08 AM, Jochem Maas [EMAIL PROTECTED] wrote: Crayon Shin Chan wrote: On Friday 30 November 2007, Robert Cummings wrote: That's an amusing statement. I took a peek back in time and noticed that in the past 5 months you've only made two on-topic useful posts to the PHP

Re: [PHP] Join question [solved]

2007-11-30 Thread Daniel Brown
On Nov 29, 2007 11:17 PM, Robert Cummings [EMAIL PROTECTED] wrote: On Fri, 2007-11-30 at 14:00 +1100, Chris wrote: Out of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a

Re: [PHP] Join question

2007-11-30 Thread Jochem Maas
Crayon Shin Chan wrote: On Friday 30 November 2007, Robert Cummings wrote: That's an amusing statement. I took a peek back in time and noticed that in the past 5 months you've only made two on-topic useful posts to the PHP General list-- and they were both for the same thread. If you have

Re: [PHP] Join question

2007-11-30 Thread chris smith
On Dec 1, 2007 3:53 PM, Crayon Shin Chan [EMAIL PROTECTED] wrote: On Saturday 01 December 2007, tedd wrote: At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. Really? Really.

Re: [PHP] Join question

2007-11-30 Thread Jochem Maas
Daniel Brown wrote: On Nov 30, 2007 10:22 AM, Jochem Maas [EMAIL PROTECTED] wrote: Daniel Brown wrote: I was tempted to flame Tedd just because he's Tedd. ;-P lol. but then the guy was programming Rocks(tm) way before I was born, that has to count for something :-) Please keep

Re: [PHP] Join question

2007-11-30 Thread Steve Edberg
At 10:30 AM -0500 11/30/07, Daniel Brown wrote: On Nov 30, 2007 10:22 AM, Jochem Maas [EMAIL PROTECTED] wrote: Daniel Brown wrote: I was tempted to flame Tedd just because he's Tedd. ;-P lol. but then the guy was programming Rocks(tm) way before I was born, that has to count for

[PHP] Join question

2007-11-29 Thread tedd
Hi gang: I'm trying to understand joins, Here's the situation. I have two tables (user1, user2) in one database: The common field between the two tables is username. I want to take fields login and password from user2 and populate the same fields in user1. Currently, the table user1 has

Re: [PHP] Join question

2007-11-29 Thread Robert Cummings
On Thu, 2007-11-29 at 15:41 -0500, tedd wrote: Hi gang: I'm trying to understand joins, Here's the situation. I have two tables (user1, user2) in one database: The common field between the two tables is username. I want to take fields login and password from user2 and populate the same

Re: [PHP] Join question

2007-11-29 Thread Daniel Brown
On Nov 29, 2007 3:41 PM, tedd [EMAIL PROTECTED] wrote: Hi gang: Hi, Tedd. PS: Side note -- will safe_mode ON cause problems with this? Negative. I can't see any reason to even think so. All safe_mode does is check the UID/GID of the script to make sure it matches that of the target

Re: [PHP] Join question

2007-11-29 Thread Wolf
tedd [EMAIL PROTECTED] wrote: Hi gang: I'm trying to understand joins, Here's the situation. I have two tables (user1, user2) in one database: The common field between the two tables is username. I want to take fields login and password from user2 and populate the same fields

Re: [PHP] Join question

2007-11-29 Thread Robert Cummings
On Thu, 2007-11-29 at 15:47 -0500, Wolf wrote: tedd [EMAIL PROTECTED] wrote: Hi gang: I'm trying to understand joins, Here's the situation. I have two tables (user1, user2) in one database: The common field between the two tables is username. I want to take fields login

Re: [PHP] Join question

2007-11-29 Thread tedd
At 4:11 PM -0500 11/29/07, Robert Cummings wrote: Grep? Loop? A single query will suffice. Also, he doesn't mention wanting to clobber the passwords in table1 when the username does already exist. Cheers, Rob. Table1 passwords and logins are not populated. I want to take those appearing in

Re: [PHP] Join question [solved]

2007-11-29 Thread tedd
Hi gang: I found why the JOIN didn't work for me in this instance, which was I needed to create a third table and JOIN what I needed in that table from the other two. My problem was that I was trying to alter one of the tables in the JOIN. While that might be possible it didn't appear so in

Re: [PHP] Join question

2007-11-29 Thread Crayon Shin Chan
On Friday 30 November 2007, Robert Cummings wrote: That's an amusing statement. I took a peek back in time and noticed that in the past 5 months you've only made two on-topic useful posts to the PHP General list-- and they were both for the same thread. If you have that much free time on your

Re: [PHP] Join question

2007-11-29 Thread Robert Cummings
On Fri, 2007-11-30 at 10:21 +0800, Crayon Shin Chan wrote: On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. That's an amusing statement. I took a peek back in time and noticed that in the past 5 months you've only made two on-topic

Re: [PHP] Join question [solved]

2007-11-29 Thread Robert Cummings
On Thu, 2007-11-29 at 18:43 -0500, tedd wrote: Hi gang: I found why the JOIN didn't work for me in this instance, which was I needed to create a third table and JOIN what I needed in that table from the other two. My problem was that I was trying to alter one of the tables in the

Re: [PHP] Join question [solved]

2007-11-29 Thread Chris
Out of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a version issue. There really shouldn't be a problem updating a table that also occurs in the select query since the select

Re: [PHP] Join question

2007-11-29 Thread Robert Cummings
On Fri, 2007-11-30 at 11:00 +0800, Crayon Shin Chan wrote: On Friday 30 November 2007, Robert Cummings wrote: That's an amusing statement. I took a peek back in time and noticed that in the past 5 months you've only made two on-topic useful posts to the PHP General list-- and they were

Re: [PHP] Join question [solved]

2007-11-29 Thread Robert Cummings
On Fri, 2007-11-30 at 14:00 +1100, Chris wrote: Out of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a version issue. There really shouldn't be a problem updating a table that

Re: [PHP] Join question

2007-11-29 Thread Crayon Shin Chan
On Friday 30 November 2007, tedd wrote: I'm trying to understand joins, Ask on a database related list. -- Crayon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Join question

2007-11-29 Thread Crayon Shin Chan
On Friday 30 November 2007, Robert Cummings wrote: Or are you saying that one needs to make a lot of on-topic posts to build up credit in order to be able to make off-topic posts? No, I'm merely pointing out the hypocrisy. That would only be true if I had been making off-topic posts. But so

Re: [PHP] Join question

2007-11-29 Thread Robert Cummings
On Fri, 2007-11-30 at 13:49 +0800, Crayon Shin Chan wrote: On Friday 30 November 2007, Robert Cummings wrote: Or are you saying that one needs to make a lot of on-topic posts to build up credit in order to be able to make off-topic posts? No, I'm merely pointing out the hypocrisy.

RE: [PHP] mySQL / PHP Join Question

2001-09-09 Thread Don Read
On 09-Sep-2001 Dana Holt wrote: I have a query that uses a LEFT JOIN, but the two tables have some columns with the same name. How can I tell the columns from each table apart? It seems that the joined table overwrites the values from the other table. If the column is part of the join

Re: [PHP] mySQL / PHP Join Question

2001-09-09 Thread David Robley
On Sun, 9 Sep 2001 13:34, Dana Holt wrote: I have a query that uses a LEFT JOIN, but the two tables have some columns with the same name. How can I tell the columns from each table apart? It seems that the joined table overwrites the values from the other table. Anyone know? Thanks. --

[PHP] mySQL / PHP Join Question

2001-09-08 Thread Dana Holt
I have a query that uses a LEFT JOIN, but the two tables have some columns with the same name. How can I tell the columns from each table apart? It seems that the joined table overwrites the values from the other table. Anyone know? Thanks. -- Dana Holt / [EMAIL PROTECTED] -- PHP General