SQL update problem

[reywob]

Hi,

Can someone please tell me why this code isn't working? I think it must be a fault in the SQL, as no errors are being returned about connecting to the database. The code is:

$link = mysql_connect ($dbServer, $dbUser, $dbPass) or die ('Unable to connect - Please check your db settings.');

mysql_select_db ($dbName, $link) or die

('The database specified in database_name must exist and must be accessible by the user specified in mysql_connect');

$sql ="Update forums set name='$name', description='$description', parent=$parent, display=$display, table_name='$table', moderation='$moderation', mod_email='$mod_email', check_dup=$check_dup, multi_level=$multi_level, collapse=$collapsed, flat=$rflat, staff_host='$staff_host', html='$html', table_width='$table_width', table_header_color='$table_header_color', table_header_font_color='$table_header_font_color', table_body_color_1='$table_body_color_1', table_body_color_2='$table_body_color_2', table_body_font_color_1='$table_body_font_color_1', table_body_font_color_2='$table_body_font_color_2', nav_color='$nav_color', nav_font_color='$nav_font_color', allow_uploads='$allow_uploads' where id='$phorumid'";

mysql_query($sql, $link);

echo("Your phorum has been updated");

It chucks up no errors, but the database still isn't updated. The $phorumid is being called OK, and if I do echo($sql) then it looks fine.

In case it matters, magic_quotes_gpc is on.

TIA,
Peter

[Anon]

You wrote:

"... and if I do echo($sql) then it looks fine."

Take the echo'd statement and run it from the command line.

Place:

print mysql_error();

after the mysql_query.

[[deleted]]

When you say "it looks fine" does that mean that $phorumid contains something that actually exists in the table?

Also, you will want to do more than the "or die" in error checking.
Use and IF statement to check if your commands worked, and print the mysql_error() if they did not.

[reywob]

Thanks, solved the problem. I was trying to update some fields without supplying the data.

Cheers!
Peter.

[Anon]

Hi There.

I am unable to update the following query; however it works at the command line just fine:

note: ID is an autoincremented column. I am using an url parameter to pass to the sql statement below:

$sql = "UPDATE recipients
SET ID = '$ID',
First_Name= '$First_Name',
Last_Name= '$Last_Name',
Email= '$Email',
Party_Id= '$Party_Id'
WHERE ID = '$ID'";

my php update page works fine its just it doesn't update anything; but it returns no errors.

Anybody have any ideas? I can't seem to figure it out.

Thanks,

PHP newbie (today is my first day!)