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 "<tr><td>$row[UName]</td><td>$row[FName] $row[LName]</td>$row[cname]<td></td></tr>"; } 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
