Re: [PHP-WIN] duplicate entry

2007-04-08 Thread Alf Stockton
Alf Stockton wrote: How do I disable Refresh and Back button. to Prevent duplicate entry I used :- ALTER TABLE table-name ADD CONSTRAINT NoDuplicates UNIQUE (Date,MemberNumber) Have a read of :- http://www.thescripts.com/forum/thread156807.html -- Regards, Alf Stocktonwww.s

Re: [PHP-WIN] duplicate entry

2007-04-08 Thread Alf Stockton
How do I disable Refresh and Back button. to Prevent duplicate entry I used :- ALTER TABLE table-name ADD CONSTRAINT NoDuplicates UNIQUE (Date,MemberNumber) -- Regards, Alf Stocktonwww.stockton.co.za Your love life will be... interesting. My email disclaimer is available at ww

Re: [PHP-WIN] duplicate entry

2007-04-08 Thread bedul
use session on your page.. - Original Message - From: "Jarrett Meyer" <[EMAIL PROTECTED]> To: Sent: Friday, April 06, 2007 8:12 AM Subject: Re: [PHP-WIN] duplicate entry > Sorry, but to answer the original question, PHP cannot interact with the client in this way. P

Re: [PHP-WIN] duplicate entry

2007-04-07 Thread sam rumaizan
Thank you it works fine Stut <[EMAIL PROTECTED]> wrote: sam rumaizan wrote: > *"If the user hits refresh after submitting the form they will refresh > nextpage.php. If they hit back they will be taken back to form.php"* > Yes, *If the user hits refresh after submitting the form they will > refr

Re: [PHP-WIN] duplicate entry

2007-04-07 Thread Stut
sam rumaizan wrote: *"If the user hits refresh after submitting the form they will refresh nextpage.php. If they hit back they will be taken back to form.php"* Yes, *If the user hits refresh after submitting the form they will refresh ** *nextpage.php. Which is going to resubmit the data to mysq

Re: [PHP-WIN] duplicate entry

2007-04-06 Thread Stut
sam rumaizan wrote: How do I disable Refresh and Back button. to Prevent duplicate entry Disabling client-side features like refresh and back is not the right way to solve this problem. The most common solution is to redirect the user to the next page from the form handler rather than outputt

Re: [PHP-WIN] duplicate entry

2007-04-05 Thread chandar
://jarrettmeyer.blogspot.com No trees were harmed during this transmission; however, several electrons were terribly inconvenienced. - Original Message From: sam rumaizan <[EMAIL PROTECTED]> To: php-windows@lists.php.net Sent: Thursday, April 5, 2007 7:15:36 PM Subject: [PHP-WIN] dup

Re: [PHP-WIN] duplicate entry

2007-04-05 Thread Jarrett Meyer
TED]> To: php-windows@lists.php.net Sent: Thursday, April 5, 2007 7:15:36 PM Subject: [PHP-WIN] duplicate entry How do I disable Refresh and Back button. to Prevent duplicate entry - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected

Re: [PHP-WIN] duplicate entry

2007-04-05 Thread Jarrett Meyer
ssage From: sam rumaizan <[EMAIL PROTECTED]> To: php-windows@lists.php.net Sent: Thursday, April 5, 2007 7:15:36 PM Subject: [PHP-WIN] duplicate entry How do I disable Refresh and Back button. to Prevent duplicate entry - Don't be flakey. Get Yah

Re: [PHP-WIN] duplicate entry

2007-04-05 Thread bob plano
maybe you could just check the data base at the beginning of the script for whatever you're adding On 4/5/07, sam rumaizan <[EMAIL PROTECTED]> wrote: How do I disable Refresh and Back button. to Prevent duplicate entry - Don't be flakey. Get Yahoo! Mail for

[PHP-WIN] duplicate entry

2007-04-05 Thread sam rumaizan
How do I disable Refresh and Back button. to Prevent duplicate entry - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

Re: [PHP-WIN] Duplicate entry removal

2003-02-27 Thread Michael Power
Depends if you want records with the same -MM-DD (my example) or (your example). After re-reading the original post it appears he only wants results as per your query, oops :) Cheers Mike > -Original Message- > From: Uttam [mailto:[EMAIL PROTECTED] > > isn't it better to just: >

RE: [PHP-WIN] Duplicate entry removal

2003-02-27 Thread Uttam
isn't it better to just: SELECT DISTINCT YEAR() FROM ; regds, -Original Message- From: Michael Power [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 17:10 To: [EMAIL PROTECTED] Subject: Re: [PHP-WIN] Duplicate entry removal Better yet define the required dataset

Re: [PHP-WIN] Duplicate entry removal

2003-02-26 Thread Michael Power
Better yet define the required dataset with SQL to speed the whole process up: "SELECT YEAR(your_date) FROM table_name GROUP BY your_date"; Cheers Mike > "Matt Hillebrand" > array_unique() > > |-Original Message- > |From: Per Christian [mailto:[EMAIL PROTECTED] > | > |Hi > | > |I'm build

RE: [PHP-WIN] Duplicate entry removal

2003-02-22 Thread Matt Hillebrand
array_unique() |-Original Message- |From: Per Christian [mailto:[EMAIL PROTECTED] |Sent: Saturday, February 22, 2003 7:56 AM |To: [EMAIL PROTECTED] |Subject: [PHP-WIN] Duplicate entry removal | | |Hi | |I'm building a PHP project for fun, and are going to get some |dates fr

[PHP-WIN] Duplicate entry removal

2003-02-22 Thread Per Christian
Hi I'm building a PHP project for fun, and are going to get some dates from my database (mysql). The problem is that I only want the year, but the date is in the format -MM-DD so I get the whole column and remove the -MM-DD part, but now I have a lot of the same year Is there a function or som