Searching with multiple search parameters PHP

[vaene]

I am attempting to build a multiple parameter search/result page in
dreamweaver using php. I have been following along in the tutorial up until the
recordset insertion.

In step 5 of the tutorial "Searching with multiple search parameters" it says
to give a value for the runtime values and then lists off examples for ASP
Coldfusion and JSP but not PHP. AAARGH! Can anyone give me an example of what
a runtime value would look like in PHP? The SQL in the tutorial looks like this:

SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION ?
FROM EMPLOYEE WHERE LASTNAME LIKE 'varLastName' AND DEPARTMENT ?
LIKE 'varDept'

Thanks!

V

[David Powers]

vaene wrote:

> a runtime value would look like in PHP? The SQL in the tutorial looks like this:
>
> SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION ?
> FROM EMPLOYEE WHERE LASTNAME LIKE 'varLastName' AND DEPARTMENT ?
> LIKE 'varDept'

SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION
FROM EMPLOYEE WHERE LASTNAME LIKE '$lastName' AND DEPARTMENT
LIKE '$dept'

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]