for loop for prev link

peeter_talvistu

hi,

i have a bit of a problem with arrays. all editorials are in a database (scanner). when an editorial is shown the url would look like scanner.php?id2=12

now, i would like to make a link that points to the previous editorial. here arises a problem - although the id-s are auto incremented, users can delete editorials as they wish and so i just can't use $id2 - 1

so, i take all the id-s in scanner into an array and then i would like to use a for loop to reach a point in that array where the array id equals $id2.

however, i don't know anything about for loops and i'm badly stuck.

my code is as follows:

$scanprev = ("SELECT id FROM scanner order by id desc");

while ($id34 = mysql_fetch_array($prevresult))

{
$id35[] = $id34['id'];
}

for ($uu = current($id35);;next($id35)) {
if ($uu == $id2) {
break;
}
print $uu;
}

the next step would be to make another next($id35); and get the id for previous editorial.

if anybody could help me (or even point out a better way), i would greatly appreciate it.

peeter

TTT

when you use id you can also use index from array, assuming that array is like Array[$index][{id}].
so put the index from array to url ex. index.php?id=$Array[$index][0]. like this you can avoid that db increment problem. for further use you can fetch your array: Array[$index][{id,name,time ...}]

hope this helps.

TTT

... if last one was not clear enough:

$foo = Array();
$index = 0;
$query = select id,name from table
while(mysql_fetch_row($query))
{
$foo[$index][0] = mysql_result($query,1)
$foo[$index][1] = mysql_result($query,2)
}

if(!isset($id))
{
echo $foo[0][0];
}
elseif(isset($prev))
{
echo $foo[$id-1][0];
}
elseif(isset($next))
{
echo $foo[id+1][0]
}

peeter_talvistu

hi,

i tried your shorter advice to my last question, but couldn't get i working.
so i came back to this one and tried it once again.
code looks like this:

include("connect.inc");

$activescan = ("SELECT id FROM scanner order by id desc");

// get results 
$scanresult = mysql_query("$activescan"); 
if (!$scanresult) {      
 echo("<P>Error performing query: " .           
      mysql_error() . "</P>");      
 exit();  
}

$foo = Array();
$index = 0;
while(mysql_fetch_row($scanresult))
{
$foo[$index][0] = mysql_result($scanresult,"8");

}

echo $foo[0][0];

this returns 1 as the value for echo command.
also, if i try to use other values beside 8 mysql either times out or says that it was unable to jump to that row.

can you give me any advice?