Moving through customer list

airedale

I am writting code to move through a customer list and at first I wrote it like this:

if (isset($direction))
{
if ($direction == 'forward')
{
$eid = $eid + 1;
}
elseif ($direction = 'backward')
{
if ($eid = 1)
{
$eid = 1;
}
else
{
$eid = $eid - 1;
}
}
}

The problem is that if something is deleted from the table the eid number does not get replaced. So if I were on eid #4 and I wanted to go to the next customer it should add +1 to $eid and give me an $eid = 5. If the customer that was in there got deleted and the next number in the database was actually 6, it wouldn't return anything. How can I fix this so I can seamlessly move through the customer list?

Thanks!

cgraz

Can you explain what your code is doing, how it works, etc. I'm sure there's a way to fix this, but I'd need more info as to what your code does (obviously you can go forward and backwards through the customer list).

You could maybe use next and previous links, setting a limit of 1 result per page? It really depends on what you're doing.

also on your if statement, don't use one equal sign or only the first if would be executed EVERY time. one equal sign means assigned to, two equal signs means is equal to

// if forward is assigned to direction 
if ($direction = 'forward') // will always return true

// if $direction is equal to forward
if ($direction == 'forward') // will return true only if $direction is equal to foward

Cgraz

sgoku01

I think airdale means something like this:

Database:
eid - username
1 - blaaah
2 - blaah
#3 is deleted
3 - blh

You could check if the number exists in the database. If so, show the member, else try again with the number+1.

airedale

sgoku01, that is exactly what I mean

cgraz, thanks for catching that typo... I meant to have two =

I am trying to move through a member database and the primary key is eid, so I am just trying to use that as a means to move either forward or backwards through my list...

cgraz

Copy and paste this to your texteditor, save, and upload to your server. Play around with it, then once you see how it all works, modify it to suit your needs.

<?

// make sure to add your db connection and select your db

// also change $table to your table name
$query = "SELECT eid FROM $table";
$result = mysql_query($query);

// set starting value (don't change)
$row2 = "";

// add \n so that you can later convert to array
while($row = mysql_fetch_array($result)) {
  $row2 .= $row["id"] . "\n";
}

// create array
$row2 = explode("\n", $row2);

// delete last value which is empty
array_pop($row2);

// set these values to what you want. You can delete them and do this dynamically later
$eid = "5";
$direction = "forward";

if ($direction == 'forward') {
   // $key will return the corresponding key for where you are currently at
   $key = array_search($eid, $row2);
      echo "Currently At: " . $row2[$key] . "<br>\n";
   // will go to the next key
   $key = $key + 1;
      echo "Next id in DB " . $row2[$key] . "<br>\n";

} elseif ($direction == 'backwards') {
   // $key will return the corresponding key for where you are currently at
   $key = array_search($eid, $row2);
      echo "Currently At eid: " . $row2[$key] . "<br>\n";
   // will go to the previous key
   $key = $key - 1;
      echo "Previous eid in DB " . $row2[$key] . "<br>\n";

}


?>

Basically what it does it puts all the eid's in an array then uses that to figure out which is next or previous.

Cgraz