Try removing the parenthesis from your update sql query........
$sql = "UPDATE vacancies SET AuthStatus='1' WHERE JobID = '$JobID'";
HTH
Paul
----- Original Message -----
From: "Matt C" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 12:43 AM
Subject: [PHP-DB] Check Boxes!
: 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: [EMAIL PROTECTED]
: For additional commands, e-mail: [EMAIL PROTECTED]
: To contact the list administrators, e-mail: [EMAIL PROTECTED]
:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
