Passando valor

[gica 0]

Oi Pessoal,Estou com uma duvida...tenho esses dois codigos ...o segundo chama o primeiro...porem eu quero mudar somente o valor do status do anuncio selecionado...nao consegui passar o valor do ad_id para a segunda pagina... Entao quando peco para alterar, muda tudo...alguem pode me ajudar?<code><?php require( "common.php" ); if( !verifyAdmin() ) header( "Location: ./admin.php" ); dbConnect(); if ($action == "publi") { mysql_query( "UPDATE ads SET status=1 " ) or error( mysql_error() ); }?></code><code><? require( "common.php" ); dbConnect(); if( !verifyAdmin() ) header( "Location: ./publicar_action.php" ); $result = mysql_query( "SELECT * FROM ads WHERE status=0 " ) or error( mysql_error() ); $totalAds = mysql_num_rows( $result ); echo $totalAds; $time = time(); $maxAds = 10; $ad_id = trim( $ad_id ); if( $totalAds <= $maxAds ) $totalPages = 1; elseif( $totalAds % $maxAds == 0 ) $totalPages = $totalAds / $maxAds; else $totalPages = ceil( $totalAds / $maxAds ); if( !isset( $page ) ) $page = 1; elseif( $page > $totalPages ) $page = 1; if( $totalAds == 0 ) $adsStart = 0; else $adsStart = $maxAds * $page - $maxAds + 1; if( $page == $totalPages ) $adsEnd = $totalAds; else $adsEnd = $maxAds * $page; $prePage = $page - 1; $nextPage = $page + 1; $initAds = $maxAds * $page - $maxAds; echo "$ad_id"; if( $totalAds > 0 ) { echo " <table border=\"0\" cellpaddig=\"0\" cellspacing=\"0\">\n"; echo " <form method=\"post\" action=\"publicar_action.php?action=publi\">\n"; echo " <tr class=\"frame\">\n"; echo " <td width=\"30\" height=\"25\" align=\"right\"><font color=\"#000000\"><b>#</b></font></td>\n"; echo " <td width=\"240\" height=\"25\" align=\"left\"><font color=\"#000000\"><b><small>Título</b></font></td>\n"; echo " <td width=\"100\" height=\"25\" align=\"left\"><font color=\"#000000\"><b><small>Código do produto</b></font></td>\n"; echo " <td width=\"180\" height=\"25\" align=\"center\"><font color=\"#000000\"><b><small>Valido até:</b></font></td>\n"; echo " <td width=\"75\" height=\"25\" align=\"center\"><font color=\"#000000\"><b><small>Foto</b></font></td>\n"; echo " <td width=\"75\" height=\"25\" align=\"center\"><font color=\"#000000\"><b><small>Detalhes</b></font></td>\n"; echo " <td width=\"75\" height=\"25\" align=\"center\"><font color=\"#000000\"><b><small>Status</b></font></td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td width=\"300\" height=\"1\" colspan=\"5\" bgcolor=\"#FFFFFF\"></td>\n"; echo " </tr>\n"; $i = $adsStart; while( $row = mysql_fetch_array( $result ) ) { echo " <tr class=\"detail\">\n"; echo " <td width=\"30\" height=\"25\" ><small><input type=\"checkbox\" name=\"status\" value=\"{$row['status']}\">{$i}.</td>\n"; echo " <td width=\"240\" height=\"25\"><small>" . substr( $row['subject'], 0, 50 ); if( strlen( $row['subject'] ) > 50 ) echo "... ..."; echo "</td>\n"; echo " <td width=\"100\" height=\"25\"><small> {$row['ad_id']}"; echo "</td>\n"; echo " <td width=\"180\" height=\"25\" align=\"center\"><small>" . date( "m/d/y h:i", $row['add_date'] ) . "</small></td>\n"; echo " <td height=\"25\" align=\"center\">"; $photo = mysql_query( "SELECT photo_id FROM photo WHERE ad_id={$row['ad_id']}" ) or error( mysql_error() ); if( mysql_num_rows( $photo ) >= 1 ) echo "<small>disponível"; else echo "<small>não disponível"; echo "</td>\n"; echo " <td height=\"25\" align=\"center\"><a href=\"detail.php?cat=$cat&de={$row['ad_id']}\"><small>detalhes</a></td>\n"; echo " <td align=center colspan=\"4\"><small>{$row['status']}"; echo "</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td></td>\n"; echo " <td colspan=\"4\"><small>" . substr( $row['descript'], 0, 300 ); if( strlen( $row['descript'] ) > 300 ) echo "... ..."; echo "</td>\n"; echo " </tr>\n"; echo " <td></td>\n"; echo " <tr>\n"; echo " <td colspan=\"5\" align=\"right\"></td>\n"; echo " </tr>\n"; $i++; } } echo " <table>\n"; echo " <tr>\n"; echo " <td width=\"100\" height=\"20\" colspan=\"5\"><input type=\"submit\" value=\" Publicar anúncios selecionados \"></td>\n"; echo " </tr>\n"; echo " </form>\n"; echo " </table>\n"; $i = $adsStart; echo "<p><a href=\"admin.php?action=logout\"><b>Logout</b></a> | <a href=\"admin_menu.php\"><b>Voltar</b></a></p>\n";?></code>

[MrEd 0]

Se você nao colocar uma condição no Update, ele vai atualizar todos os dados da tabela mesmo. Coloca um where q vai funcionar.