[RESOLVED] Yep another pagination question.. sigh.. lol

0o0o0

Ok I did search, and I did search google.

I am looking for a single result per page pagination..

Similiar to those rate my face websites... but this if for local cottages..

So.. first cottage comes up.. out of the database.

the page shows it.. and nothing more than a next button...

then the next page is the next single photo of a cottage.. and then the next / prev button..

ok simple right?? I created this.. its done.. heres the issues with pagination if this is in fact a pagination job at all..

pagination doesnt go well with google.. example page?pg=1 page?pg=2 page?pg=3 and so on... well if i add more cottage photos.. then the 1st cottage photo is going to be the 4th cottage photo.. and if google botted it as cottage luxeria... it will say here it is page?page=1 but in 3 months it will not be that.

so.. indexing? right?? ok.. so cottage 1 is now id 1111

and say cottage 1054 1056 etc etc are all removed from the DB...
now when I paginate.. and i go from id=1000... it wants to grab 1001... not 1111.. so on.

does anyone have any guidelines for creating a rate my face.. in my case cottage php script??

I want cottage luxeria to be googled as a page..

is pagination even what im seeking?? I saw this on a date site.. and this is a form forward technique that seems to be flawless but I have no idea where to start on this one..


 <form action="meetme.aspx" method="post"  id="form1" name="form1"> 
       <input type="hidden" name="add_id" value ="28667977"> 
       <input type="hidden" name="next26" value ="26883214,28590733,28654666,28681535,27273243,28576166,28613584,28591951,28515273,28541847,18296015,28594117,27206532,21878719,28590233,28663167,5039360,28636411,28569000,28645007,28587048,28569415,7815397,26626891,28671149,28570991">   

      <input type="hidden" name="p_Id"  value ="28667977">
//dont need below just showing you the rest of the snippet from the date site. 
<INPUT TYPE="image" SRC="image/yes.png" NAME="votea" VALUE="1<INPUT TYPE="image" SRC="image/maybe.png" NAME="voteb" VALUE="2'><INPUT TYPE="image" SRC="image/no.png" NAME="votec" VALUE="3"> </form>

now all those numbers are members.. and those are their pages that can also be googled .. with pagination I have a feeling it can only be page?page=1 links..

sure theres mod rewrite.. but it gets tricky trying to get the index number out.

anyone have any ideas lol.. did I even describe this correct?? lol..

Derokorian

To get the next and previous ID in a series (assuming using an auto_increment column) and being mindful of possibly missing IDs in the numerical order you can issue 2 queries:

-- Get previous ID
SELECT id FROM myTable WHERE id < $id ORDER BY id DESC LIMIT 1

-- Get Next ID
SELECT id FROM myTable WHERE id > $id ORDER BY id ASC LIMIT 1

Where $id is the current item's ID.

0o0o0

lol k thanks! 1 hour lookin online.. how would I code this into a button.

I know im askin for answers but I put an hour into it lookin online to find it..

link

0o0o0

was going to ask another question... but figured it out.

0o0o0

yep 6 1/2 hours later...

i got this..

$prev = "SELECT id, num FROM `mydb` WHERE `act` = 'Y' and id < $id ORDER BY id DESC LIMIT 1";


$result1 = mysql_query($prev)

 or die ("Couldn't execute query.");

   while ($row1 = mysql_fetch_array($result1))             

 {
 extract($row1);         

If($id == ''){  

echo "<img src=\"images/blank.png\" width=\"45\" height=\"45\" alt=\"Previous Listing\"  class=\"pic2\"/>";
}else{
echo "<a href=\"http://www.imgonnastickapeninmyeyeohmygod.com/test/".$num.".html\"><img src=\"images/backbutton.png\" width=\"45\" height=\"45\" alt=\"Previous Listing\"  class=\"pic2\"/></a>";

}
}

yep 6 hours of my life for a few lines.. lol..

it works!!!! then to find out.. if a row cant be found...my ELSE statement cant work.. so the place holder blank button in my html page.. does'nt place hold and the whole page unaligns..

what do I do to have the BUTTON... or when theres no rows left.. A blank button.

Im proud to be a total newbieFACE!!!

I searched google, and even here.. seeking the code for If($id == '' or ==='' or =="" or ==NULL or ==FALSE or ==KILLME or ==HEYLOOKAUNICORN! or ==WHOSTHERE?ICANHEARYOU

NIGHT EVERYONE!!.. oh.. 4:40am, no ones here.

cretaceous

yeah but if you want good google results you need the name in there - can be just a decorative entry in the url that is ignored by the code - still needs mod_rewrite but its simpler

0o0o0

oh no I have rewrite its perfect in 4 keyword.html

the problem is now my blank place holder image doesnt show up then it gets to the end of the rows.... rows = 0 the else statement should put blank.png placeholder button in the spot where the visual button used to be.

what is the code for IF ($id ...... isnt there... is it =='' or ==="" or ?? thats my next question.

0o0o0

brad you answered it on my other thread (was separate ) still need help with that.

Im going to make this thread resolved as they are both now flowing into the same questions.