using passed variable in where of update

[melrse]

Hi,

This is probably simple(idiot question) but I am having problems figuring it out so:

I am doing this-
echo "<a href = "trigchgh.php?Pass=$myrow[Id]\"></a>

from within a table to pass a variable called Pass which is the auto-increment field on mysql table called Id to trigchgh.php

In trigchgh.php, I am issuing an update command as follows:

$sql="UPDATE trighdr SET Indatt2='$Indatt2' where Id='$Pass'" ;

using the Id received in to identify with the id number Id on file trighdr which record to update.

Thought it would work, but it ain't.

Is it not this simple?

Thanks,
Melissa

[phigga]

well, as a testing measure, you should have the script echo out Pass....:

echo $Pass;

if it's blank, then the page isn't correctly getting the info. if it echoes out the proper ID, well....then something else is the problem.

[amcgrath]

Mel, is $myrow[Id] actually passing a value on the URl? Plus, you say Pass is an auto-increment field... is it possible that the ID you're lookingto update doesn't yet rexist in trighdr? Paste some more code, the answer seems like it should be simple to find.

[melrse]

Allen,

The id number is passing ok as I can echo it in the initial part of the receiving script.

The record exists as I can perform successful update when I have Id = '1' instead of Id = $Pass.

Do I need to make this a global variable or do something else to it? Is my syntax wrong on update w/where is using a variable

Code follows:

<?

if (!$submith) {

// display form
echo $Pass;
?>

<form method="post" action="<?php echo $PHP_SELF?>">
<h3><center><font color="#9933FF">Change&nbsp;Individuals&nbsp;in&nbsp;Attendance</font color></center></h3>
<font color="#660066"><b>Change Individual #1:</b></font color>&nbsp;<input type="Text" name="Indatt1" size="30" maxlength="30"

<input type="Submit" name="submith" value="Submit Change">

<?
} else {

//process form
$db = mysql_connect....
mysql_select_db(.....

$sql="UPDATE trighdr SET Indatt2='$Indatt2' where Id='$Pass'" ;

$result=mysql_query($sql);

if ( !$result)
die ("Couldn't update: ".mysql_error());
print "<h1>Table updated ".mysql_affected_rows() .
"row(s) changed </h1><p>";
print ".mysql_error()";

}
?>

</body>

[amcgrath]

Few things:

1. action="<?php echo $PHP_SELF?>"> can be done like <?= $PHP_SELF ?> ... it's a little cleaner, IMO...

2. YOu have no closing > in the Indatt1 text field.

3. I cant tell what Indatt2 is supposed to be... could this be whats wrong?

4. Put <input type="hidden" name="Pass" value="<?= $Pass ?>"> above the input field then try it. It'll work, cuz you don;t appear to be passing $Pass back onto the form in the post.

[melrse]

Allen,

I added the hidden field.
Still not ok.
What is happening is $Pass has a value at the beginning of the script but is 0 when I issue the update. I know this because I changed the id on the record on the database to 0 to test my update syntax and it updated the row where the id is 0.
I must have to do something special to maintain the passed in value. Move it to another variable or something.
Thanks for your help and if you can think of anything, please let me know.

Melissa

[melrse]

Allen,

I looked again at what you sent me and I modified the value on Pass to have = $Pass and it works now. Thanks much. I did not know you had to do that and was banging my head against a wall not to mention wasting time.

So when you utilize a passed in variable that will be processed as a post, you have to add it into the form.

Appreciate it very much and take care,
Melissa

[Anon]

xxxxxxxxxxx