Naveed786

Yup you are right let me give it a try also. Thanks for the recommendations.

Thanks @requinix You always encourage me to learn when i was reading some articles i found the better way to achieve this is javascript. I use the java script to achieve the result onmousemove event below is the code. <script type="text/javascript"> function EnableDisable(entt) { var btnsubmit = document.getElementById("btnsubmit"); if (entt.value.trim() != "OUT") { btnsubmit.disabled = false; entt.disabled = false; } else { btnsubmit.disabled = true; entt.disabled = true;

Thanks for the guidance and help I will give it a try and will update back. Cheers.

I am beginner and on learning stage, your question is right i understand. I know the method i wrote is wrong most probably.

Thanks for the guidance here is the code: <?php if($gst="OUT"){ <input name="noopaxs" id="noopaxs" readonly = "" value="<?php echo $row['noopaxs'];?>"> else{ <input name="noopaxs" id="noopaxs" value="<?php echo $row['noopaxs'];?>"> }} ?> and the error is: Parse error: syntax error, unexpected '<' Thanks for the help.

Yes please i know how to mark the textbox readonly or disabled. <input name="entby" id="entby" rows="9" class="form-control" required="" readonly="" value="<?php echo $entby; ?>"> if i will put disable instead of readonly it will be disabled. I read in in one article if we use readonly the value will be updated in the database if we update a record but if it's disabled the value will not be updated. Cheers.

Hi requinix, Sorry for late reply, I already tried above method, i was thinking might be there is some way to only edit the select record, i am using the method to show more fields to identify the record and update it, can u please help me with below code, i want to disable the update button in case if the record date is in past. Can anyone help me with example, like <?php If($gst='OUT'){ disable textbox1 and textbox2 } >? I saw several examples but not able to understand properly, if conditions true then text boxes will

Hi Everyone, Any help will be highly appreciated. Still trying to find solution for this. Thanks in advance. Cheers.

Hi mac_gyver, Thanks for pointing it out, i did some study on this and changed the code now it's retrieving the correct count but now am getting one box for each noofpaxs count but i only want only one perticular count for the record which i need to edit, please see below code and screen shot. <?php $cnfno=$_GET['confno']; $query1=mysqli_query($con,"SELECT SUM(noopaxs) AS gattl FROM tblsupvisitor where date(EnterDate) = CURDATE() AND (gst = 'INH' AND entt = 'IN') || (confno='$cnfno') GROUP BY confno"); while ($row=mysqli_fetch_array($query1)) { ?> Please help me

Hi, Still waiting if someone can help me on this please.

It's producing the result in mysql properly no issues once i am using in php it's not bringing any reult but now i modified the query it brings the result but it's not calculating total properly for example with confno there are 3 records and each has i noopaxs it should bring 3 but it's bringing back 2 as a sum and also it's happening for each group of confno, please see below code. <?php $eid=$_GET['editid']; $query2=mysqli_query($con,"SELECT SUM(noopaxs) as gattl FROM tblsupvisitor where date(EnterDate) = CURDATE() || gst = 'INH' || entt = 'IN' || ID='$eid' GROUP BY confno");

Hi kicken, I have tried this but still the text box is blank no value it's empty. Below is code with advised changes. <?php //Calculation for no of paxs. $query2=mysqli_query($con,"SELECT SUM(noopaxs-gattl) AS gattl FROM tblsupvisitor where date(EnterDate) = CURDATE() || gst = 'INH' || gst = 'IN' GROUP BY confno"); $calc_no_paxs_for_today=mysqli_fetch_row($query2); $gattl=$calc_no_paxs_for_today['gattl']; ?>

Dear All, I am trying to fetch the sum of a column for current date and subtract a value from the sum for currently selected record. The query i build works fine in MySql but when the same query i placed in php no result it's blank. Below is the query. <?php //Calculation for no of paxs. $query2=mysqli_query($con,"SELECT SUM(noopaxs-gattl) FROM tblsupvisitor where date(EnterDate) = CURDATE() || gst = 'INH' || gst = 'IN' GROUP BY confno"); $calc_no_paxs_for_today=mysqli_fetch_row($query2); $gattl=$calc_no_paxs_for_today['gattl']; ?> and her is the assignment

Hi, Anyone can help on above query please.....

Thanks to all for help and guidance, it's working fine now the issue was with Java script @requinix thanks for the guidance it's always fantastic and great. One quick question i want to put some formatting in the file as currently it looks very simple and still first column serial number is getting hidden i can not see the number under it but when i export the data is there. Can any one help on this code is already posted above. Thanks in advance. Naveed.