2. PHPRunner General questions
  3. Move to next record after edit
This topic is locked

Move to next record after edit

 		7/1/2008 7:17:02 AM
PHPRunner General questions
R
 rpain author

Hi,
I want to set the system to move to the next record when the save button is pressed in a record. I know in events you can set the page to redirect to another after edit but I can't work out the command to redirect to anything but a static link.
Help welcome...
Thanks,
Richard Pain
J
 		Jane 7/1/2008

Richard,
actual code is dependent on type of your primary key.

Post table structure here and I'll help you to write proper event code.
R
 		rpain author 7/1/2008

CREATE TABLE IF NOT EXISTS `pupils` (

`ID` int(4) NOT NULL auto_increment,

`Name` varchar(20) NOT NULL,

`Patrol` varchar(20) default NULL,

`Age` varchar(5) default NULL,

`Form_Av_Age` varchar(5) default NULL,

`Good_Marks` int(2) default NULL,

`Bad_Marks` int(2) default NULL,

`Av_Good` varchar(5) default NULL,

`Av_Bad` varchar(5) default NULL,

`Eng_Comments` varchar(2000) default NULL,

`Eng_Exam` int(3) default NULL,

`Eng_Yr_Av` varchar(5) default NULL,

`Eng_High` int(3) default NULL,

`Eng_Low` int(3) default NULL,

`Mat_Comments` varchar(2000) default NULL,

`Mat_Exam` int(3) default NULL,

`Mat_Yr_av` varchar(5) default NULL,

`Mat_High` int(3) default NULL,

`Mat_Low` int(3) default NULL,

`Sci_Comments` varchar(2000) default NULL,

`Sci_Exam` int(3) default NULL,

`Sci_yr_Av` varchar(5) default NULL,

`Sci_High` int(3) default NULL,

`Sci_Low` int(3) default NULL,

`Fre_Comments` varchar(2000) default NULL,

`Hist_Comments` varchar(2000) default NULL,

`Geog_Comments` varchar(2000) default NULL,

`RS_Comments` varchar(2000) default NULL,

`Form_Tut_Report` varchar(2000) default NULL,

`Head_Report` varchar(2000) default NULL,

`Form` varchar(2) default NULL,

PRIMARY KEY (`ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ;
Thanks for replying so quickly.
J
 		Jane 7/1/2008

Here is a sample code:

global $conn;

$mess=0;

$str1 = "select max(ID) from pupils";

$rs1 = db_query($str1,$conn);

$data1 = db_fetch_numarray($rs1);
$i=$keys["ID"]+1;

while ($i<=$data1[0])

{

$str2 = "select * from pupils where ID=".$i;

$rs2 = db_query($str2,$conn);

if ($data2 = db_fetch_array($rs2))

{

$mess = $i;

$i=$data1[0]+1;

}

$i++;

}

if ($mess)

{

header("Location: pupils_edit.php?editid1=".$mess);

exit();

}