Give suggestions for nested query...

[tharini]

mysql_query("select * from member_details where name='".$name."' or wife_name='".$name."' and ( hus_dob='".$date."' or wife_dob='".$date."' or wedding_day='".$date."'")) or die(mysql_error());

is my query syntax right? if not please tell me the correct syntax.

[code green]

We are not proof-readers.
Please state a problem or error

[mwasif]

The problem was with the double quotes. See the correct code below
[CODE=php]mysql_query("se lect * from member_details where name='".$name." ' or wife_name='".$n ame."' and ( hus_dob='".$dat e."' or wife_dob='".$da te."' or wedding_day='". $date."')" ) or die(mysql_error ());[/CODE]

I don't know if you still have problem with the query. To get quick response always state the error you are facing.