The problem is that array keys are case sensitive. You can use what you've
got, but the case has to match what you're selecting in your query. I see
you are trying to use $row['UName'] but I don't see you selecting that in
your query.
---John Holmes...
- Original Message -
From: "Timothy J Hitchens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 9:33 AM
Subject: RE: [PHP] NewB PHP / mysql Q
> Try this..
>
> select u.id, u.lname as lastname, u.frname as firstname, ... etc
>
> oh and the reason you get an error is that you can't have a dot in a
> variable etc...
>
>
>
> Timothy Hitchens (HITCHO)
> [EMAIL PROTECTED]
>
> HITCHO has Spoken!
>
>
>
>
>
>
> -Original Message-
> From: inpho [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 10 October 2002 4:19 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] NewB PHP / mysql Q
>
>
> Hi all,
>
> I need a bit of quick help here
> I've joined 2 tables together with this code here:
>
> $result=mysql_query("select u.id, u.cid, u.lname, u.fname, u.vld, c.id,
> c.cname from tblclient u, tblcompany c where u.vld=1 and u.cid =
> c.id",$db);
>
> then I put it into an array:
>
> while ($row=mysql_fetch_array($result)) {
> print "$row[UName]$row[FName]
> $row[LName]$row[cname]";
> }
>
> but the $row[xxx] aren't displaying any info, if I put $row[u.unam] it
> returns an error. I run the SQL query in phpmyadmin and it runs fine,
> returning 2 results how do I access those results through an array???
>
> - inpho -
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
