SEO

#1 (**permalink**) 02-28-2008, 07:57 AM

Hi,

I am using MySQL and PHP for my repository. It has 500+ records. till
now it was displayiing all records in the database, but since from one
week its not displaying all 500+, its showing only 400 records..

even in command mode its retrieving only 400 records. please help me to
solve this problem. what may be the problem i am not able to traceout.
and if i give the following command it will show records in command
line. "select soft_id, soft_title, file_name from maintable where
soft_id='530';"

Waiting for reply
Geetha

#2 (**permalink**) 02-28-2008, 07:57 AM

geetha.veeraiah@gmail.com wrote:
> Hi,
>
> I am using MySQL and PHP for my repository. It has 500+ records. till
> now it was displayiing all records in the database, but since from one
> week its not displaying all 500+, its showing only 400 records..
>
> even in command mode its retrieving only 400 records. please help me to
> solve this problem. what may be the problem i am not able to traceout.
> and if i give the following command it will show records in command
> line. "select soft_id, soft_title, file_name from maintable where
> soft_id='530';"
>
> Waiting for reply
> Geetha
>

How do you know you have over 500 rows in the table? It sounds to me
like you've only got 400 rows.

And your SELECT statement will only show row(s) which have soft_id equal
to '530', not all rows.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

#3 (**permalink**) 02-28-2008, 07:57 AM

Hi,

There are 539 records, i can see them if i give the query like

select soft_id, soft_title from maintable where soft_id='499';
this query will show the soft_id and corresponding soft title which we
have uploaded. I can see up to 539 software one by one by using this
query, but if i give

select * from maintable;
this query retrieves only 400 software details

that means records are there, but not displaying them.

Please help me in this regard

Regards
Geetha

Jerry Stuckle wrote:
> geetha.veeraiah@gmail.com wrote:
> > Hi,
> >
> > I am using MySQL and PHP for my repository. It has 500+ records. till
> > now it was displayiing all records in the database, but since from one
> > week its not displaying all 500+, its showing only 400 records..
> >
> > even in command mode its retrieving only 400 records. please help me to
> > solve this problem. what may be the problem i am not able to traceout.
> > and if i give the following command it will show records in command
> > line. "select soft_id, soft_title, file_name from maintable where
> > soft_id='530';"
> >
> > Waiting for reply
> > Geetha
> >
>
> How do you know you have over 500 rows in the table? It sounds to me
> like you've only got 400 rows.
>
> And your SELECT statement will only show row(s) which have soft_id equal
> to '530', not all rows.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

#4 (**permalink**) 02-28-2008, 07:57 AM

If you can see a record with id 499, that does not mean that all records
with lower id values still exist (or have even existed altogether). The
query:

SELECT COUNT(0) FROM maintable

should tell you how many records there are.

Best regards

geetha.veeraiah@gmail.com wrote:
> Hi,
>
> There are 539 records, i can see them if i give the query like
>
> select soft_id, soft_title from maintable where soft_id='499';
> this query will show the soft_id and corresponding soft title which we
> have uploaded. I can see up to 539 software one by one by using this
> query, but if i give
>
> select * from maintable;
> this query retrieves only 400 software details
>
> that means records are there, but not displaying them.
>
> Please help me in this regard
>
> Regards
> Geetha
>
> Jerry Stuckle wrote:
>> geetha.veeraiah@gmail.com wrote:
>>> Hi,
>>>
>>> I am using MySQL and PHP for my repository. It has 500+ records. till
>>> now it was displayiing all records in the database, but since from one
>>> week its not displaying all 500+, its showing only 400 records..
>>>
>>> even in command mode its retrieving only 400 records. please help me to
>>> solve this problem. what may be the problem i am not able to traceout.
>>> and if i give the following command it will show records in command
>>> line. "select soft_id, soft_title, file_name from maintable where
>>> soft_id='530';"
>>>
>>> Waiting for reply
>>> Geetha
>>>
>> How do you know you have over 500 rows in the table? It sounds to me
>> like you've only got 400 rows.
>>
>> And your SELECT statement will only show row(s) which have soft_id equal
>> to '530', not all rows.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstucklex@attglobal.net
>> ==================
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

MySQL Database not retrieving the full database