basice mysql instert query

debyrne

Hi, im using this in a php mysql query...
i have a record in my db with 'id 'and 'round0group' fields (only the id has data in it).
what is the command to insert data in the 'round0group' field of the record with a certain id (say $id)

i have something similar to this... however, it just adds the new roud0group to a new record line. I was thinking i might need an "inset into values where id = $id .. but im new to this 🙁

// write the group number provided into 
// the players own record in the 
// round0group field 

$query = "INSERT INTO tablename (round0group) VALUES ('$newform_round0group') "; 
$result=mysql_query($query); 
echo ("Your record has been updated with your new group ");

thanks in advance
de

devinemke

INSERT INTO tablename SET round0group = '$newform_round0group' WHERE id = '$id'

debyrne

🙁 when i update the query to that line, nothing is changed in the database.. no new lines.. no new text.. nothing 🙁

to to elaborate on other factors influencing the query...

 
$newform_round0id=$_POST['newform_round0id'];
$newform_round0secret=$_POST['newform_round0secret'];
$newform_round0group=$_POST['newform_round0group'];/PHP] 

[code=php] 		

// check if id entered exists in the database id field
$query="SELECT id FROM jumpregos WHERE id='$newform_round0id' AND password='$newform_round0secret' ";
$result=mysql_query($query);

if (!$result) {
echo mysql_error();
}
if (mysql_num_rows($result) == 0) {
// If the playered entered nonexistant or incorrect datea
die ("<p>Sorry, your details are not found in our system.</p>");
}
// if the entered id and passwords are in the database, state that 
// and then add the group number variable to round0_group in db
else {
echo ("<p>Your username and password was found in the system! well done</p>");


// write the group number provided into the players own record in the round0_group field
$query = "INSERT INTO jumpregos SET round0group = '$newform_round0group' WHERE id = '$newform_round0id'";  

$result=mysql_query($query);  

echo ("Your record has been updated with your new group ");

debyrne

just another note:

I clear out all properties of the 'round0group' field, and give it the propery of "INT" with max "1" character. (user should input a single number). and it has the value NULL.

After running the php code however, the field is no longer NULL, but just blank.

if that helps.. or makes a difference :S

debyrne

aaaaaaaaaaaaah
just playing around with different poissiblities... and manage to find it =D so proud of self

if anyone else has a similar newb problem like this.. this is the correct format of code i got to work

 

$query="UPDATE jumpregos SET round0group= $newform_round0group WHERE id = $newform_round0id";
$result=mysql_query($query);  

echo ("Your record has been updated with your new group ");