UPDATE in un while, dopo eseguita una query SELECT.

Allora ragazzi, ho un bel problema.

Sto continunando a modificarmi il sito e ho bisogno di fare alcune cosette.

In poche parole, nella pagina princiaple di una MOD eseguo una query per prendere i dati, poi con un while li mostro e controllo un record, per vedere come è.

Ora, ho una condizione. Nel caso questa condizione restituisca true, deve farmi un UPDATE alla tabella. Però, eseguendo quella query, dovrei perdere i dati presi con la prima query giusto?

In poche parole vi chiedo, come posso fare per mostrare la pagina aggiornata, nel caso questa condizione sia true?

Grazie in anticipo. Se serve qualche riga di codice la posterò

[alemoppo]

Ora, ho una condizione. Nel caso questa condizione restituisca true, deve farmi un UPDATE alla tabella. Però, eseguendo quella query, dovrei perdere i dati presi con la prima query giusto?

Perché ??

se ho capito dovrebbe essere una cosa del genere:

$risultato1 = mysql_query("SELECT...");

while($array = mysql_fetch_array($risultato1))   //O qualsiasi altra funzione...
{
     [..]
     if(...)
     {
          $risultato2 = mysql_query("UPDATE ..."); //$risultato1 rimane invariato, no?
     }
} 

...Sicurissimamente ho capito male

Ciao!

E' quello che faccio pure io, solo non lo fa per ogni risultato! Uso questo codice:

$sql = 'SELECT * FROM ' . CHALLENGE_TABLE . ' ORDER BY id DESC LIMIT ' . $start . ',' . $max_number_challenge_listing;
    if (!($result = $db->sql_query($sql)))
    {
        message_die(GENERAL_ERROR, 'Could not read challenge information.', '', __LINE__, __FILE__, $sql);
    }

    while($row = $db->sql_fetchrow($result))
    {
        $id_challenge = $row['id'];

        $challenge_control_state = control_state($row['state']);
        $challenge_state = $challenge_control_state['state'];
        $image_status = $challenge_control_state['image_status'];
        $message = $challenge_control_state['message'];
        
        $today_date = create_date('d', time(), $board_config['board_timezone']);
        
        $challenge_days_accept = $row['days_accept'];
        $challenge_days_vote = $row['days_vote'];
        $challenge_days_send_image = $row['days_send_image'];
        $today_date = create_date('Y/m/j', time(), $board_config['board_timezone']);
        $challenge_date_day_launch = create_date('Y/m/j', $row['date_launch'], $board_config['board_timezone']);

        $challenge_date_plus_days_accept = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_accept), $row['date_launch'], $board_config['board_timezone']);
        $challenge_date_plus_days_vote = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_vote), $row['date_launch'], $board_config['board_timezone']);
        $challenge_date_plus_days_send_image = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_send_image), $row['date_launch'], $board_config['board_timezone']);

        
        
        if($state_challenge  == $CHALLENGE_STATE_WAIT)
        {
            if((today_date > $challenge_date_plus_days_accept) || (today_date > challenge_date_plus_days_send_image))
            {
                $sql = 'UPDATE ' . CHALLENGE_TABLE . ' SET state = ' . $CHALLENGE_STATE_ANNULLED . ' WHERE id = ' . $id_challenge;
                if (!($result = $db->sql_query($sql)))
                {
                    message_die(GENERAL_ERROR, 'Could not update state challenge.', '', __LINE__, __FILE__, $sql);
                }
            }
        }
        elseif($state_challenge  == $CHALLENGE_STATE_OPEN)
        {
            if($today_date > $challenge_date_plus_days_vote)
            {
                $sql = 'UPDATE ' . CHALLENGE_TABLE . ' SET state = ' . $CHALLENGE_STATE_LOCKED . ' WHERE id = ' . $id_challenge;
                if (!($result = $db->sql_query($sql)))
                {
                    message_die(GENERAL_ERROR, 'Could not update state challenge.', '', __LINE__, __FILE__, $sql);
                }
            }
        }
        elseif($challenge_state == $CHALLENGE_STATE_WAIT_IMAGES)
        {
            if($today_date > $challenge_date_plus_days_send_image)
            {
                $sql = 'UPDATE ' . CHALLENGE_TABLE . ' SET state = ' . $CHALLENGE_STATE_ANNULLED . ' WHERE id = ' . $id_challenge;
                if (!($result = $db->sql_query($sql)))
                {
                    message_die(GENERAL_ERROR, 'Could not update state challenge.', '', __LINE__, __FILE__, $sql);
                }
            }
        }        
    }
    
    $sql = 'SELECT * FROM ' . CHALLENGE_TABLE . ' ORDER BY id DESC LIMIT ' . $start . ',' . $max_number_challenge_listing;
    if (!($result = $db->sql_query($sql)))
    {
        message_die(GENERAL_ERROR, 'Could not read id challenge.', '', __LINE__, __FILE__, $sql);
    }

    while($row = $db->sql_fetchrow($result))
    {
        $template->set_filenames(array('body' => 'challenge_view_all_body.tpl'));

        $id_challenge = $row['id'];

        $challenge_control_state = control_state($row['state']);
        $challenge_state = $challenge_control_state['state'];
        $image_status = $challenge_control_state['image_status'];
        $message = $challenge_control_state['message'];

        $challenge_date_launch = create_date($board_config['default_dateformat'], $row['date_launch'], $board_config['board_timezone']);
        $challenge_days_accept = $row['days_accept'];
        $challenge_days_vote = $row['days_vote'];
        $challenge_days_send_image = $row['days_send_image'];
    
        $challenger_vote = $row['vote_challenger'];
        $challenging_vote = $row['vote_challenging'];
        $challenge_users_voted = $challenger_vote + $challenging_vote;

        $challenge_user_percent_challenger = ($challenge_users_voted != 0) ? round((($challenger_vote * 100) / $challenge_users_voted)) : 50;
        $challenge_user_percent_challenging = ($challenge_users_voted != 0) ? round((($challenging_vote * 100) / $challenge_users_voted)) : 50;

        if($challenger_vote > $challenging_vote)
        {
            $color_vote_graphic_img_left_challenge = 'green';
            $color_vote_graphic_img_left_challenging = 'red';
        }
        if($challenging_vote > $challenger_vote)
        {
            $color_vote_graphic_img_left_challenge = 'red';
            $color_vote_graphic_img_left_challenging = 'green';
        }
        if($challenger_vote == $challenging_vote)
        {
            $color_vote_graphic_img_left_challenge = 'blue';
            $color_vote_graphic_img_left_challenging = $color_vote_graphic_img_left_challenge;
        }
        
        $vote_graphic_img_left_challenge = $images['voting_graphic_' . $color_vote_graphic_img_left_challenge . '_left'];
        $vote_graphic_img_body_challenge = $images['voting_graphic_' . $color_vote_graphic_img_left_challenge . '_body'];
        $vote_graphic_img_right_challenging = $images['voting_graphic_' . $color_vote_graphic_img_left_challenging . '_right'];
        $vote_graphic_img_body_challenging = $images['voting_graphic_' . $color_vote_graphic_img_left_challenging . '_body'];
        
        $user_challenger_id = $row['id_challenger'];
        $user_challenging_id = $row['id_challenging'];
        
        $user_challenger_data = get_userdata($user_challenger_id);
        $user_challenger_data_link_username = colorize_username($user_challenger_data['user_id'], $user_challenger_data['username'], $user_challenger_data['user_color'], $user_challenger_data['user_active']);
        $user_challenger_data_username = $user_challenger_data['username'];
        $user_challenger_data_avatar = user_get_avatar($user_challenger_data['user_id'], $user_challenger_data['user_level'], $user_challenger_data['user_avatar'], $user_challenger_data['user_avatar_type'], $user_challenger_data['user_allowavatar']);
        
        $user_challenging_data = get_userdata($user_challenging_id);
        $user_challenging_data_link_username = colorize_username($user_challenging_data['user_id'], $user_challenging_data['username'], $user_challenging_data['user_color'], $user_challenging_data['user_active']);
        $user_challenging_data_username = $user_challenging_data['username'];
        $user_challenging_data_avatar = user_get_avatar($user_challenging_data['user_id'], $user_challenging_data['user_level'], $user_challenging_data['user_avatar'], $user_challenging_data['user_avatar_type'], $user_challenging_data['user_allowavatar']);
        
        $server_url = create_server_url();

        if ($board_config['url_rw'] == 1)
        {
            $server_url . 'challenge-' . make_url_friendly($user_challenger_data_username . '-vs-' . $user_challenging_data_username) . '-id-' . $id_challenge . '.html';
        }
        else
        {
            $url_challenge_details = U_CHALLENGE . '?' . $PARAMETER_ID . '=' . $id_challenge;
        }

        $challenge_type = control_type($row['type_challenge']);
    
        $challenge_control_state = control_state($row['state']);
        $challenge_state = $challenge_control_state['state'];
        $image_status = $challenge_control_state['image_status'];
        $message = $challenge_control_state['message'];

        $template->assign_block_vars('challenge', array(
            'MODE_VIEW' => MODE_VIEW_CHALLENGE,

            'ID_CHALLENGE' => $id_challenge,
            
            'CHALLENGE_STATE' => $challenge_state,
            'CHALLENGE_TYPE' => $challenge_type,
            
            'DATE_LAUNCH' =>  $challenge_date_launch,
            
            'USER_VOTED' => $challenge_users_voted,
            'USER_VOTED_CHALLENGER' => $challenge_user_percent_challenger,
            'USER_VOTED_CHALLENGING' => $challenge_user_percent_challenging,
            
            'DAYS_VOTE' => $challenge_days_vote,
            'DAYS_ACCEPT' => $challenge_days_accept,
            'DAYS_SEND_IMAGE' => $challenge_days_send_image,
            
            'LINK_USERNAME_CHALLENGER' => $user_challenger_data_link_username,
            'USERNAME_CHALLENGER' => $user_challenger_data_username,
            'AVATAR_CHALLENGER' => $user_challenger_data_avatar,
            
            'LINK_USERNAME_CHALLENGING' => $user_challenging_data_link_username,
            'USERNAME_CHALLENGING' => $user_challenging_data_username,
            'AVATAR_CHALLENGING' => $user_challenging_data_avatar,

            'IMG_STATE' => $image_status,
            'IMG_CHALLENGER_VOTE' => $challenger_user_image_vote,
            'IMG_CHALLENGING_VOTE' => $challenging_user_image_vote,
            
            'IMG_VOTE_L' => $vote_graphic_img_left_challenge,
            'IMG_VOTE_R' => $vote_graphic_img_right_challenging,
            'IMG_VOTE_BODY_CHALLENGE' => $vote_graphic_img_body_challenge,
            'IMG_VOTE_BODY_CHALLENGING' => $vote_graphic_img_body_challenging,

            'U_DETAILS' => $url_challenge_details,
        ));
    } 

Però sembra non andare

[alemoppo]

if (!($result = $db->sql_query($sql)))
[....]
if (!($result = $db->sql_query($sql)))
[....]
if (!($result = $db->sql_query($sql)))

[....]
(!($result = $db->sql_query($sql)))
[....]
if (!($result = $db->sql_query($sql)))

Ma si chiamano tutte result!!! E' normale che so sovrescrivano!!!

Guarda il mio esempio che ti avevo fatto!

Ciao!

Allora, ho fatto un truncate per svuotare la tabelle e riniziare da capo.

Ho fatto una prova, con un record, e ho visto che con la condizione:

if($state_challenge == $CHALLENGE_STATE_WAIT)
        {
            if((today_date > $challenge_date_plus_days_accept) || (today_date > challenge_date_plus_days_send_image))
            {
                $sql_update = 'UPDATE ' . CHALLENGE_TABLE . ' SET state = ' . $CHALLENGE_STATE_ANNULLED . ' WHERE id = ' . $id_challenge;
                if (!($result = $db->sql_query($sql_update)))
                {
                    message_die(GENERAL_ERROR, 'Could not update state challenge.', '', __LINE__, __FILE__, $sql);
                }
            }
        } 

Mi esegue l'update, anche se non dovrebbe. Queste sono le variabili che uso per il controllo:

$challenge_days_accept = $row['days_accept'];
$challenge_days_vote = $row['days_vote'];
$challenge_days_send_image = $row['days_send_image'];
$today_date = create_date('Y/m/j', time(), $board_config['board_timezone']);
$challenge_date_day_launch = create_date('Y/m/j', $row['date_launch'], $board_config['board_timezone']);

$challenge_date_plus_days_accept = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_accept), $row['date_launch'], $board_config['board_timezone']);
$challenge_date_plus_days_vote = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_vote), $row['date_launch'], $board_config['board_timezone']);
$challenge_date_plus_days_send_image = create_date('Y/m/' . (create_date('j', $row['date_launch'], $board_config['board_timezone']) + $challenge_days_send_image), $row['date_launch'], $board_config['board_timezone']); 

Praticamente creo la data del giorno in cui si visita la pagina ($today_date), poi creo la data nello stesso formato di quando è stata inviata la sfida ($challenge_date_day_launch), dopo di che creo la data, sommando i giorni che sono stati scelti per ogni opzione, in una variabile dove sommo questi alla data di oggi, quindi i giorni per accettare ($challenge_date_plus_days_accept) quelli per votare ($challenge_date_plus_days_vote) e quelli per inviare un file ($challenge_date_plus_days_send_image).

Stampando i risultati sono giusti, viene fatta la somma, ma non viene rispettata la condizione e da sempre true