question about why an update is not updating

[sal]

Be4 I start, thank you guys for your help. You have made my learning process more productive.

Here is the code that causes my current problem. When I enable the echo "echo "name" all seems to appear right. After the update query, it shows the name I put in one of the fields. Yet the update doesn't get done!

Any help would be great.

<?php
$sql = "UPDATE $mysql_free SET email='$email', title='$title', where username='sal'";
//echo "$sql<br>";
mysql_query($sql);

$sql = "SELECT * FROM $mysql_free";
//echo "$sql<br>";
$result = mysql_query($sql);
//echo "$result<br>";
while ($i = mysql_fetch_array($result)) {
//echo "$i<br>";
?>

<form action="update.php" method="post">
<input type =HIDDEN name="username" value="<?php echo $username; ?>" >
<input class=input type=text name=email maxlength="70" value="<?php echo $i[email]; ?>
<input class=input type=text name=title value="<?php echo $i[title]; ?>">
<input class=input type=submit value="Update
</form>

<?
}
?>

[cgraz]

You have a comma right before the WHERE part of your clause. Change your update to

$sql = "UPDATE $mysql_free SET email='$email', title='$title' WHERE username='sal'"; 

Cgraz

[sal]

Thank you for your reply. Actually that comma was left there unintentionally as I removed values for the purpose of making my post shorter.

I get no updat without the comma.

Would it help you tracking the problem if I showed the message returned when I put an echo after each variable.

On loading the page, here is what I get:

UPDATE freemembers SET email='', '', age='', title='', sdescription='', domain='' where username='sal'
SELECT * FROM freemembers
Resource id #3
Array

After processing the transaction here is what I get

UPDATE freemembers SET email='[e-mail]', '', age='23', title='Hello', sdescription='', domain='http://www.site.com' where username='sal'
SELECT * FROM freemembers
Resource id #3
Array

Thanks

[jnuneznyc]

Try the following code and post the result...

After your call to mysql_query() add

if(mysql_errno() > 0){
   echo mysql_error();
}

mysql_errno() = reports the status code of your last query. 0 means OK

mysql_error() = reports the status message. If the status code = 0 then this returns an empty string.

[steved]

UPDATE freemembers SET email='', '', age='', title='', sdescription='', domain='' where username='sal'

In your update statement, what is supposed to be between email and age?

[sal]

Hi Steve,

You got it exactly right!!! There was a field that I forgot I had removed from the table. Removing the value from the query did the trick just fine.

Thank you so much!!! You don't know how long I have been trying to solve this problem and to think that it was something so basic!

Thank you again to you, jnuneznyc and cgraz for all your help!