Need help !! Using Concat Function with Posgres and PHP
Posted: Wed Aug 20, 2003 2:37 pm
Hi,
I am new to posgres. I am trying to figure out how to use the concat function for my query as below:-
This query is for a search function which searches employee by their last and first name. The reason why i want to do the concat function is to enable the users to search both first and last name together (with a space). This query works well with mysql but with posgres .. it is showing me and error.. I have tried using the (||) but yet I do get an error. Any help is highly appreciated.
$emp
-----
Is the search field name I have given in the form.
Thank You
I am new to posgres. I am trying to figure out how to use the concat function for my query as below:-
This query is for a search function which searches employee by their last and first name. The reason why i want to do the concat function is to enable the users to search both first and last name together (with a space). This query works well with mysql but with posgres .. it is showing me and error.. I have tried using the (||) but yet I do get an error. Any help is highly appreciated.
Code: Select all
<?php
$query = "
Select employee.empid, employee.fname, employee.lname, emp_info.phone, department.name
FROM employee, department, emp_info
WHERE lname='$emp' OR fname ='$emp'
OR concat (lname,'',fname) ='$emp'
AND employee.empid = emp_info.empid
AND department.deptid = emp_info.deptid
ORDER by employee.fname
";
?>-----
Is the search field name I have given in the form.
Thank You