Re: Making a Variable from different tables with Matching Db fields?
| From: | Christoph Boget | Date: | Wed, 28 Jan 2009 21:22:53 +0000 |
| Subject: | Re: Making a Variable from different tables with Matching Db fields? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287313@lists.php.net to get a copy of this message | ||
> 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