I'm a newbie to php and mysql database. I'm trying to create a recordset for a results page in dreamweaver. I have created this table called profile .From this table I have 20 columns. I have created a search page that will search for Gender,State, and Country which are 3 of these columns.
SELECT*
FROM profile
WHERE
The problem I have is creating the WHERE statment iin my recordset and also the dialog box on the bottom of the advanced recordset. All the books I have looked at only show where statments when your pulling from two tables and two columns. Thanks in Advace