I am pulling my hair on the JSU Data Grid.
It correctly calculates the number of rows I currently have 22 rows, which gives 3 pages in the grid. The second page does not appear though I do not get it. The third page works
I have a suspicion on my SQL, and offset and limit, but what is wrong? I have set $ offsets and $ rows in this way (e.g. by JCEE)
$ page = isset ($ _ POST ['page'])? Interval ($ _ POST ['page']): 1; $ Line = release ($ _ POST ['rows'])? Interval ($ _ POST ['rows']): 10; $ Offset = ($ page-1) * $ rows;
I'm using this selection to get the data $ rs = mysql_query ("Select z.list_name as the name , Z.list_pointsPerHour as PPH, as the acquisition of List_takeoverPoints zone z, tempzones tz where z.list_id = tz.zoneid limit $ offset, $ rows ");
If I put $ rows 20 into the file and run php from the command line, then it does not give anything, if I leave it at 10 then gives 10 and happiness 22 total
SQL uses hacking as defined values in the MySQL console and for offset and boundary tasks.
My site is turned on:
And it is such an example that I
I was unsuccessful, so it was all about me I have Latin 1 in my database and PHP is relatively UTF-8. Ouput and forced UTF-8 problem solved
No comments:
Post a Comment