sagisgirl

Hi, I am developing a system that need to monitor machines' licence, so i have a field 'movedate' and 'outdate' every machines can only been kept for 2 years for most. and if the machine didn't go out for almost 2 years, an alert will come out to remind the …

Hi all, I've a problem with my insert sql..I didn'y know why. here is my insert sql $goodsDesc = $_POST['goodsDesc']; $k8goodsQty = $_POST['k8goodsQty']; $valuePerUnit = $_POST['valuePerUnit']; $sql_k8goodsIn = "INSERT INTO k8_goodsin (k8regID,goodsDesc,k8goodsQty,valuePerUnit) VALUES ( '".$k8regID."', '".addslashes(strtoupper($goodsDesc[$y]))."', '".$k8goodsQty[$y]."', '".$valuePerUnit[$y]."')"; for goodsDesc the input is like this goodsDesc = 2-1/2" suction pump …

Hi, i would like to ask something, i have a table like this :  The user will enter a value in the column "out Quantity", then, i want it auto calculate in "Total Price" which is Total Price = Old balance quantity * out quantity and new Balance …

Hi everyone..I have a problem.. I want to make an auto calculation on each row..the things is, I only can do it on the first row..but for the second row, nothing happened.. here is my code: <script> function compute() { var inputObj = document.getElementById('k8goodsQty'); var otherObj = document.getElementById('valuePerUnit'); var diffObj …

Hi guys, I have a table called "goodsbalance" qtyBalanceID | k8goodsID | goodsIn | goodsOut | qtyBalance ---------------------------------------------------------------------------- Can I do some calculation like this? $query_recgoodsbalance = "SELECT * FROM goodsbalance"; $rs_recgoodsbalance = mysql_query($query_recgoodsbalance); $rec_goodsbalance = mysql_num_rows($rs_recgoodsbalance); while (($reck9goodsout = mysql_fetch_array($rs_recgoodsbalance) )!= false) { $query_UgoodsOut = $rec_goodsbalance['goodsOut'] - $_POST['k9goodsQty']; $rs_UgoodsOut …

Hi, I'm confused right now about mysql statement I have four tables : form1 | form2 | form3 | form4 | ----------------------------------------------------- k8regNo | form2_ID| k9regNo | form4_ID | consignee | goods | out_date| k9regNo | moveDt | k8regNo | | form2_ID | can i join this four tables..?

hi everyone, i've got quite similar with displaying user's information. i've 2 form(K8 Form and K9 Form). To displaying user's information in K8 Form, i used the method with the way you guys taught me. and then after the user fill up the K8 Form, the K8 Form information will …

hi guys.. i need your help.. i want to display the user's login information. like, storage location..but im not sure how to do it.. this is how i try to do it.. $tenantID = $_GET['tid']; " " " $query_recTenantuser = "SELECT * FROM md_storage WHERE tenantID='".$tenantID."'"; $rs_recTenantuser = mysql_query($query_recTenantuser) or …

Hi all.. im now building a web-system using php..and i have 4 groups of users 1- G1 2- G2 3- G3 4- G4 in my db, those are in my table called "u_userGroup" and for my entity is "groupCode". so, these 4 groups have different privileges to each page.. G1 …

Hi guys... I have a trouble with my delete page.. here are my codes.. <?php include("enter.php"); $dbjpu_jenis_jentera=$_GET['jpu_jenis_jentera']; //if(isset($_GET['bil'])){ $dbstaf_bil = $_GET['bil']; } $sql="DELETE FROM jpuma_jkkp2013 WHERE jpu_jenis_jentera='".$dbjpu_jenis_jentera."'"; $result=@mysql_query($sql); if($result){ echo "<center>Please wait a few second.<br>The data was deleted from database...<meta http-equiv='refresh' content='3;url=jpuma_jkkp2013.php'>"; //echo "<p>"; //echo ""; } else { echo …

hey guys..i wold like to ask something about my checkLogin.php i already created a form using index.php, then i want to validate the form using checkLogin.php. but after i fill up my form, nothing was display.. here aremy codes <? session_start(); include("inc/dbconn.inc"); if(isset($_REQUEST['btn_login'])) { $conn = mysql_connect($hostname, $username, $password); mysql_select_db($dbname, …

i wanna add date in my form.. so i do with my code like this $sql_updTenant = "UPDATE md_tenant SET modifieddt = '".date('Y-m-d H:i:s')."'"; and in my php.ini, i already change this: ; Defines the default timezone used by the date functions ;date.timezone = to this: ; Defines the default …

hi...im a newbi in php..so i really in need of help.. i got an error like this : Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT …