PHP - Find Value Of Previous Row?

I'm trying to create a function where you specify the $points it will then do some mathematical stuff with the $points (explain later) an return an array containing the $rank and $level.

The mathematical stuff:

It starts at 99 and when it reaches +199 it changes the key of the array.

I'm not sure how to describe this theirfore i'll just provide examples:

Example 1:

If $points <= 99

It will return an array containing $ranks[0] and $levels[0], would be the following:

return array('Peon', 0);

Example 2:

If $points >= 100 && $points <= 299

It will return an array containing $ranks[1] and $levels[1], would be the following:

return array('Grunt', 1);

Example 3:

If $points >= 300 && $points <= 499

It will return an array containing $ranks[2] and $levels[2], would be the following:

return array('Berserker', 2);

etc.. until it reaches the 7th key of the $ranks/$levels array

Heres my code:

<?php

function rank($points){
//their are 0-7 levels
$levels = range(0, 7);

//7 ranks
$ranks = array('Peon', 'Grunt', 'Berserker', 'Tauren', 'Spirit Walker', 'Wind Rider');

for(...) {
return array($rank, $level);
}
}
?>

Hi all,
I have a fairly simple problem, but i cannot get to it. I have a page, that displays one (1) record at the time, and I want to have forward and back buttons (links) at the top and bottom of the page. Can anyone help me with that???
Here is a part of my code.

Code: [Select]
<form method="get">
<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<tr><td align="center">
  Select first letter or kind of the story:
  <input type="hidden" name="link" value="stories.php">
<input type="hidden" name="Pripadnost" value="3">
<select name="letter" onchange="this.form.submit()">
<?PHP
$letter =  trim($_REQUEST["letter"]);
?>

<option value="Sve" <?PHP echo $letter == "All" ? " selected " : "" ; ?>>All</option>
<?PHP
include_once ("/includes/databaseMySQL.php");
mysql_set_charset('utf8');

$SQL = "Select distinct ucase(left(title,1)) as sl FROM tblStoryes order by sl";

$rs_data = mysql_query($SQL) or die(mysql_error());
while ($row_data = mysql_fetch_assoc($rs_data)) {
      ?>
      <option value="<?PHP echo $row_data["sl"]; ?>"<?PHP echo $letter == $row_data["sl"] ? " selected " : "" ;
  echo ">".$row_data["sl"] ;?></option>
      <?PHP
 // ******************  Listed all the first letters of the titles into a drop box. *********************** //
} ?>
</select> &nbsp; &nbsp; &nbsp;
Bosnian <input type="checkbox" name="Bosnian " <?PHP echo isset($_REQUEST["Bosnian "]) ? "checked=checked" : "" ;?> onclick="this.form.submit()" />  &nbsp;
Turkish <input type="checkbox" name="Turkish "  <?PHP echo isset($_REQUEST["Turkish "]) ? "checked=checked" :  "" ;?> onclick="this.form.submit()" />  &nbsp;
Arabian <input type="checkbox" name="Arabian "  <?PHP echo isset($_REQUEST["Arabian "]) ? "checked=checked" : ""  ;?> onclick="this.form.submit()" />

</td></tr>
</table>

<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<?PHP
$id = -1;
$rs_data = mysql_query("Select max(id) as maxid from  tblStories WHERE aktivno = True") or die(mysql_error());
$row_data = mysql_fetch_assoc($rs_data);
$maxid = (int) $row_data["maxid"];

 // ******************  Found the largest ID from the table. *********************** //

$SQL = "SELECT * FROM tblStories WHERE aktivno = True ";


if ( strlen($letter) < 3 && strlen($letter) > 0 ) {
$SQL = $SQL . " and ucase(left(`title`, 1)) = '" . $Letter . "'";
}

$lang = 0;
$lang = $lang + isset($_REQUEST["Bosnian"]) * 4;
$lang = $lang + isset($_REQUEST["Turkish"]  ) * 2;
$lang = $lang + isset($_REQUEST["Arabian"] );
switch ($lang) {
    case 6: // bos i tur
        $SQL = $SQL . " and ( Bosanski = 1 or Turski = 1 ) ";
        break;
    case 5: // bos i ar
        $SQL = $SQL . " and ( Bosanski = 1 or Arapski = 1) ";
        break;
case 4: // bos
        $SQL = $SQL . " and Bosanski = 1 ";
        break;
    case 3: // tur i ar
        $SQL = $SQL . " and ( Turski = 1 or Arapski =1) ";
        break;
    case 2: // tur
        $SQL = $SQL . " and Turski = 1 ";
        break;
    case 1: // ar
        $SQL = $SQL . " and Arapski =1 ";
        break;
}


if (trim($_REQUEST["DBid"]) <> ""  or  $_REQUEST["DBid"] > 0)
$SQL = $SQL . " and  id > " . trim($_REQUEST["DBid"]) ;
$SQL = $SQL . " LIMIT 1"; //order by naslov

$rs_data = mysql_query($SQL) or die(mysql_error());
echo "<!--" . $SQL . " : Jezik je:" . $lang . "-->";
while ($row_data = mysql_fetch_assoc($rs_data)) {
$id = (int) $row_data["ID"];
?>
  <tr>
<td align="center" colspan=3>
       <h3><?PHP echo $row_data["Title"];?> </h3>
    </td>
    </tr>   
    <tr>
      <td width=20%>&nbsp;
      </td>
      <td align="justify" width=60%>
        <?PHP  echo $row_data["tekst"]; // tekst = text, but not keyword ?>
      </td>
      <td width=20%>&nbsp;
      </td>
    </tr>
<?PHP
}
?>
</table>
<p>

<?PHP
// ****************************** HEEEEELLLLPPPPPP ******************************* //
?>

<table border="0" width="90%" cellpadding="1" align="center">
  <tr>
    <td align="center"><a href="?DBid=1<?PHP
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
} ?>"> &lt;&lt;</a></td>
    <td align="center"><a href="?DBid=<?PHP
echo $_REQUEST["id"];
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>" >&lt;</a></td>
<?PHP if (  $maxid <=  $id ) { ?>
    <td align="center">&gt;</td>
    <td align="center">&gt;&gt;</td>
<?PHP }
  else
  {?>
    <td align="center"><a href="?DBid=<?PHP
echo $id ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;</a></td>
    <?PHP if ( ($id + 9) <  $maxid ) { ?>
    <td align="center"><a href="?DBid=<?PHP
echo $id+10 ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;&gt;</a></td>
    <?PHP
    }
    else
      {?>
        <td align="center">&gt;&gt;</td>
<?PHP }?>   
<?PHP }?>
  </tr>
</table>
</form>

How can I get the next four and previous four rows?

Here is what I have and it isn't working at at all.
$q1 = Mysql::query("SELECT id, file, dir FROM photos WHERE id > $id AND album = '$al' ORDER BY id ASC LIMIT 4");
$q2 = Mysql::query("SELECT id, file, dir FROM photos WHERE id < $id AND album = '$al' ORDER BY id DESC LIMIT 4");

I am trying to create a gallery page, one photo on the page with Next/Previous links either above or below but am having a little local difficulty. This is what I have:-

Code: [Select]
//>>> Set up arrays and variables <<<
$piccies = array();
$exif = array();
$exifdata = array();

$pic = 0;
$img ='';
$date = '';
$time = '';
$caption = '';
$copyright ='';
$imageid = 1;
$first = 1;
$last = 5;
$self = $_SERVER['PHP_SELF'] . "?imageid=";

//>>> Read images from folder and assign to the array $piccies[] <<<
$piccies = read_folder();


//>>> Find image and extract the Exif info <<<
$exif = read_exif_info($piccies, $pic);



//>> Populate with required info from $exifdata with required info from $exif
$exifdata = populate_exif_data($exif, $date, $time);

$img = substr_replace($img, "", 0, 2);

?>

<div id="pict">
<img src="<?php echo $img; ?>" />
  <?php
  echo "<p>" . $caption . "</p>";
  if ($imageid < $last) {
    echo "<a href=" . $self . ($imageid + 1) . "><h2>Next</h2></a>";
}
if ($imageid > $first) {
    echo "<a href=" . $self . ($imageid - 1) . "><h2>Previous</h2></a>";
}
  ?>
</div>
It puts the 'Next' link in fine, but when clicked the link goes to the Parent directory:-

Index of /php/gallery
[ICO]   Name   Last modified   Size   Description
[DIR]   Parent Directory        -    
[ ]   functions.php    27-Oct-2011 09:25    2.1K   
[ ]   gallery index.php    27-Oct-2011 09:45    1.8K   
[DIR]   images/    26-Oct-2011 16:00    -    

and when I look at the source I see that the link has not been constructed as I expected. This is the source:-

Code: [Select]
<div id="pict">

<img src="images/blue sky.jpg" />
  <p>Blue Sky over Auld Reekie</p><a href=/php/gallery test.php?imageid=2><h2>Next</h2></a></div>

where '/php/gallery test.php' is showing I expected 'images/filename.jpg' etc. and I just can't figureout what I have done wrong...

Hi all,

Anyone give me a few hints how I can add a next and previous button to my pagination links? I currently have this:
<?php
}
if($total_records > 5)
?>
<div id="pg">
<?php
{
for ($i = 1; $i <= $total_pages; $i++) {

echo "<a title='page $i' class='current' href='?catid=" . $catid ."&";
if($subid > 0)
{
echo "subid=";
echo $subid . "&";
}
echo "p= $i'>$i</a>";
}
}
?>

</div>

Which displays them nicely, but I would like a next and previous button.

Cheers