joshblevins
Member
PHP Setting
Update on both
Execute code on After Data Stored and before calculations
Code
Update on both
Execute code on After Data Stored and before calculations
Code
Code:
<?php
$connect = mysql_connect('localhost','emscompl_paramed','Paramedic!283') or die(mysql_error());
$selectdb = mysql_select_db('emscompl_ccems_joomla',$connect);
$sql = "SELECT * FROM vehicle_check
WHERE id = {vehicle_check___id}";
$getsql = mysql_query($sql);
$fetchsql = mysql_fetch_array($getsql);
$squad = $fetchsql['squad_number'];
$narcotic = $fetchsql['narcotic_box_number'];
$narcoticseal= $fetchsql['narcotic_box_seal'];
$narcoticsealcolor= $fetchsql['narcotic_box_seal_color'];
$morphine = $fetchsql['morphine'];
$ativan = $fetchsql['ativan'];
$fentanyl=$fetchsql['fentanyl'];
$iobag = $fetchsql['io_gun_bag_number'];
$iobagseal = $fetchsql['io_gun_bag_seal'];
$update = "UPDATE units SET narcotic_box_number=$narcotic, narcotic_box_seal=$narcoticseal, narcotic_box_seal_color=$narcoticsealcolor, morphine=$morphine, ativan=$ativan, fentanyl=$fentanyl, io_gun_bag_number=$iobag. io_gun_bag_seal=$iobagseal
WHERE squad_number = $squad";
mysql_query($update);
?>