- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
Hi, I am working on a script where I want to select parent id for a new user and save his parent id along with parents parent ids in mysql table. $last_id = mysql_insert_id(); //select parent id of last inserted user $sel = mysql_query("SELECT * FROM tbl_new_agent WHERE new_agnt_id = … | |
Hi! I have a php form and I am using it to update,delete and insert data.I use a drop down to display customer names and when the customer is selected, the form should be submitted with document.frm1.submit(); so that I can get company id of that customer. Problem is, when … | |
Hi all.This is part of my code which I am using to edit the record from database.Initially the input boxes show the values from database and if any one of the value is changed, I want to reflect the change according to the changes made in the fields.The code works … | |
Hi all.I found this code on a forum to confirm that the user wants to delete the record from database and that the link has not pressed accidently.But it is not deleting the record even after pressing ok.This is may be because the id is not passed properly. Can anyone … | |
Hi again!And happy new year to all.Just got to attained an interview and was asked about some c questions.Would like to know what does these lines means?Can anyone tell me? [CODE]int main() { int k=printf("Hello"); return 0; exit(10); } [/CODE] I got answeres like [QUOTE]You're outputting "Hello" on the screen … | |
Hi all.I found this code on forum.But dont know how to alter this to show the records datewise.I want to display sales and purchase for given period of time and show the balance quantity by deducting total sales from the total purchase. Here is my code: [php] <?PHP if(isset($_POST['Submit'])) { … | |
Hi!! This is some of the code I am using to add dynamic rows when user clicks the Add Row button.I want to show the calculated amount like: line_total=qty*unit_price; sub_total=total of line_total; total=sub_total+tax-advance; [CODE]<script type="text/javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; if(rowCount<3) { var row … | |
Hi All, I am using this code to populate a drop down list from mysql database. I need to pass id and name through this code.but the problem is the value is lost when the page gets refreshed.and it works fine if i pass only name through it. my code … | |
Hi!! I have a store purchase management system which manages purchase orders, goods received notes and purchase bills. problem is, if the quantity in goods received note and purchase order dont match, similarly, if quantity in goods received note and purchase bill dont match, i have to keep track of … | |
Hi again!! This is my code to add and delete dynamic rows and auto calculate the amount field by multiplying qty and rate. [CODE]<form name="staff_reg" action="<?php echo $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']; ?>" method="post" enctype="multipart/form-data"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <table border="0" cellpadding="1" cellspacing="0" class="normal-text" align="left"> <tr align="center"> <td width="10" class="forhead" style="white-space:nowrap;"> </td> <td width="92" … | |
Hi!! I am trying to find out solution for this since long. I tried js but as I am not good with it, I just want to do this through PHP. I am adding dynamic rows when user clicks the Add Row button.I want to show the calculated amount like: … | |
Hi all! I have a form as below: [CODE]<script type="text/javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; if(rowCount<3) { var row = table.insertRow(rowCount); var colCount = table.rows[0].cells.length; for(var i=0; i<colCount; i++) { var newcell = row.insertCell(i); newcell.innerHTML = table.rows[0].cells[i].innerHTML; //alert(newcell.childNodes); switch(newcell.childNodes[0].type) { case "text": newcell.childNodes[0].value = … | |
Hi!! This is some of the code I am using to add dynamic rows when user clicks the Add Row button.I want to show the calculated amount like: line_total=qty*unit_price; sub_total=total of line_total; total=sub_total+tax-advance; [CODE]<script type="text/javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; if(rowCount<3) { var row … | |
Hi!The code I use for getting the values from dynamic javascript form fields is not working dont know why? The problem might actually be because of form tags and submit buttons, I guess.So now I have three sets of pages using same code, #1.Working in excellent condition #2.Partially working if … | |
Hi again!!I wanted to know that is it possible to backup the mysql database just by running query?I am trying to find out the code so that if a user clicks backup button, the whole database will be stored somewhere. | |
Hi again!! I am stuck into a new problem.I have a invoice form with regular fields in it and when the user press the print button, I want to print it out in desired formatting like, company name, address etc. at the top of the page, and so on. Can … | |
Hi!! I have a simple script of displaying client work history in following manner: [CODE]<?PHP $query1=mysql_query ("SELECT existing_clients_work_history.history_description, existing_clients_work_history.history_history, client_master.client_name FROM existing_clients_work_history INNER JOIN client_master ON existing_clients_work_history.client_id=client_master.client_id"); if(mysql_num_rows($query1) > 0) { echo "<table align='center' border='0' width='1000'>"; echo "<tr class='style1' align='center'> <td>Client Name</td> <td>Work Description</td> <td>Work History</td> </tr>"; while($row1=mysql_fetch_array($query1)) { if($row1!=0) … | |
Hi! I am getting message #1052 - Column 'userlevel' in where clause is ambiguous while running following query: [CODE]<?PHP $query=mysql_query("SELECT mssgs.start_date, mssgs.task, mssgs.status, mssgs.timestamp, mssgs.due_on, mssgs.id, users.fname FROM mssgs INNER JOIN users ON mssgs.uid=users.uid AND mssgs.userlevel=users.userlevel WHERE status=0 AND userlevel=1 OR userlevel=3"); if(mysql_num_rows($query) > 0) { while($row=mysql_fetch_array($query)) { if($row!=0) { … | |
Hi!I am a newbie in PHP & have got a task of making event manager in PHP that too with different user levels. The problem is I cant find the exact code I am looking for. Can anyone please guide me how to display the events from database according to … | |
Hi! I am having trouble in checking userlevel at the time of login. The pages set for admin level are not displayed if the user is not admin, but admin cant access the pages either!!:D Please solve my problem! My code is: [CODE]<?php if(!isset($_SESSION['userlevel']) || empty($_SESSION['userlevel'])) { if ($_SESSION['userlevel'] == … | |
Hi! I am trying to find a hint about Hierarchical login panel in PHP which authenticates the login user and gives rights as per his position in hierarchy like follows: [QUOTE] Administrator-> Manager -> Business Developer | Programmer -> Marketing Executive [/QUOTE] Where login rights are descending as per user … | |
Hi!, I have a contacts table in MySQL and I want output in a select menu. Problem is, some rows dont have any record in it, and it is displayed in very odd way as it outputs blank fields and some data in between. My overall code is: [CODE]<?PHP $query=mysql_query("SELECT … | |
Hi!This is my 1st thread. I wanted to ask that I have a common table for clients.If client is given quotation, hes status is 1, if given invoice, hes status is 2 and so on. If i want to display only the clients who have received the invoice, I fire … |