[SOLVED] MySql List Result in Pages

[Msword]

How can i list mysql result in pages(Like result 1-25 on page 1, 26-50 page 2 and so on)

currently using codes:

while($row = mysql_fetch_array($result))

 

    $result = mysql_query("SELECT pid, name,location, quest, membonly FROM pdatabase
    ORDER BY " . $by . " DESC");

[Utech22]

You need to create a recordset, that what I know so far.

I have a project that I am doing and I will need to do that also;

[Msword]

wouldn't there be some way i could just loop it?

[teng84]

i cant give you the full detail but your talking with sql paging

 

and it work by pasing the value in the url like

?page=2

$x=$_GET['page']*10;//= 20 right? use this as the max value

$y=$_GET['page']-1*10;//= 10 right? then use this as the min value

 

then do something in your sql statement like

 

select * from table limit $x,$y

 

edited.......

dont use it exactly use this as prototype only there are lots of code in the net

 

[teng84]

You need to create a recordset, that what I know so far.

I have a project that I am doing and I will need to do that also;

 

LOL what?????

[Msword]

thanks again teng, thats what i needed

yup, i just went to the mysql documentation and looked at it there.

[Msword]

new problem, this is giving me syntax error. The variables are right, $page == 0. $by == pid. i want it to display 1-25 and i just gives error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.marja/msword/draftx.net/test/displaytable.php on line 54

 

if ($sort == "asc")
    {
    $result = mysql_query("SELECT pid, name,location, quest, membonly FROM pdatabase LIMIT '$page', 25
    ORDER BY " . $by);
    }
    ELSE
    {
    $result = mysql_query("SELECT pid, name,location, quest, membonly FROM pdatabase LIMIT '$page', 25
    ORDER BY " . $by . " DESC");
    }

technicly the error is when i'm displaying, but i know that works

while($row = mysql_fetch_array($result))