update syntax

[Garry Jones]

This is misfiring. Anyone see the problem?

mysql_query("UPDATE scfmforening SET scfmpad=$scfmpad, scfmpnm=$scfmpnm,
scfmort=$scfmort, scfmwww=$scfmwww, scfmwww=$scfmwww, scfmept=$scfmept,
scfmkom=$scfmkom WHERE scfmnum=$scfchknum ");

Thanks for any help in this matter.

Garry Jones

[B.r.K.o.N.j.A]

Garry Jones wrote:

This is misfiring. Anyone see the problem?

mysql_query("UPDATE scfmforening SET scfmpad=$scfmpad, scfmpnm=$scfmpnm,
scfmort=$scfmort, scfmwww=$scfmwww, scfmwww=$scfmwww, scfmept=$scfmept,
scfmkom=$scfmkom WHERE scfmnum=$scfchknum ");

Thanks for any help in this matter.

Garry Jones

all char fields must have it's values enclosed in quotes. That might be
the case

--

B.r.K.o.N.j.A = Bionic Robotic Knight Optimized for Nocturnal Judo and
Assasination

[anthony]

Gary,
This is in the query twice:

scfmwww=$scfmwww, scfmwww=$scfmwww

Is that supposed to be that way?
Garry Jones wrote:

This is misfiring. Anyone see the problem?

mysql_query("UPDATE scfmforening SET scfmpad=$scfmpad, scfmpnm=$scfmpnm,
scfmort=$scfmort, scfmwww=$scfmwww, scfmwww=$scfmwww, scfmept=$scfmept,
scfmkom=$scfmkom WHERE scfmnum=$scfchknum ");

Thanks for any help in this matter.

Garry Jones

[Pedro Graca]

Garry Jones wrote:

This is misfiring. Anyone see the problem?

mysql_query("UPDATE scfmforening SET scfmpad=$scfmpad, scfmpnm=$scfmpnm,
scfmort=$scfmort, scfmwww=$scfmwww, scfmwww=$scfmwww, scfmept=$scfmept,
scfmkom=$scfmkom WHERE scfmnum=$scfchknum ");

Thanks for any help in this matter.

Try it with appropriate substitutes for the $variables
outside the PHP script (in a command-line SQL tool)

UPDATE scfXXX set scfYYY=14, scfZZZ=88 WHERE scfKKK=-13;

--
File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot

[Garry Jones]

"Pedro Graca" <he****@dodgeit.comskrev i meddelandet
news:sl*******************@ID-203069.user.individual.net...

Try it with appropriate substitutes for the $variables outside the PHP
script (in a command-line SQL tool)

Thanks to all, I was missing a quote in my actuall text, now it is working.

Garry Jones
Sweden

[Pedro Graca]

Garry Jones wrote:

This is misfiring. Anyone see the problem?

mysql_query("UPDATE scfmforening SET scfmpad=$scfmpad, scfmpnm=$scfmpnm,
scfmort=$scfmort, scfmwww=$scfmwww, scfmwww=$scfmwww, scfmept=$scfmept,
scfmkom=$scfmkom WHERE scfmnum=$scfchknum ");

Another way to validate SQL commands (the way I most often use) is:

a) instead of putting the command inside the mysql_query() build it
outside
b) check the return value from mysql_query()
c) output an error message and stop the script (or, maybe better,
log the error somewhere and let the user know there was an error)

<?php
// a)
$sql = "UPDATE scfXXX SET scfYYY=$scfZZZ WHERE scfKKK=$scfQQQ";

// b)
$res = mysql_query($sql);

// c)
if (!$res === false) {
// There was an error in the query
exit('Error in [' . $sql . ']: ' . mysql_error());
/* or
mail('m*@somewhere.com', 'SQL Error',
'Error in [' . $sql . ']: ' . mysql_error());
exit('Cannot do that right now. Please try again in a few minutes.');
*/
}

--
File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot