What is this simple code?

[Mike4x4]

Hi people i got a table called users and fields like username, password and occupation and my site uses cookies and i was wondering what is the code to update the occupation part for that user?

[Mike4x4]

Ok this is the code i got now:
when i fill it our it says it was updated then ichecked in hppmyadmin and wasnt updated at all

oc.php file:

<?
include "theme.php";
?>
<form name="form1" method="post" action="ocpro.php">

Occupation: <input type="text" name="occupation"><br>

<input type="submit" name="Submit" value="Submit">
<input type="reset" name="reset" value="Reset Form">

</form>

Ocpro.php file:

<?
include "theme.php";
include "db_check.php";
$occupation = $_POST['occupation'];
$username = $_POST['username'];

$sql = "UPDATE users SET occupation='$occupation' WHERE username='$username'";

if (!sql)
{
die ('unable to update users occupation: ' . mysql_error());
}
else
{
echo 'Users occupation updated';
}
?>

[Mandes]

Your form script isn't passing the username to the Ocpro.php file !!

Therefore you query is returning no results

[Mike4x4]

i dont understand what code do i put it seems alright to me

[Mandes]

Your query is saying '.....WHERE username = $username'

your php script is setting $username to equal $_POST['username']

But your form isn't sending any data with the name 'username'

Now do you see where the problem is ?

[Mike4x4]

how would i fix it what would the code be?

[Mike4x4]

anyone?

[chiphunt1]

He said add the username in the form:

<?
include "theme.php";
?>
<form name="form1" method="post" action="ocpro.php">

Occupation: <input type="text" name="occupation"><br>
Username: <input type="text" name="username"><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="reset" value="Reset Form">

</form>

[Mandes]

He said add the username in the form:

<?
include "theme.php";
?>
<form name="form1" method="post" action="ocpro.php">

Occupation: <input type="text" name="occupation"><br>
Username: <input type="text" name="username"><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="reset" value="Reset Form">

</form>

Well I would guess that username would be stored in a variable by the time you get to the form, in which case I'd make it a hidden field and assign it to the variable $username.

<?php
echo '<input type="hidden" name="username" value="' . $username . '">';
?>

Of course that will only work assuming you have defined the user in the variable $username berore getting to your form