adding to sql field

Hi All,

Im hoping this will be a quick question.

i have this line in my script:

$update_views = ("UPDATE aviation set views= '$views + 1' where id = '$id'");

which doesnt seem to work.

if i do:

update aviation set views = views + 1 where id = 2; (for example)

at the server itself it works with no hitches.

Can someone point me in the right direction as to why its not working in PHP.?

Many thanks

Dave

I too am gettign a similar problem, when i put this line of code in:

$query = 'UPDATE user101 SET username='.$nu_username.' WHERE username='.$tbusername;

and i get an error saying
"Unknown column '$tbusename' (/ or what is in it /) in 'field list'

hmmm, and if i enter it like dave said above it works?

You need to put all of your variables into "'s.

$query = 'UPDATE user101 SET username='.'"'.$nu_username.'"'.' WHERE username='.'"'."$tbusername".'"';

Like so, looks nice and simple and it works.

so if you echo your query you get;

UPDATE user101 Set username="blah" WHERE username="bleh";

:o)

I don't believe that will work for the first example because he is dealing with integers. not sure I haven't tried it.

any ideas on this one guys?

im sure its something simple but cant put my finger on it

Dave

Change you code to this;

$update_views = ('UPDATE aviation set views= '.'"'.$views.'"'.'+ 1' where id = '.'"'.$id.'"');

I think that will work. if it dont, i dont know the answer

this line generates a parse error....

$update_views = ('UPDATE aviation set views= '.'"'.$views.'"'.'+ 1' where id = '.'"'.$id.'"');

does anyone else have some other ideas?

im getting pretty depserate.......i still cant find anything that will help me get it working.

Regards

Dave