You are here: Re: multiple updates « PHP SQL « IT news, forums, messages
Re: multiple updates

Posted by J.O. Aho on 12/13/06 13:44

ulyx wrote:
> 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"));
> }

How old PHP do you use??

Use $_POST/$_GET/$_REQUEST and not $HTTP_POST_VARS.
Add single quotes around the %s.

Are you sure your $_POST['updateUser'] has the value "form" ?
Does your GetSQLValueString() function work?


--

//Aho

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация