Sometimes, PHP becaomes confused when a variable is included in another
word, such as you are doing with $i in:
if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on')
To avoid this problem, use braces to segregate the PHP variable from the
rest of the word:
try: if($HTTP_POST_VARS["chkAuthStatus_${i}"] = 'on')
or: if($HTTP_POST_VARS["chkAuthStatus_{$i}"] = 'on')
-----Original Message-----
From: Matt C [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 6:43 PM
To: [EMAIL PROTECTED]
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]
