Posted by ulyx on 12/12/06 18:18

Im sorry, you are totaly right... This is the code that im using. I get no
error , but there is no update.
This is standard dreamweaver update and its working very good.

if ((isset($HTTP_POST_VARS["updateUser"])) && ($HTTP_POST_VARS["updateUser"]
== "form"))
{
$updateSQL = sprintf("UPDATE users SET name=%s WHERE id=%s",
GetSQLValueString($HTTP_POST_VARS['name'], "text"),
GetSQLValueString($HTTP_POST_VARS['field_id'],
"text"));
}

If i continue with lastname = '$lastName', city='$city' then nothing happens
but if i want to change just the name part ( just one field ) then its
working perfect..



"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1165941695.057103.177830@79g2000cws.googlegroups.com...
>
> ulyx wrote:
> > I have tryed thise before posting, but its not working :-(
> > ----------------------------------------
> >
> >
> > > UPDATE user SET name='value', lastname='value', city='value WHERE
> > id='value
> > >
> > > http://dev.mysql.com/doc/
> > >
> > > +e
> > >
> > >
> I love that "its not working". Well that sure gives us all the
> infomation we need to help you, doesn't it!
>
> Does the whole server break? Does the MySQL instance crash? Does
> the php code used to access the database crash? Does the SQL simply
> return an SQL error? ...
>
>
> I could go on! We are a helpful bunch, but we are not telepathic.
>
> Please tell us WHAT you are seeing so that we know WHAT to fix!
>

[Back to original message]