Search found 15 matches

by NewDevGuy
Fri Jan 23, 2009 9:50 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

VladSun,
I ran that:

SELECT * FROM members ORDER BY MemID;

And got the exact same result set back.

onion2k,
I also ran your query: no duplicates, which is as expected as MemID is the Primary Key.
by NewDevGuy
Fri Jan 23, 2009 9:28 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Ok, I ran that and just got out a list of numbers from 1 to 753 - do you want me to post the numbers? I've gone through them and there's no numbers skipped and no null values. Here's the code I used: $SQL = "SELECT MemID FROM members"; $result = mysql_query($SQL, $conn) or die(mysql_error(...
by NewDevGuy
Fri Jan 23, 2009 8:23 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

I was running the previous queries from the CLI on a local copy of the DB, so I'm just writing a script to do the same query on the remote copy of the DB. Will just be another couple of minutes. Sorry about the delay.
by NewDevGuy
Fri Jan 23, 2009 8:04 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

When I run SELECT MemID FROM members; I get MemID up to 753 returned, followed by: 753 rows in set (0.00 sec). MemID is the Primary Key, and set to auto-increment, so there's no duplicates or null values.
by NewDevGuy
Fri Jan 23, 2009 7:18 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Ok, using the CLI (locally) MySql displays members up to number 725, and says just below the readout: 753 rows in set (0.00 sec) If I use the SELECT * FROM members WHERE MemID > 725; (again, in the CLI) the remaining 28 records are returned, followed by: 28 rows in set (0.00 sec) And just to prove t...
by NewDevGuy
Fri Jan 23, 2009 6:47 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Right - weirdness ensued! The db was running on a hosting server which I had no access to the CLI on, so I exported it from the host and imported it to test on my local machine...and the exact same thing is happening! Right down to the fact that when I select ALL, member 1-725 show up, and when I sp...
by NewDevGuy
Fri Jan 23, 2009 5:56 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Ok VladSun,
That make's sense, I'll run it through the CLI and post result.
by NewDevGuy
Fri Jan 23, 2009 5:20 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

No. I figured that I'll be using phpMyAdmin to create most of my projects, and the results will be output through a browser, so whilst I can make it work through writing a seperate SQL query (>725) I was more interested in seeing why it isn't functioning as it should (either through the browser or u...
by NewDevGuy
Fri Jan 23, 2009 4:56 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Sorry about the delay replying - was called away unexpectedly for a few days. Here's the result of the Show Create query: CREATE TABLE `members` ( `MemID` int(11) NOT NULL auto_increment, `MemName` varchar(50) NOT NULL, `MemDOB` date NOT NULL, `MemCpoints` int(11) NOT NULL default '0', `MemTpoints` ...
by NewDevGuy
Mon Jan 19, 2009 3:42 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Both the phpMyAdmin pages (i.e. creating a SELECT * query in the SQL window, and using the 'Show' command on the Browse Table window to Show all, LIMIT 1000), and via a client app with a simple SELECT * query. I have also written a seperate script which just counts the records in the table - this re...
by NewDevGuy
Fri Jan 16, 2009 10:59 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Yep, I had already done a count on the result set - which returned 753. The code I used for this was: $memcount = mysql_query("Select COUNT(*) from members"); echo mysql_result($memcount,0); Which worked perfectly, showing me that there are 753 records in there, but the records from 725 on...
by NewDevGuy
Fri Jan 16, 2009 4:21 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 of 753 records being returned by select all??

Still unresolved - anyone got any ideas?
by NewDevGuy
Thu Jan 15, 2009 9:06 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 records being returned?

there are 753 members in the table. Are you basing that on the fact the highest member id is 753? No, although I see why you would ask that...no, there are 753 actual entries in the table, which is why this problem is so strange. No matter how I run the select all query (constructing a SELECT * FRO...
by NewDevGuy
Thu Jan 15, 2009 6:48 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Re: Only 725 records being returned?

SELECT * FROM `members`;

It's showing up the first 725 members, but there are 753 members in the table.
And what's even weirder is that phpMyAdmin is saying that it's showing all 753 members, when in actual fact it's not, it's only showing 725 of them.

And the table size is only 31.7kb
by NewDevGuy
Thu Jan 15, 2009 6:35 am
Forum: PHP - Code
Topic: Only 725 of 753 records being returned by select all??
Replies: 34
Views: 1417

Only 725 of 753 records being returned by select all??

Hi, I'm having a really unusual problem - I have 753 records in a table, but only the first 725 are being returned through a regular select * query, but if I do a select * where memberID > 725 all of the remaining records show up as normal. Even using the show command in phpMyAdmin to show 1000 reco...