On Wed, Jan 28, 2009 at 4:31 PM, Terion Miller <webdev.ter...@gmail.com> wrote:
> On Wed, Jan 28, 2009 at 3:22 PM, Christoph Boget <christoph.bo...@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
>>
> I just read it 3 times and I don't understand it.
>
Try this... (just make sure to assign a valid $username value.)
$sql =
"SELECT workorders.WorkOrderID , workorders.AdminID
FROM workorders
INNER JOIN
admin
ON workorders.AdminID = admin.AdminID
WHERE admin.UserName = '" . mysql_real_escape_string($username) . "'";
Andrew
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
