Update Set problem

[michaelowen]

hello everybody....i am having a problem with the "update set" procedure in the php form update script i wrote. I am very close, but i think i'm missing something.

---

<?php

$db = mysql_connect("localhost", ".......", ".......");
mysql_select_db("......com.....",$db);

if($submit){

$sql = "UPDATE entrants SET minutes='$minutes',seconds='$seconds' WHERE email=$email";
$result = mysql_query($sql);

header("Location:http://www......./change/edit_confirm.php?email=".
$email."");

} else{

$query="SELECT * FROM entrants where email='$email' ";
$result=mysql_query($query);
$myrow=mysql_fetch_array($result);
?>

<form method="post" action="<?php echo $PHP_SELF?>">
First:&nbsp;&nbsp;<?php echo $myrow["first_name"]?>&nbsp;<?php echo $myrow["last
_name"]?><br>
Email:&nbsp;&nbsp;<?php echo $email ?><br>

Minutes:&nbsp;&nbsp;<select name="minutes"><br>
<OPTION VALUE="<?php echo $myrow["minutes"]?>"><?php echo $myrow["minutes"]?>
<OPTION VALUE="00">00
<OPTION VALUE="01">01
<OPTION VALUE="02">02
<OPTION VALUE="03">03
<OPTION VALUE="58">58
<OPTION VALUE="59">59
</SELECT>

&nbsp;&nbsp;&nbspSeconds:&nbsp;&nbsp;<select name="seconds"><br>
<OPTION VALUE="<?php echo $myrow["seconds"]?>"><?php echo $myrow["seconds"]?>
<OPTION VALUE="00">00
<OPTION VALUE="01">01
<OPTION VALUE="59">59</SELECT><br>

<input type="Submit" name="submit" value="Update Information">
</form>
<?php

}

?>

all i want to do is update the persons time depending on the inputted $email variable.

thanks!

-Michael

[mikeatrpi]

What exactly is the problem?

Are you not generating $minutes and $seconds properly? If you want to store a time in mySQL, look into the mysql function "NOW()". If you want to stay with your current design, look at the PHP function "date()".

[michaelowen]

it's not passing any variables, or updating anything in the database.

is the update set syntax correct?

-mike

[mikeatrpi]

UPDATE entrants SET minutes='$minutes',seconds='$seconds' WHERE email=$email

UPDATE entrants SET minutes='$minutes',seconds='$seconds' WHERE email='$email'

Also you can try to echo $sql; and see what the query looks like right before it is executed.

[michaelowen]

yes, the email field isn't passing correctly no matter what i use.

somehow the $email varibiable isn't getting passed to the SQL UPDATE satement.

Any suggestions anybody?

-mike

[mikeatrpi]

Do you have register globals on? You might need to use $POST[] or $GET[] depending on your method. It could be your form or however you're passing data. Does $submit get set? Have you tried echoing just $email to see what is going on? It could be a bunch of things.

You should be using the second of the SQL statements I provided.

Hope that helps... 😕

[michaelowen]

sorry for the confusion, but the scope of this is that i want the user to be able to update their time (minutes/seconds) depending on their login email. I do not want their email changed or sent to the database.

When i display the $sql command i get this:
UPDATE entrants SET minutes=12,seconds=06 WHERE email=

so, the concept is working, but HOW do i get the email field to populate properly so it updates the database. i would rather not use sessions, but if it's my only choice, could somebody help me with them?

the email field is being passed to this page properly through the header, however once it enters the SQL command (and further into the header) it is lost.

I have tried formatting with '$email', $email, ".$email."

help!

-mike

[mikeatrpi]

What happens if you replace this

$sql = "UPDATE entrants SET minutes='$minutes',seconds='$seconds' WHERE email=$email"; 

with this:

echo "Email is $email \n";
echo "Trial two: " . $_POST['email'] . "\n";
echo "Trial three: " . $_GET['email'] . "\n";

$sql = "UPDATE entrants SET minutes='$minutes',seconds='$seconds' WHERE email='$email'"; 

echo "The sql statement is: $sql \n";

Are you accidentally resetting $email somewhere in your code?

I'm sorry if my suggestion is too basic, but I'm going through the basic debugging procedure I'd do myself.

Edit:

Mike, I just looked more closely at your original code. Try adding this to your Form (such as right before the submit button):

<input type="hidden" name="email" value="<?=$email?>">