Re: Help required with UPDATE columns [message #179553 is a reply to message #179541] |
Wed, 07 November 2012 11:05 |
|
Originally posted by: Dynamo
On Tue, 06 Nov 2012 08:15:32 -0500, Jerry Stuckle
<jstucklex(at)attglobal(dot)net> wrote:
>
> Echo your query to the browser and you'll see what your problem is.
>
> And BTW - just taking a POST value without any validation is an
> invitation to problems. Also, you should always use
> mysql_real_escape_string() to escape strings before they are used in SQL
> statements.
>
> And finally - never use die() in production code! It's OK for
> debugging, but terminates processing of the page right there - causing
> invalid HTML to be sent to the browser and sends a non-user-friendly
> message (which can give out hints on how to hack your system).
Thank you Jerry. Shakes solution worked but I will bear your comments
in mind. However, the code is being used in a password protected area
that theoretically only I should have access to.
Regards
Dynamo
|
|
|