|
|
Posted by linda on 10/17/06 15:32
----- Original Message -----
From: "Steve" <no.one@example.com>
Newsgroups: alt.php
Sent: Tuesday, October 17, 2006 4:16 PM
Subject: Re: on input form showing error message for duplicate entry.
>
> "linda" <newsaccount@tiscali.co.uk> wrote in message
> news:4533f42a$1_2@mk-nntp-2.news.uk.tiscali.com...
> |I very new to php could someone please explain how to write an error
> message
> | into my AddNew.php below. id is set to unique so at the moment if
> someone
> | adds a product and the id is already in the database, it just doesn't
> enter
> | anything. Ideally I would like to display an error message, with a back
> | button to correct the id.
> |
> | So far I've tried running a SELECT query with an if statement prior to
> the
> | INSERT but I just don't know enough php to get this to work. I would be
> | very greatful for any info and advice from those in this newsgroup.
> |
> | Many, many thanks in advance,
> | Linda
>
>
> linda,
>
> here's a basic maintenence script i have for managing "people"...forget
> about the require_once files and just look at the programmatic flow.
> you'll
> need to change the db calls so that they are appropriate for your setup.
> notice there is some validation in javascript but you also need to add the
> same validation in php since not all your visitors/customers will have js
> enabled. sorry for the text-wrapping. and contrary to the dipshit comment
> made by ikciu, this is NOT a stupid question at all.
>
> hth,
>
> me
Many, many thanks Steve,
I have just c&p'd your code into my editor to take a look at it! I'm very
greatful to you for sharing this. I'm so new at this (three weeks new;-)
that every step of changing my partners bussiness site from static to
dynamic has been a true hurdle. Teaching yourself requires so much more
work lol... but I'm getting there slowly. It's through kind help from
people like yourself that I am able get anywhere at all. Though with that
said, I have that "very proud of myself" feeling atm, that I've got as far
as I have.
No doubt I'll be back with more newbie questions, "watch this space!".
Best wishes,
Linda
Navigation:
[Reply to this message]
|