UPDATE right rows when the right values matches

Chrysanthus

Hello all.

Im new at this with IF statments in mysql and im trying to make this work but the problem is that i can get i to work and i do not know why it dosent work.

I lookit IF up on mysql.com but thay dident have any good exampels that matched my senarion sow now im here

Is there some one how can help me with this to get it to work?..

<?
function changerel() {


$new_comment = htmlspecialchars($_POST['fed_comment']);
$new_friendship = htmlspecialchars($_POST['fed_rel']);
mysql_query("UPDATE friend_list SET 

rel_accID = IF(fd_accID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]', fd_accID_value='yes', fd_reqID_value='no', fd_accID_cmt='$new_comment'),

rel_reqID = IF(fd_reqID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]', fd_reqID_value='yes', fd_accID_value='no', fd_reqID_cmt='$new_comment'), 
fd_type='$new_friendship', fd_valid='no' 

WHERE (fd_reqID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]' OR fd_accID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]') AND ID='$_GET[fdID]'");

if (mysql_error() != "") {
echo mysql_error();
exit;
}
?>

lilleman

Hi,

The syntax for the IF statement is this.

IF(--expression--, --if true--, --if false--)

So, if you want to use it in an UPDATE query, you should use like shown in the example below.

UPDATE table SET field = IF(a_field='a_value', 'value_when_true', 'value_when_false')

Let me know if you need more specific help.

Yours, Erik.

Chrysanthus

Tja.

I will keep this in eng sow every on can read.

But if a wont to match one specifid row with a matching value and then change another row's if the if statment matches how do i manage that or is that possibel or not?

see this code! okay it doset work but i followed mysql.com man and i did that and it still dosent get it to work why do i not know of.

// mysql.com man
IF search_condition THEN statement(s)
[ELSEIF search_condition THEN statement(s)]
...
[ELSE statement(s)]
END IF

my exampel.

<?
$new_comment = htmlspecialchars($_POST['fed_comment']);
$new_friendship = htmlspecialchars($_POST['fed_rel']);
mysql_query("
	IF 
		fd_accID='$_SESSION[regid]' 
	AND 
		fd_reqID='$_GET[usernameID]' 
	THEN UPDATE 
		friend_list SET fd_accID_value='yes', fd_reqID_value='no', fd_accID_cmt='$new_comment', fd_type='$new_friendship' fd_valid='no' 
	ELSEIF
		fd_accID='$_GET[usernameID]' 
	AND 
		fd_reqID='$_SESSION[regid]' 
	THEN UPDATE 
		friend_list
	SET 
		fd_valid='no', fd_reqID_value='yes', fd_accID_value='no',fd_reqID_cmt='$new_comment', fd_type='$new_friendship'
	WHERE 
		ID='$_GET[fdID]'
	ENDIF");
if (mysql_error() != "") {
echo mysql_error();
exit;
}
?>