Jump to content

Archived

This topic is now archived and is closed to further replies.

aleminio

using SELECT command.

Recommended Posts

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?

Share this post


Link to post
Share on other sites
[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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.