[SOLVED] Help with an IF statement

[rcorrigal]

Help me please. What am I doing wrong? Thanks!

 

$query = "REPLACE INTO Students (studentname, teacherid, organization, grade, p1F6, p1G6, p1H6, p1I6, moddate, ID) VALUES ('$data[p1B6]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F6]', '$data[p1G6]', '$data[p1H6]', '$data[p1I6]', NOW(), '$data[p1A6]'), ('$data[p1B7]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F7]', '$data[p1G7]', '$data[p1H7]', '$data[p1I7]', NOW(), '$data[p1A7]'), ('$data[p1B8]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F8]', '$data[p1G8]', '$data[p1H8]', '$data[p1I8]', NOW(), '$data[p1A8]') ";

$hasill=mysql_db_query($db_name, $query) or die (mysql_error());

IF (studentname == '') { mysql_db_query($db_name, "UPDATE Students SET active = 'disable'");}

return $data[error];

[waynew]

Eh, what's not working for you? What do you expect to happen? What should happen? What is happening? Cmon, spit it out good sir!

[rcorrigal]

Oops forgot to add the else too... but I want it to check it there is data being entered in the studentname field and if not add 'disable' in the active column or else add 'active'. Thanks!

[kickstart]

Hi

 

Presume studentname is a variable

 

IF ($studentname == '') { mysql_db_query($db_name, "UPDATE Students SET active = 'disable'");}

 

All the best

 

Keith

[rcorrigal]

Like this? It's not working properly. It changes all of the fields to 'disable'.

 

$studentnames = mysql_result(mysql_db_query($db_name, "SELECT studentname FROM Students WHERE teacherid='$data[login]'"),0);

}

$query = "REPLACE INTO Students (studentname, teacherid, organization, grade, p1F6, p1G6, p1H6, p1I6, moddate, ID) VALUES ('$data[p1B6]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F6]', '$data[p1G6]', '$data[p1H6]', '$data[p1I6]', NOW(), '$data[p1A6]'), ('$data[p1B7]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F7]', '$data[p1G7]', '$data[p1H7]', '$data[p1I7]', NOW(), '$data[p1A7]'), ('$data[p1B8]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F8]', '$data[p1G8]', '$data[p1H8]', '$data[p1I8]', NOW(), '$data[p1A8]') ";

$hasill=mysql_db_query($db_name, $query) or die (mysql_error());

IF ($studentnames == '') { mysql_db_query($db_name, "UPDATE Students SET active = 'disable'");} ELSE { mysql_db_query($db_name, "UPDATE Students SET active = 'enable'");}

return $data[error];

}

[rcorrigal]

SOLVED!

 

$query = "REPLACE INTO Students (studentname, teacherid, organization, grade, p1F6, p1G6, p1H6, p1I6, moddate, ID) VALUES ('$data[p1B6]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F6]', '$data[p1G6]', '$data[p1H6]', '$data[p1I6]', NOW(), '$data[p1A6]'), ('$data[p1B7]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F7]', '$data[p1G7]', '$data[p1H7]', '$data[p1I7]', NOW(), '$data[p1A7]'), ('$data[p1B8]', '$data[login]', '$data[organization]', '$data[grade]', '$data[p1F8]', '$data[p1G8]', '$data[p1H8]', '$data[p1I8]', NOW(), '$data[p1A8]') ";

$hasill=mysql_db_query($db_name, $query) or die (mysql_error());

IF ($studentname == '') { mysql_db_query($db_name, "UPDATE Students SET active = 'disable' WHERE studentname='' AND teacherid='$data[login]'") or die (mysql_error());} ELSE { mysql_db_query($db_name, "UPDATE Students SET active = 'enable' WHERE teacherid='$data[login]'") or die (mysql_error());}

return $data[error];