Updating table created from import

I have one table on one of my PHP MySQL site which I created by importing a .csv.

I then created Admin pages to manage the content of the db but they will not work.
It is just this table. I cannot insert, update or delete.

When I try to do an update, I do not get an error, it submits the page and shows the result, but the record is unchanged.

I do not believe it is the Data Assist pages, but rather something about the table. I can update the table using PHP MySQ?LAdmin so I'm stumped.

Is there something I can check in MySQL that would be blocking the update?

You may have checked this already but double click the "Update Record" server behavior and then hit next on the first dialogue screen just to ensure that your columns have a binding to give an updated value.

If everything looks good there... the next step will be to dump the post values on the screen to ensure that you are creating values.

Best regards,

Brian

Just to make sure it is not a problem in the update record server behavior, look for the following code:

$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

and change it to:

$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";

die($WA_Sql);

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

This will write the UPDATE SQL To the screen try running that SQL statemnt directly on the database using PHPMyAdmin or another tool.

If that works, then check that the username being used in the Dreamweaver Database connection has edit access to the database.