previous link

surban99

please forgive me if not displaying the entire string of code is the wrong thing to do

im trying to define a variable as id-1 (id minus 1)

apparantly this doesn't work

   $result1 = mysql_query("SELECT * FROM news order by id desc",$db);
   $id = mysql_result($result1,0,"id");
   $prev = ($id-1);

and also when i pull it back up in code this doesn't seem to be working either

printf("<td width=\"33%\" align=\"left\"><font face=\"Arial\" color=\"#FFFFFF\"><a href=\"betahome2.php?id=%s\">&lt;&lt;prev</a></font></td>\n", $prev);

hopefully you can help with just these couple of snippets if not lemme know and i'll paste the entire code

chads2k2

I might take the long way around things but hey this will work.

// Select everything from news and return only the first ID in DESC order.
$sql_query = "SELECT * FROM news ORDER BY id DESC LIMIT 1";
$sql_result = mysql_query($sql_query);
while($sql_array = mysql_fetch_array($sql_result))
{
    $prev = $sql_array['id'];
    // Don't understand the previous but hey, here it is.
    $prev--;
}
?>

Don't understand the reason for going back one when you could specifiy other ways. But hey, it's all good. That is how I would go about it. Not the fastest way to do things but it shows what you could do it like.

Roger_Ramjet

Well now, if id is an autoinc then there is no guarantee that id-1 exists. Since you have extracted all of the rowes, just use

$result1 = mysql_query("SELECT * FROM news order by id desc",$db);
   $id = mysql_result($result1,0,"id");
   $prev = mysql_result($result1,1,"id");

chads2k2

I agree Roger.

Is he just trying to see what ID came before it? If so then your way would work easier than mine. I just didn't understand fully what they were attempting to do. Good job and way to go.

Chad