|
|
Posted by Breklin on 10/17/06 20:02
I think the id should be an auto_increment and then she should have a
second field with an index on it for the product code. this would surely
avoid duplicate records.
Steve wrote:
> "Breklin" <breklin@sbcglobal.net> wrote in message
> news:CgaZg.623$T_1.67@newssvr14.news.prodigy.com...
> | Steve,
> |
> | I know what the problem is however I was offering a tip, some advice, a
> | bit of knowledge about streamlining the code.
> |
> | Rather than go into how she can write a Validation script to display
> | error messages, I suggested she use a canned script widely available on
> | the web. So, I did address the issue and then some. Best way for this
> | person to learn PHP is to see how it is written and self-educate.
>
> right. agreed. what i was misguided on was your answer #1 which dealt with
> auto-incrementing to avoid duplication of data. there simply isn't an id at
> the point of insert and re-submits will duplicate. and the id that she was
> talking about was a product id which is typically alpha-numeric so it can't
> auto-increment.
>
> anyway, yes, the canned script suggestion is a great route to go and i think
> linda seems sharp enough to teach herself if she had an example(s) to go by.
>
> cheers.
>
>
>
Navigation:
[Reply to this message]
|