| Author |
Message |
|
doc
|
Post subject: Total signatures does not match number of rows  Posted: Sun Feb 07, 2010 4:08 pm |
|
Joined: Sat Jan 17, 2009 8:21 pm
Posts: 15
|
|
The script is no longer totaling the correct number of signatures. The total number of rows (i.e., signatures) does not correspond to the total calculated value on page 1 of the script. Suggestions for fixing?
|
|
  |
|
 |
|
dtsoden
|
Post subject: Re: Total signatures does not match number of rows Posted: Sun Feb 07, 2010 6:42 pm |
|
 |
| Site Admin |
Joined: Mon Jul 17, 2006 4:00 pm
Posts: 297
|
|
what are you saying?
the # of rows on the db do not match the front page?
unless you changed the signature.php page and altered the SQL its not possiable.
SELECT count(*) as RecordCount FROM signature
there is no where clause.
not if you talking about the number shown vs the number of confirmed signatures then yes it does not match unless you add a where clause to filter on that.
|
|
| |
|
|
|
doc
|
Post subject: Re: Total signatures does not match number of rows Posted: Mon Feb 08, 2010 2:44 am |
|
Joined: Sat Jan 17, 2009 8:21 pm
Posts: 15
|
|
| |
|
|
|
dtsoden
|
Post subject: Re: Total signatures does not match number of rows Posted: Mon Feb 08, 2010 8:23 am |
|
|
| Site Admin |
Joined: Mon Jul 17, 2006 4:00 pm
Posts: 297
|
|
| |
|
|
|
doc
|
Post subject: Re: Total signatures does not match number of rows Posted: Mon Feb 08, 2010 4:40 pm |
|
Joined: Sat Jan 17, 2009 8:21 pm
Posts: 15
|
|
Nevermind, my bad. I was confused by the ID column, which records a unique ID for each signature. If there were no unconfirmed signatures, the ID would equal the total number of people who have signed the petition. So, I was noting the last number on the ID column, which was 490. Thanks for clearing it up so quickly. Much appreciated.
|
|
| |
|
|
|
