Re: [PHP-DB] Conditional updating...

2006-06-17 Thread Naintara
You could do a conditional update based on whether the form input is empty/blank or not. Use trim() on every input box entry, update that entry if there is any value Make the query string based on non-empty inputs trim(formput) != '' //append to query string Finally, your update query could lo

Re: [PHP-DB] Conditional updating...

2006-06-17 Thread Grae Wolfe - PHP
That was the first thing that I was going to do, but there is a concern there for security of the data being input... This is a registration site, and I don't want to provide information on "John Smith" to anyone who just happens to put his name in. ""Alejandro Tesone"" <[EMAIL PROTECTED]> wr

Re: [PHP-DB] Conditional updating...

2006-06-17 Thread Alejandro Tesone
Why don't you try populating the fields the user intends to modify with the information you already have? Alex T On 6/17/06, Grae Wolfe - PHP <[EMAIL PROTECTED]> wrote: Good day! I have been working on this little "free" project for a while, and now I have hit another major hiccup. Is there

[PHP-DB] Conditional updating...

2006-06-17 Thread Grae Wolfe - PHP
Good day! I have been working on this little "free" project for a while, and now I have hit another major hiccup. Is there a simple way to only update fields that have something in them? The problem that I am having is that if someone fills out information and submits it, it saves to the DB