query question

[corillo181]

why is this query work fine
[code]
$sel=mysql_query("SELECT photo_id FROM tra_photo WHERE album_id='".$_GET['a']."' AND photo_id>'$foto_id'")or die(mysql_error());
$back=mysql_fetch_array($sel);

[/code]
but this one doesn't
[code]
$sel=mysql_query("SELECT photo_id FROM tra_photo WHERE album_id='".$_GET['a']."' AND photo_id<'$foto_id'")or die(mysql_error());
$next=mysql_fetch_array($sel);

[/code]
the next link sends me to the first id instead of the next id from wich ever is selected at the time..

[hvle]

2 query is exactly same, and therefore it must return exact result and that's why your $next is same as your $back

[PC Nerd]

well the only difference between the two querys physically is the < versus the > in the photo id section i think

[Daniel0]

Try: [code]$sel = mysql_query("SELECT photo_id FROM tra_photo WHERE album_id='".$_GET['a']."' AND photo_id=photo_id-1")or die(mysql_error());
$back = mysql_fetch_array($sel);

$sel = mysql_query("SELECT photo_id FROM tra_photo WHERE album_id='".$_GET['a']."' AND photo_id=photo_id+1")or die(mysql_error());
$next = mysql_fetch_array($sel);[/code] instead

[corillo181]

i can't use +1 or -1.. becuase it goes down to the next id..

if i'm in id 20 and i put 20-1=19 if 19 belongs to another album id it wont show nothing.

[.josh]

it is giving you the 1st one because by default mysql orders by ascending order.  tack on an "order by desc" on the end of your "back" query.