SQL question

[siwy]

how would you make this work?

"SELECT * FROM games WHERE `ref` = '$fullname' OR AR1 = '$fullname' OR AR2 = '$fullname' AND refaccept='' AND AR1accept='' AND AR2accept='' ORDER BY date ASC";

[stolzyboy]

is there a problem with this query, not what you expect, error??, what do you want to do, etc....more information please

[siwy]

the first part works great but then i want to select only the records that were not accepted AND refaccept='' AND AR1accept='' AND AR2accept='' but it works only with the last AND AR2accept='' the other 2 come through.

[kilbey1]

perhaps you're pulling too much information back?

If you're using phpmyadmin, you can copy the sql statement and paste it into the SQL box. Otherwise, try echoing out your sql, ie:

$sql = "SELECT * FROM games WHERE `ref` = '$fullname' OR AR1 = '$fullname' OR AR2 = '$fullname' AND refaccept='' AND AR1accept='' AND AR2accept='' ORDER BY date ASC";
echo $sql;

...just so you can see what information is being pulled out of your database. Narrow down as necessary.

[siwy]

here is how i did it. i assign defoult value to C and then

"SELECT * FROM games WHERE `ref` = '$fullname' AND `refaccept`='C' OR AR1 = '$fullname' AND Ar1accept = 'C' OR AR2 = '$fullname' AND AR2accept = 'C' ORDER BY date ASC";

problem solved