Re: UPDATE and redirect

marcelo Wolfgang skrev:

Hi all, I'm new to this list and new to php programming so sorry if I do something wrong here :) Ok, now to my problem. I've created a query to update a mysql db, and it isn't working, and it's not throwing me any errors, so I need some help to figure out what's wrong here. My code follows : <? if($_GET['act'] = 'a'){

    $action = 1;

} else if ($_GET['act'] = 'd'){

    $action = 0;

}

Don't use "=", use "==" (or in some cases "==="). "=" is for assignment. Also, what if $_GET['act'] is neither 'a' or 'd'?

$id = $_GET['id'];

Again, what if $_GET['id'] is null?

mysql_connect("localhost","XXXX","XXXX") or die (mysql_error()); mysql_select_db ("taiomara_emailList");

$email_Query = mysql_query("UPDATE 'tb_emails' SET 'bol_active' = $action WHERE auto_id = $id");

Use backticks if you think you need them In this case you don't $sql = "UPDATE tb_emails SET bol_active = $action WHERE auto_id = $id"; echo "DEBUG: $sql"; $email_Query = mysql_query( $sql ); This is how to get the error: if ( !$email_Query ) echo mysql_error();

mysql_close(); ?> The page is executed, but it don't update the table ... I've tried with the '' and without it ( the phpmyadmin page is where I got the idea of using the '' ). Any clues ? Also, how can I make a redirect after the query has run ?

header("Location: http://www.foooooobar.com"); Will work as long as you don't print out any output whatsoever to the browser before this line of code.

TIA Marcelo Wolfgang

/T