The problem i'm having is that the table is not giving out the whole records, could it be the db server or my query?
LifeinAsia
5:32 pm on Sep 8, 2014 (gmt 0)
table is not giving out the whole records,
Do you mean not all the records are being returned or that not all the text of long strings is being returned? Can you provide a short example of what's expected and what is actually returned?
Dammy
8:11 pm on Sep 8, 2014 (gmt 0)
ex. i have 10 users in the user table, SELECT * FROM user; 2 records is returned!.
LifeinAsia
8:29 pm on Sep 8, 2014 (gmt 0)
My guess is that it's a server configuration issue, although limiting results to 2 records is a ridiculous limit.
How are you viewing the results (through cPanel or code)?
Dammy
8:43 pm on Sep 8, 2014 (gmt 0)
It is through a php function mysqli_query():, but if i use cPanel or phpMyadmin it works well.
brotherhood of LAN
8:46 pm on Sep 8, 2014 (gmt 0)
Do you have any other code in your mysqli_query loop, perhaps another query?
Dammy
9:05 pm on Sep 8, 2014 (gmt 0)
No!. but did you mean another query in the while(): loop or a subquery in the main query?
brotherhood of LAN
9:08 pm on Sep 8, 2014 (gmt 0)
A query in the while loop. If you'd used MYSQLI_USE_RESULT for the 1st query the full result set wouldn't be returned if there was another query in amongst the loop.
Dammy
9:26 pm on Sep 8, 2014 (gmt 0)
Thanks for that i've saw my mistake with what you said, & big thanks to LifeinAsia for the help!. its nw working!.
