Advanced recordset (PHP/MySQL)

[davecheet]

I'd like to be able to create a recordset that takes two form variables and
returns only the records that match those two variables exactly. I know how to
do it easily for one form variable in the simple recordset dialogue box but as
soon as I step up to the advanced level, I'm stumped. at the moment I have
the single variable version which looks something like this: SELECT * FROM
table_1 WHERE field1='form_variable1' Can anyone help me expand the above?

[David Powers]

davecheet wrote:

> the single variable version which looks something like this: SELECT * FROM
> table_1 WHERE field1='form_variable1' Can anyone help me expand the above?

SELECT * FROM table_1
WHERE field1 = 'form_variable1'
AND field2 = 'form_variable2'


--
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]