MySQL Problem

[Anon]

I have a table structure such as:

ID|fieldname|fieldvalue
1|name|jon
1|email|[e-mail]
2|name|jon
2|[e-mail]
3|name|jon
3|[e-mail]

What I'm trying to do is query in WHERE name=jon and email=[e-mail], but I need the ID of rows that matches the entire WHERE clause.

I was trying something like:

SELECT * FROM table WHERE (table.fieldname='jon' AND table.fieldvalue='jon') OR (table.fieldname='email' AND table.fieldvalue='[e-mail]');

I'm getting the results, but I'm trying to figure out how to pull out the rows that matched the WHERE clause.

[junebug]

first change the way you set up your table. repeating data is bad. set it up like this:

ID | name | email

now your select statement is very simple:

select name, email from table where ID = 1;

or whatever the id number may be. the way your tables are set up is a waste of space. look at changing them.

[Anon]

Yea, but the way the application is designed, the ID ties to another ID on another table. fieldname and fieldvalue are the actual column name because it's used to generate dynamic form fields. The problem lies in performing a search across the table.