Help please!
| From: | Wee Chua | Date: | Thu, 09 Nov 2000 16:30:23 +0000 |
| Subject: | Help please! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24507@lists.php.net to get a copy of this message | ||
Hi all,
I have a problem for using concat fname and lname to become fullname field
from the query, is it possible I could do the
string comparison after concat funtion, thanks a lot. I have tried the
example below but it didn't work. Could anyone tell me
is there any errors in my codes or could I do it in different way for not
repeatedly displaying fullname? Thank you very much.
for example,
$result=mysql_query("SELECT concat(fname,' ',lname) fullname, ... FROM
tablename",$db);
$data=mysql_fetch_row($result);
$data=$row('fullname');
if ($data!==$old)
{ echo "$data";
$old=$data;
} else { echo " "; }
regards;
Calvin