[RESOLVED] Help with UPDATE.

[_DuDe_]

Ok, so I have a webpage where people can view pics of others according to their ID.

Well, I have

<?php
include 'connect.php';
session_start();
if (isset($_SESSION['name'])) 
  {
    $name=$_SESSION['name'];
$userstats="SELECT * from students where name='$name'";
$userstats2=mysql_query($userstats) or die("Could not get user stats");
$userstats3=mysql_fetch_array($userstats2);
print "<img src='http://alpha.lw210.org/srs/picts/0$userstats3[next].jpg' width='250' height='300'>&nbsp;";
print "&nbsp; &raquo; <span class='style2'>ID #: 0$id</span>";
if($id == 80328) {
print "&nbsp;<span class='style2'> &raquo; - This is the webmaster!</span>";
}
function do_next() {
$nextid="update students set next=next+1, num=num+1 Where name='$userstats3[name]' ";
mysql_query($nextid) or die("Could not save next ID");
}
function do_last() {
$lastid="update students set next=next-1, num=num+1 Where name='$userstats3[name]' ";
mysql_query($lastid) or die("Could not save last ID");
}
function do_lookup() {
$idnum = $_POST['idnum'];
$lastid="update students set next='$idnum', num=num+1 Where name='$userstats3[name]' ";
mysql_query($lastid) or die("Could not save last ID");
echo '<META HTTP-EQUIV="Refresh" CONTENT="1; URL=pics.php">';
}
}
?>

as the code and when the person hits Next > or < Last, it is changing the value of 'next' for everyone.

Please Please help.

[toxic_brain]

pls be specific.. point out the problem, post only the relevent codes..

[_DuDe_]

ok, sorry. When the person click the button to view the next ID number's pic, or the last person, or if they put in a custom ID, it changes the value of 'next' in mysql to the same for everyone. I want it to change it only for that person. If you still need more specifics, please tell me.

function do_next() {
$nextid="update students set next=next+1, num=num+1 Where name='$userstats3[name]' ";
mysql_query($nextid) or die("Could not save next ID");
}
function do_last() {
$lastid="update students set next=next-1, num=num+1 Where name='$userstats3[name]' ";
mysql_query($lastid) or die("Could not save last ID");
}
function do_lookup() {
$idnum = $_POST['idnum'];
$lastid="update students set next='$idnum', num=num+1 Where name='$userstats3[name]' ";
mysql_query($lastid) or die("Could not save last ID");
echo '<META HTTP-EQUIV="Refresh" CONTENT="1; URL=pics.php">';

[Weedpacket]

$userstats3 (let alone $userstats3['name']) wouldn't exist in any of those three functions, because you never passed $userstats3 to the function. So the queries you're sending to the database read like

update students set next=next-1, num=num+1 Where name=''

Why that would change every record is a mystery, unless the name field is blank in all of them.

[_DuDe_]

Is it because everyone has a space in the name?

EDIT: Could you also please write what I would have to put in the function to make it work?

[smubo]

function mycalculator($number1, $number2) {
  $output = $number1 + $number2;
  return $output;
  }

$sum = mycalculator(2, 3);
echo $sum;

The Variables that are used in the function have to be passed to it as in the example above, where the function adds up two numbers and returns the result.

[_DuDe_]

Grr, I have tried a few things. If I post the whole page, would someone be willing to get it to work please?