Photo (prev & next)

[sharke]

Hi guys i need help for correct get photo id from datebase,

i have 4 photos to same category photo_id(7,8,22,28), now when i'm on photo 8 i have button only for Previous photo...

 

<?php
$result = mysql_query("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");
while ($data = mysql_fetch_assoc($result)){

$pres = mysql_query("SELECT photo_id FROM photos WHERE photo_id = '".($data['photo_id']-1)."' AND photo_catid='13'");
$nres = dbquery("SELECT photo_id FROM photos WHERE photo_id = '".($data['photo_id']+1)."' AND photo_catid='13'");

$prev = mysql_fetch_assoc($pres);
$next = mysql_fetch_assoc($nres);
}
?>

[sharke]

anyone 

[sharke]

nobody replay  , if i have in category 10 photos with random id's like (1,2,5,9,14) and when i'm on photo id 2 i have button only for previous photo ...

 

can somebody help me 

[rajivgonsalves]

you should use limit ? and this will be mysql not php

[Adam]

Guessing you didn't get a reply because you never actually asked a question.

[sharke]

$result = mysql_query("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");

where i must use limit here ? please example me

 

you should use limit ? and this will be mysql not php

[rajivgonsalves]

well you'll have to keep the current position in mind so I guess its php+mysql, following will show you the third image

 

 

$pos = 2;
$result = mysql_query("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'  limit $pos, 1");

[sharke]

if i used you this code mysql_num_rows return 0

 

$pos = 2;
$result = mysql_query("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'  limit $pos, 1");

[rajivgonsalves]

it should have been infact, will show you the third photo in the category you might want to order it so you get correct results

 

$pos = 2;
$result = mysql_query("SELECT * FROM photos WHERE photo_catid='13'  limit $pos, 1");

[sharke]

i dont see here result for now or my code is wrong...

 

photos.php?photo_id=2

<?php
$result = mysql_query("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");
while ($data = mysql_fetch_assoc($result)){

$pos = $data['photo_id'];
$result2 = mysql_query("SELECT * FROM photos WHERE photo_catid='13' limit $pos, 1");
$data2 = mysql_fetch_assoc($result2);

$pres = mysql_query("SELECT photo_id FROM photos WHERE photo_id = '".($data2['photo_id']-1)."' AND photo_catid='13'");
$nres = dbquery("SELECT photo_id FROM photos WHERE photo_id = '".($data2['photo_id']+1)."' AND photo_catid='13'");

$prev = mysql_fetch_assoc($pres);
$next = mysql_fetch_assoc($nres);
}
?>

[rajivgonsalves]

definitely some problem in the code, if you could post more code on where your using these variables it would be helpful

[sharke]

I hope you can now help me ..

 

Here is code...

 

<?php

if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){

$update_counter = mysql_query("UPDATE photos SET photo_views=photo_views+1 WHERE photo_id='".$_GET['photo_id']."'");

$result = dbquery("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");
if(mysql_num_rows($result)){
   while ($data = mysql_fetch_assoc($result)){
    
    $pres = dbquery("SELECT photo_id FROM photos WHERE photo_id = '".($data['photo_id']-1)."'");
    $nres = dbquery("SELECT photo_id FROM photos WHERE photo_id = '".($pole['photo_id']+1)."'");
    
    if (mysql_num_rows($pres)) $prev = mysql_fetach_assoc($pres);
    if (mysql_num_rows($nres)) $next = mysql_fetach_assoc($nres);
    
    if ((isset($prev['photo_id']) && isnum($prev['photo_id'])) || (isset($next['photo_id']) && isnum($next['photo_id']))) {
      if (isset($prev)) { <a href='".$PHP_SELF."?photo_id=".$prev['photo_id']."'>Prev Photo</a> }
      if (isset($next)) { <a href='".$PHP_SELF."?photo_id=".$next['photo_id']."'>Next Photo</a> }
    }
   }
  }
}
?>

[rajivgonsalves]

might you explain exactly what are you trying to do in this script ?

[sharke]

Ok this is simple photo gallery script, in photos.php show thmubmanils, photos.php?photo_id=2 here get full size of image, i need set buttons for next and previous photos from same category.

In category(13) i have 5 photos  id's(1,2,5,9,14).

 

If i use pasted code and i watch photo with ID 2 only i get button for previous not for next photo with id(5).

 

i hope you can undastand me...

Soryy for bad english ....

[rajivgonsalves]

try this out hopefully it works

 

<?php

if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){
$update_counter = mysql_query("UPDATE photos SET photo_views=photo_views+1 WHERE photo_id='".$_GET['photo_id']."'");

$result = dbquery("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");
    if(mysql_num_rows($result)){
        $data = mysql_fetch_assoc($result);

        $cat_photos_res = dbquery("SELECT photo_id FROM photos WHERE photo_catid = '{$data['photo_catid']}'");
        $cat_photos = array();
        while ($row = mysql_fetch_assoc($cat_photos_res)) {
            $cat_photos[] = $row['photo_id'];
        }

        $photo_index = array_search($cat_photos, $_GET['photo_id']);

        if (isset($cat_photos[$photo_index-1])) { echo "<a href={$_SERVER['PHP_SELF']}?photo_id=".$cat_photos[$photo_index-1]."'>Prev Photo</a>"; }
        if (isset($cat_photos[$photo_index+1])) { echo "<a href='{$_SERVER['PHP_SELF']}?photo_id=".$cat_photos[$photo_index+1]."'>Next Photo</a>"; }
    }  
}
?>

[sharke]

now i get this error Warning: array_search() [function.array-search]: Wrong datatype for second argument in C:\xampp\htdocs\site\photos.php on line 16.

 

Now i have button for next photo, no button for previous...

[rajivgonsalves]

this

 

$photo_index = array_search($cat_photos, $_GET['photo_id']);

 

should have been

 

$photo_index = array_search($_GET['photo_id'], $cat_photos);

[sharke]

Strage, when i watch photo with id 1  Previous button show photo id(19) Next button show id(2)..

[rajivgonsalves]

try this 

 

<?php

if (isset($_GET['photo_id']) && isnum($_GET['photo_id'])){
$update_counter = mysql_query("UPDATE photos SET photo_views=photo_views+1 WHERE photo_id='".$_GET['photo_id']."'");

$result = dbquery("SELECT * FROM photos WHERE photo_id='".$_GET['photo_id']."'");
    if(mysql_num_rows($result)){
        $data = mysql_fetch_assoc($result);

        $cat_photos_res = dbquery("SELECT photo_id FROM photos WHERE photo_catid = '{$data['photo_catid']}' order by photo_id");
        $cat_photos = array();
        while ($row = mysql_fetch_assoc($cat_photos_res)) {
            $cat_photos[] = $row['photo_id'];
        }

        $photo_index = array_search($_GET['photo_id'], $cat_photos,);

        if (isset($cat_photos[$photo_index-1])) { echo "<a href={$_SERVER['PHP_SELF']}?photo_id=".$cat_photos[$photo_index-1]."'>Prev Photo</a>"; }
        if (isset($cat_photos[$photo_index+1])) { echo "<a href='{$_SERVER['PHP_SELF']}?photo_id=".$cat_photos[$photo_index+1]."'>Next Photo</a>"; }
    }  
}
?>

[sharke]

Working perfectly 

Thank you very much !!