[SOLVED] checkbox value
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
k.. so then it'd be something like:
Code: Select all
<?
session_start();
include("database.php");
global $conn;
$statusby = $_POST['statusby'];
if(isset($_POST['app']))
{
$sql = 'UPDATE leave SET ';
$sql .= 'status = ''Approved'' ';
$sql .= 'WHERE RefID IN(''' . implode(''',''', $_POST['approved']) . ''')';
mysql_query($query, $conn);
}
elseif(isset($_POST['notapp']))
{ // not approved clicked..
$sql = 'UPDATE leave SET ';
$sql .= 'status = ''Not Approved'' ';
$sql .= 'WHERE RefID IN(''' . implode(''',''', $_POST['approved']) . ''')';
mysql_query($query, $conn);}
else
{ // in case someone hits enter for the submittal...
die('YOU MUST SELECT EITHER <b>APPROVED</b> OR <b>NOT APPROVED</b>.');
}
?>one more question.. simple one I think..
It update Statusby field to $statusby in database, not the value of $statusby.
I want the value of $statusby to be update to database.
Code: Select all
<?php
$sql .= 'Status = ''Approved'' ,StatusBy = ''$statusby'' ';
?>I want the value of $statusby to be update to database.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Code: Select all
$sql .= 'Status = ''Approved'' ,StatusBy = ''' . $statusby . ''' ';