Need help with If and Where command

[jacklenasia]

Hi all

 

I've got 2 tables... Lets say tableA and tableB

I want to do this, but I dont know if it is possible:

 

<?php if ($x_tableA_FIELD == "green") { ?>

 

echo "$x_tableB_FIELD1" WHERE $x_tableB_FIELD2 == "green"

 

<?php } ?>

 

 

So I know the if part works... can this WHERE part work?

And what would the syntax be?

[Barand]

Sounds like you need query like this

 

SELECT b.field1 
FROM tableA a INNER JOIN tableB b ON a.field = b.field2
WHERE a.field = 'green'

[BigNaz]

I will warn you now, I am still new here but I think I understood the above (correct me if I am wrong)...

 

From what I took from your post, another alternative may be the following:

if($x_tableA_field == "green") {
    $sql = "SELECT FIELD1 FROM tableB WHERE FIELD2='" . $x_tableA_field . "'";
    $res = mysql_query($sql);
    $row = mysql_fetch_assoc($res);
    echo $row;
}

 

Hope this helps...

 

BigNaz