MySql edit problems

threestatedrive

I've built several content management systems using php and mysql all of them with an edit/update page.
After just recently building another one, i can't get the edit page to actually edit what i want. What i mean is, i can call all the table contents onto an edit page, but when i submit, it will not change the content.
i really can't understand it. i haven't done anything different. are there any MYSQL properties that i might need to set through PHP my ADMIN?
this is the first time I've used this hosting company. could it be that the database doesn't respond to updating?
enter, delete info works fine. i don't get it
help me out here please?

YappyDog

Kind of hard to figure out without seeing any of your code....

Do any of the columns of data you are trying to update contain any quotes?

Have you tried printing out the contents of your update query just before you execute it to see if you can spot any problems?

threestatedrive

the edit page passes it all over to the update.php page

here's the code for my updated.php page (the page i'm passing the info to)

$username="";
$password="";
$database="*";
mysql_connect(localhost,$username,$password);

$query="UPDATE submit SET first_name='$ud_first_name', last_name='$ud_last_name', street_address='$ud_street_address', parish='$ud_parish', postal_code='$ud_postal_code', home_telephone='$ud_home_telephone', work_telephone='$ud_work_telephone', email_address='$ud_email_address', WHERE id='$ud_id'";
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);

YappyDog

You've got an extra comma right before your WHERE clause. Get rid of that and you might do better.

email_address='$ud_email_address', WHERE id=

threestatedrive

thanks for pointing that comma out, but it still didn't work
any other ideas?

YappyDog

I have no way of knowing what is in any of your variables, or what your table structure is, so it is pretty tough to diagnose like this.....

Print out the value of your $query variable right before you execute the query. See if you can spot any formatting error or anything that is missing. If you cannot, run the sql statement manually and see what error you get.

threestatedrive

I'd like to give you the code, but it's too long
cani email it to you?

YappyDog

What error message do you get when you run the sql statement manually?

threestatedrive

I was missing one letter in one word.
fixed it, fixed the problem, thanks for your help though