[anjum015]

Hi,
I've a database currently with 400 rows. When I query anything (from frontend,localhost) beyond 125 results are not returned. I'm using WAMP .

My query is very simple based on primary key I'm just doing SELECT * FROM tablename WHERE pid='variable';


The database will contain at least a 5000 rows. I'm not sure how to query.

[job0107]

How many results are returned when you say:
"SELECT * FROM tablename" ?

[sqlhjalp]

Did you confirm all that you have in the table?


mysql> SELECT count(pid) as cnt FROM tablename group by pid

Then you can at least confirm what all you have. Maybe you have different values that you think?

[nafirici]

some tools automatically limit the number of results. Check the preferences of the tool you're using to run the query. If you're having trouble finding this in preferences, you can order by asc then order by desc and see if the first record when you do desc was the same as the last record in asc.

[anjum015]

Thanks for quick reply. When I displayed the entire table all the records are being displayed.
A few things I dint mention before pid datatype is VARCHAR .

After a lot of trials what I observed is some values beyond 125 also get displayed. I'm not sure what is happening. My database content mostly ( mostly name, address) are in UTF8.

The following weird things I experienced.
When I query from frontend dev using PHP, if I enter say 150 I don't get any result.
my query in php is mysql_query("SELECT * FROM customerdb WHERE PID='$_POST[pid]'");
It dint give any result.
Just to try instead of using $_post [pid] I directly gave number. It worked at that time.
I'm not sure what the problem is.

I need to figure it out asap please help.

[anjum015]

Hi,
I think the problem was with the way it was getting stored as at the client's desktop they use a different software to input UTF8 characters.
I changed the query and queried using LIKE it is working fine now.
Thank you, I just panicked .
Thanks a lot everyone.

[nafirici]

Please also make sure that you sanitize your data to help prevent sql injections:
PHP: mysql_real_escape_string - Manual

[job0107]

It is possible that $_POST[pid] is not returning a value because it should probably be $_POST["pid"].
So after making that correction, try it like this:

PHP Code:

mysql_query("SELECT * FROM customerdb WHERE PID='".$_POST["pid"]."'"); 

[anjum015]

Hi,
The problem was with the way it was getting stored. Pid values were storing even '\t' while entering from the front end.