Re: [PHP] NewB PHP / mysql Q

2002-10-10 Thread 1LT John W. Holmes
iginal 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

RE: [PHP] NewB PHP / mysql Q

2002-10-10 Thread Timothy J Hitchens
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 f

[PHP] NewB PHP / mysql Q

2002-10-10 Thread inpho
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_fet