[Resolved] Dissappearing $_GET[] value

[BigBadKev]

Hi all,

I have a nasty $GET[] problem

I redirect the php code using headers with the query string and all values echo out.

On the new page I do this :

echo $model_id = $GET['model_id']; //displays 1
echo $model_name = $GET['model_name']; //displays BMW

The values are displayed so all is good however when I try and re-use $model_id and $model_name like this :

 
$sql_stmt =
 "UPDATE model_part". 
" SET part_title = '$key', part_area = '$value'".
" WHERE model_name = '$model_id'".      

" AND model_id = '$model_name';";

The model id and name displays as empty string, what am I doing wrong? I have tried {$model_id} and '" {$model_id} "'

thanks in advance

BBK 🙂

[laserlight]

What if you simplify to remove the side-effects?

e.g.

$model_id = $_GET['model_id'];
echo $model_id;
$model_name = $_GET['model_name'];
echo $model_name;

or if this also does not work, then use something like:

$sql_stmt =
 "UPDATE model_part". 
" SET part_title = '$key', part_area = '$value'".
" WHERE model_name = '{$_GET[model_id]}'".      

" AND model_id = '{$_GET[model_name]}';";

[swr]

Let me guess: You're setting $model_id and $model name at the start of the script, but you are creating $sql_stmt inside a function. Am I right?

If that is the case, the problem and solution are described here:

http://ca.php.net/manual/en/language.variables.scope.php

[BigBadKev]

Hi all,

swr was correct...and I am red faced, it was inside a submit button so each time it simply re-wrote itself and I missed it, gee i feel average

BBK 🙂