update !!!

[kamsmartx]

hi 🙂

i have this code , this code is corrected code for update but the problem on this code is this part

echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>"; 

This message repeated a number of existing database fields and I want not to repeat the message but only once when a pre-existing rule amendment

 <?php 
// Check if button name "Submit" is active, do this 
if($Submit){ 
for($i=0;$i<$count;$i++){ 
$sqlCheck = mysql_query ("SELECT * FROM appointment WHERE Time='". $Time[$i] ."'");  

$num = mysql_num_rows ($sqlCheck);  

if ($num > 0)  

{  

echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>"; 
            continue;          


}  
else  
{  
$sql1="UPDATE $tbl_name SET  DocName='$DocName[$i]', Date='$Date[$i]', Time='$Time[$i]', FileNo='$FileNo[$i]', PationtName='$PationtName[$i]' WHERE ANO='$ANO[$i]'"; 
$result1=mysql_query($sql1); 
//$result1=mysql_query($sql1); 
$result1=mysql_query($sql1) or die (mysql_error());  

} 
} 
} 

if($result1){ 
print '<meta http-equiv="refresh" content="0; url=updatedata.php">'; 
} 

?>

[kamsmartx]

any one here

[kamsmartx]

🙂

[laserlight]

echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>";

should be:

echo "<script>window.alert(' the update found " . $ANO[$i] . "');</script>";

[kamsmartx]

ok

[kamsmartx]

laserlight wrote:

echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>";

should be:

echo "<script>window.alert(' the update found " . $ANO[$i] . "');</script>";

the problem stile

[leatherback]

You need to move the echo ... statement to outside the '=for($i=0;$i<$count;$i++){ =' loop.

You now echo each time a successfull select has been made. You need to set a variable at some point when you think you know enough to later decide to echo. I am not sure what your reasoning is for th alert, soI cannot advice you where/how

[kamsmartx]

ok

i will move it out loop but it occur error

<?php 
// Check if button name "Submit" is active, do this 
if($Submit){ 
for($i=0;$i<$count;$i++){ 
$sqlCheck = mysql_query ("SELECT * FROM appointment WHERE Time='". $Time[$i] ."'");   

$num = mysql_num_rows ($sqlCheck);   

if ($num > 0)   

{   

        continue;           


}   
echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>"; 
    else   

    {   

$sql1="UPDATE $tbl_name SET  DocName='$DocName[$i]', Date='$Date[$i]', Time='$Time[$i]', FileNo='$FileNo[$i]', PationtName='$PationtName[$i]' WHERE ANO='$ANO[$i]'"; 
$result1=mysql_query($sql1); 
//$result1=mysql_query($sql1); 
$result1=mysql_query($sql1) or die (mysql_error());   

} 
} 
} 

if($result1){ 
print '<meta http-equiv="refresh" content="0; url=updatedata.php">'; 
} 

?>

[kamsmartx]

what

[leatherback]

hi Kam,

1) Without wanting to be rude.. What is your knowledge of PhP like? I feel that you might be better of posting in newbies forum if your post #7 was serieous.

2) You have been told before to NOT keep bumping threads. It is really rude and inconsiderate. People here help you in their own time, and do not get paid to help you. This means that you might have to be a little patient.

I told you to move it out of the for loop. e.g.,:

$showpop = false;
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sqlCheck = mysql_query ("SELECT * FROM appointment WHERE Time='". $Time[$i] ."'");  

$num = mysql_num_rows ($sqlCheck);  

if ($num > 0)  

  {
   $showpop = true;  

    }  

    else  

    {  

$sql1="UPDATE $tbl_name SET  DocName='$DocName[$i]', Date='$Date[$i]', Time='$Time[$i]', FileNo='$FileNo[$i]', PationtName='$PationtName[$i]' WHERE ANO='$ANO[$i]'";
$result1=mysql_query($sql1);
//$result1=mysql_query($sql1);
$result1=mysql_query($sql1) or die (mysql_error());  

}
}
}

if($result1){
print '<meta http-equiv="refresh" content="0; url=updatedata.php">';
}

if($showpop)
  {
echo "<script>window.alert(' the update found<?php echo $ANO[$i]; ?>');</script>";
  }

[kamsmartx]

ya thanke u