Re: Making a Variable from different tables with Matching Db fields?
| From: | Terion Miller | Date: | Wed, 28 Jan 2009 21:31:13 +0000 |
| Subject: | Re: Making a Variable from different tables with Matching Db fields? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287314@lists.php.net to get a copy of this message | ||
I just read it 3 times and I don't understand it.
On Wed, Jan 28, 2009 at 3:22 PM, Christoph Boget
<christoph.boget@gmail.com>wrote:
> > Well I'm stuck I have the AdminID but now I can't seem to use it to pull
> > workorders with that AdminID . I couldn't get your block to work Andrew
> :(
> > I think I'm just not using it right now that I have it...lol
>
> Because there is ambiguity w/r/t the columns you are selecting, you'll
> need to use aliases.
>
> http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
>
> In your code, when you are referencing the column, do so using the
> alias. That should solve your problem.
>
> thnx,
> Christoph
>
>