RE: [PHP] Unable to get a form to update CODE AS REQUESTED
| From: | Patrick Kirk | Date: | Fri, 23 Aug 2002 15:27:03 +0000 |
| Subject: | RE: [PHP] Unable to get a form to update CODE AS REQUESTED | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-113788@lists.php.net to get a copy of this message | ||
Jay Blanchard said:
> [snip]
> if ($person_id) {
[...]
the last line in
> the update;
>
> WHERE person_id=$person_id";
>
> should be
>
> WHERE person_id='$person_id'";
>
> Dang syntax error ...
>
> ALWAYS, ALWAYS, ALWAYS print out your completed SQL statements during
> testing, it will save you much time.
>
> HTH!
>
> Jay
[...]
Sorry Jay...that makes no difference.
I know exactly where the problem is. the form is triggering the 'if
$grouping' block instead if the 'if $submit' block. The sql never runs
because it doesn't get called.
Perhaps I need to repost my question to express the problem more clearly.
Its thanks to prompts from you and Jason I understand why its failing but
I still need a way to make it work.