venkyb47

I have a table EmpList. I want to use loop to bring result as I expected. Example, EmpNo ReportingTo ------------------- 27 14 68 14 104 27 105 27 138 27 139 68 150 8 151 8 8 5 Suppose query input is 14, I need result like this EmpNo ------ …

RENAME DATABASE command was removed. You can create a copy of the table and after that drop old table.

I have 5 select tags in a page (user can select number max 10 only). I want to fill this select boxes with dynamic data. I wrote a function for this. This function called on a radio button clicked. Data send to a PHP page and return back result to …

We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got the performance issues when ERP and another application use the same database. We are planning to do mirroring of oracle database into …

The following code used in productlist.php // some code manipulation to generate new values $filetodownload = 'DoubleClick to run.txt'; $filehandler=fopen($filetodownload,"w"); fwrite($filehandler,$generatedValue); fclose($filehandler); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename='.$filetodownload); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate'); header('Pragma: public'); header('Content-Length: ' . filesize($filetodownload)); ob_clean(); flush(); readfile($filetodownload); header('Location:druglist.php'); After file downloaded page …

When I type URL file://///server01\PUBLIC\PEG\ in browser address bar, browser redirecting to that location and shows the documents available. But when I use same url in href browser not redirecting to the href location. <?php echo '<a href="file://///server01\PUBLIC\PEG\">click here</a>'; echo '<a href="file://///server01/PUBLIC/PEG/">click here</a>'; ?> php code is not working. When …

PHP is running inside server1. Documents(.xls,.doc) available inside server2. When I am redirecting to document path from php code (available at server1) the url becomes like this *server1<path>/server2/<documentname>* But I want to open url from php code is like this *server2/<documentname>* I dont want to include server1 path as prefix. …

Is any way to do user authentication without using mysql. One way I found is using session, but it is not recommended. Is it possible with text file? If possible how to do that and is secured? Thanks

Status field contains values Open,Awaiting,Approved,Rejected. To store a value what is the best datatype in mysql? Is it TINYINT OR VARCHAR? TINYINT occupies less memory if we store numbers instead of strings ( 1 => Open, 2 => Awaiting ...). Is it cause any performence issue when using joins? I …

If I enter same date for startdate and enddate fields(ex: startdate is 2012/12/29 and enddate is also 2012/12/29) then the following if condition executes and return false in javascript. var strtdate = document.getElementById("x_START_DATE").value; //getting task startdate var enddate = document.getElementById("x_END_DATE").value; //getting task enddate var task_StartDate = new Date(strtdate); var task_EndDate …

I was created a table with <table> tag and id is 'calendarid'. In this each td contains a textbox and an image. Some textboxes contain value and some are empty. I want to hide the image where textbox contains no value(or empty).I have used following java script code to do …

I am using Decimal data type to store time like 1.30(1 hour 30 min),0.40(40 minutes) in MySQL. I want to calculate total time. When I use SUM function it was giving result in unexpected way. example: 1.30 + 0.30 = 1.60 -> SUM function gives like this. But I want …

I am unable to send a string from php page to java script page. I am storing a string in a php variable and I want to send this value to java script page on image icon click. Here is the source code: timetrack.php $activityid = $getResult->fields('ACTIVITY_ID'); // Now consider …

Hi I am unable to retrieve values from json object.The json data as coming like this when observe from firebug : [{"PROJECT_ID":"CASEENO"},{"PROJECT_ID":"DARKROOM-2"}] This is my ajax code: $.ajax({ type: "POST", url: "getdata.php", dataType: "json", data: { 'dataString': projectid }, cache:false, success: function(data){ alert(data); for (var i = 0; i < …