rainman89
I cant find the any key..
- Local time
- Today, 01:58
- Joined
- Feb 12, 2007
- Messages
- 3,015
Hi all,
I am writing php script to return the results from a query that I wrote in sql, but am getting the "too few parameters. expected 1" error.
The query runs fine in access, but in when I insert it into the php script to return the results, I get the error.
This is the code.
If i test it with only one table (tblEmployee), I get the results I am supposed to get, adding the 2nd table seems to mess it up.
Any help would be appreciated.
I am writing php script to return the results from a query that I wrote in sql, but am getting the "too few parameters. expected 1" error.
The query runs fine in access, but in when I insert it into the php script to return the results, I get the error.
This is the code.
Code:
SELECT tblEmployee.EmployeeUserName, tblEmployee.EmployeeID, tblRequest.Approval, tblRequest.RequestDate
FROM tblEmployee INNER JOIN tblRequest ON tblEmployee.EmployeeID = tblRequest.EmployeeID
WHERE (((tblEmployee.EmployeeUserName)='$username'));
If i test it with only one table (tblEmployee), I get the results I am supposed to get, adding the 2nd table seems to mess it up.
Any help would be appreciated.