September 3rd, 2000, 11:02 PM
Join Date: Aug 2000
Location: Norcross, GA
Time spent in forums: < 1 sec
Reputation Power: 14
I think I have a bit of a problem on my hands.
Earlier tonight I thought I put the finishing touches on a
motorcycle database that I'd been working on for a few weeks. It was
my first Php/Mysql project and I was glad to get it working.
Well, as I was about to turn in I noticed an oddity. When querying
a table with 909 records, only 900 records are being searched. The
last 9 records are ignored. However, those final 9 records are
present and accounted for - I can do a query for a specific match at
the end of the table (#907, for instance) and it displays just fine.
I read in the MySQL documentation that it could handle over
50,000,000 records in a database. Surely it should be able to handle
a puny 1000 record table, right?
I'm really not sure if this a PHP problem or something else. I
hope someone here can shed some light.
Thanks once more,
// this one pulled up the husky CR listing at the end of the table
$result = mysql_query("SELECT * FROM spec WHERE brand='Husqvarna'
GROUP BY modelletters ",$db);
// this one pulled up everything except the husky CR listing (it
finds the first 900 records and ignores the rest)
$result = mysql_query("SELECT * FROM spec GROUP BY