terrydschmidt
asked on
ASAP is MySQL UPDATE need correct syntax
Can someone help me quickly on the syntax of the mysql_query UPDATE and anything else I might of forgot. I'm closing the the database in the right spot, right??
<?php
session_start();
//Connect to Database
require 'db_connect.php';
echo "YOU ARE HERE!"."<br/>";
if (isset($_REQUEST['chkCheck _']) && is_array($_REQUEST['chkChe ck_'])) {
for($i=0;$i < sizeof($_REQUEST['chkCheck _']); $i++){
$id = $_REQUEST['chkCheck_'][$i] ;
echo $_REQUEST['chkCheck_'][$i] ;
mysql_query("UPDATE discussion SET visible='Y' where id="$id" ");
}
mysql_close();
}
?>
<?php
session_start();
//Connect to Database
require 'db_connect.php';
echo "YOU ARE HERE!"."<br/>";
if (isset($_REQUEST['chkCheck
for($i=0;$i < sizeof($_REQUEST['chkCheck
$id = $_REQUEST['chkCheck_'][$i]
echo $_REQUEST['chkCheck_'][$i]
mysql_query("UPDATE discussion SET visible='Y' where id="$id" ");
}
mysql_close();
}
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER