[SOLVED] would this work?

[sandrob57]

would this work?

 

	$result = dbquery("SELECT war_id
FROM fusion_war
WHERE a_id='".$your_id."'
OR d_id='".$target_id."'
OR WHERE d_id='".$your_id."'
OR a_id='".$target_id."'");

[btherl]

No.. you will need to remove the extra "WHERE".  Apart from that it's fine.

 

Are you wanting to check two "AND" conditions with an "OR" between?  Rather than all "OR" ?

[btherl]

Assuming you want all wars between your_id and target_id:

 

	$result = dbquery("SELECT war_id
FROM fusion_war
WHERE (a_id='".$your_id."' AND d_id='".$target_id."' )
OR ( d_id='".$your_id."' AND a_id='".$target_id."' )");

[HaLo2FrEeEk]

Not that I know of, the proper syntax for a mysql query would be this:

 

$sql = mysql_query('SELECT `war_id`

                          FROM `fusion_war`

                          WHERE `a_id` = \''.$your_id.'\'

                          OR `d_id` = \''.$target_id.'\'

                          OR `d_id` = \''.$your_id.'\'

                          OR `a_id` = \''.$target_id.'\'');

 

You would then parse the result using mysql_result().

[TRI0N]

Well first off you don't need the periods..

 

$result = dbquery("SELECT war_id FROM fusion_war WHERE (a_id = '$your_id'	AND d_id = '$target_id') OR (d_id = '$your_id' AND a_id = '$target_id')");

[sandrob57]

Assuming you want all wars between your_id and target_id:

 

	$result = dbquery("SELECT war_id
FROM fusion_war
WHERE (a_id='".$your_id."' AND d_id='".$target_id."' )
OR ( d_id='".$your_id."' AND a_id='".$target_id."' )");

Thanks, that looks like it will work