updating a table

Anon

I can add to my table and I can delete from my table, but I can't update my table.

I wondered if there is a problem with this register _global thing.
My php is version 4.2.1

I have tried to print all the variables, and they are sent from the form to this script.

Are there a problem with my variables in the code below??

mysql_query("UPDATE artikler SET overskrift='$overskrift', tekst='$tekst', billede1='$billede1', billede2='$billede2', billede3='$billede3' WHERE id=$id");

sincerely
Kurt

cyrill

Do you get an Error, if not, try it out with this code!

mysql_query("UPDATE artikler SET overskrift='$overskrift', tekst='$tekst', billede1='$billede1', billede2='$billede2', billede3='$billede3' WHERE id=$id") or
die("MySQL Error ".mysql_error()) ;

Cyrill

Anon

sir,
i want to full dicription of normalization and related topics .
thank you

Anon

Hi, and thanks for Your reply.

Silly me, silly me.

I did what You suggested, and got an error message that told me, that there is an error in my syntax.

som text contains words like, I'm, haven't, couldn't and so on.

Why isn't that an error when I put it in my table in the first place, with the INSERT command?

And how do avoid this in the future?

Sincerely
Kurt

Anon

Eeh, what do You mean???

Sincerely
Kurt

cyrill

Hi Kurt,

Just try to use the function addslashes().

$string = addslashes($string);

This function will set in front of each " and ' a .

If you select some data from the database you have then to use again stripslashes() to remove the \ in front of a ' or ".

$string = stripslashes($string);

But actually should the server make this automatically, but only if the webserver is configured correctly, i think!

php.ini:
magic_quotes_runtime = on|off
magic_quotes_gpc = on|off

.htaccess, httpd.conf:
php_flag magic_quotes_runtime on|off
php_flag magic_quotes_gpc on|off

Cyrill

cyrill

http://www.php.net/manual/en/configuration.php