PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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.
<?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
";
?>
$emp
-----
Is the search field name I have given in the form.
<?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 (employee.lname || ' ' || employee.fname) ='$emp'
AND employee.empid = emp_info.empid
AND department.deptid = emp_info.deptid
ORDER by employee.fname
";
?>
i guess that works. but not so sure, i have been using 7.3.1 version of postgresql and having no problem with the double pipe for concat purposes.