mysql updateing problems....

[jamesp]

okay, heres the deal, I have made a little user profile editing option for users:

<form action="updatebio.php">
<textarea name="updatebio" class="alphaBox2" wrap="virtual" rows="15" cols="60"><? echo $bio; ?></textarea>
<input type="submit" class="alphaBox" name="Submit" value="Update My Bio">
</form>

updatebio.php:

<?
session_start();

include 'db.php';

$bio = $_POST["updatebio"];

$userid = $_SESSION['userid'];

$query = "UPDATE users SET bio='$bio' WHERE userid = '$userid'";
$result = @ ($query);
?>
<script>location.replace('/bio_updated.php');</script>

its very simple right now for testing purposes but when i try to update it all that is sent to the db is blank...nothing....?!

Any help would be great.

[bike5]

echo out your variables and see if they contain anything, if they are both blank then your database will have blanks.

[jpmoriarty]

be sure to include a method in your form:
<form name="..." method="post" action="...">

also, be consistent: you've gone for $SESSION['...'], so do that with $POST too, don't use "'s.

also, have you defined your user_id session elsewhere?

I always find it's a good idea to echo out your SQL statement and then copy it into PHP my admin (if it looks good on screen - sometimes you find that a variable's not going in properly) and run it there. the error functions are much better there.

also, you can redirect using header() (in php) providing you've not outputted to browser at all:
header("Location: /bio_updated.php");