using SELECT command.

[aleminio]

logical, here is what i need to write:
[code=php:0]
Select * from $log where date = $date AND [ ( name1= $n1 AND name2 = $n2) OR (name1 = $n2 AND name2 = $n2)]

[/code]
how can i write it as php select command?

[obsidian]

[quote author=aleminio link=topic=101981.msg404143#msg404143 date=1153943138]
logical, here is what i need to write:
[code=php:0]
Select * from $log where date = $date AND [ ( $n1=name1 and $n2 =name2) OR ($n2=name1 and $n2 = name2) ]

[/code]
how can i write it as php select command?
[/quote]

where $date is in YYYY-MM-DD format:
[code]
<?php
$sql = "SELECT * FROM $log WHERE date = '$date' AND ((name1 = '$n1' AND name2 = '$n2) OR (name1 = '$n2' AND name2 = '$n1'))";
?>
[/code]

[aleminio]

the date is Y n j
and thanks.