Databases
StackOverflow2013
Postsdbo
POWhats wrong with this PHP IF statement?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhats wrong with this PHP IF statement?
    primarykey
    data
    text
    <p>I've got a PHP IF statement to save different SQL results in a PHP variable ($sql) based on the IF conditions, but it keeps returning SQL results based on just one condition (the first one), regardless of what the user enters in the POST'd values. </p> <p>All of the SQL statements work as expected when entered into phpMyAdmin individually (whilst changing the $row3 and $row4 to actual values that exist), just not with the PHP IF statement. </p> <p>Can anyone see what I'm doing wrong here, and if possible advise what I need to do differently? I know I'm no PHP / MySQL expert, but I'm stumped :(</p> <p>Any help or suggestions is greatly appreciated. Thanks in advance. </p> <pre><code>$row3 = $_POST['groups']; $row4 = $_POST['othercode-all']; IF ($row3='-all-' &amp;&amp; ($row4='-all-')) { $sql ="SELECT email, accountgroup, othercode FROM (SELECT email AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email2 AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email3 AS email, accountgroup, othercode FROM accounts) account WHERE email LIKE '%@%'"; } ELSEif ($row3!='-all-' &amp;&amp; ($row4='-all-')) { $sql ="SELECT email, accountgroup, othercode FROM (SELECT email AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email2 AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email3 AS email, accountgroup, othercode FROM accounts) account WHERE email LIKE '%@%' AND accountgroup = '$row3'"; } ELSEIF ($row4 != '-all-' &amp;&amp; ($row3 = '-all-')) { $sql ="SELECT email, accountgroup, othercode FROM (SELECT email AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email2 AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email3 AS email, accountgroup, othercode FROM accounts) account WHERE email LIKE '%@%' AND othercode = '$row4'"; } ELSE { $sql ="SELECT email, accountgroup, othercode FROM (SELECT email AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email2 AS email, accountgroup, othercode FROM accounts UNION ALL SELECT email3 AS email, accountgroup, othercode FROM accounts) account WHERE email LIKE '%@%' AND accountgroup = '$row3' AND othercode = '$row4'"; } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser2968514
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhats wrong with this PHP IF statement?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhats wrong with this PHP IF statement?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhats wrong with this PHP IF statement?
      1. This table or related slice is empty.
      1. VTDownMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload