[PHP-DB] Check Boxes! From: Matt C (matthewcothier <email protected>)
Date: 10/19/01

I still can't get my damn code working :( :( :(

All I want to do is have any records with a checked check box given the
value of 1 in the AuthStatus row.

Can anyone help me please?

-----

<?php

if ($submit) {

//Get the DB result
$dbResult = mysql_query("SELECT * FROM vacancies WHERE (AuthStatus = '0')
ORDER BY JobID DESC LIMIT 1");

$oRow = mysql_fetch_object($dbResult);

$Max_JobID = $oRow->JobID;

  for ($i = 0; $i <= $Max_JobID; $i++) {
    if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on') {
        $JobID = $i;
        }

if($JobID){

$sql = "UPDATE vacancies SET AuthStatus='1' WHERE (JobID = '$JobID')";
mysql_query($sql,$dbconnect);

}

  }
}

?>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>