Following is my sql query to get data from mysql database. So how do i save it as .csv file ?   &lt;?php $sqlagentdetails = "select * from users WHERE company_name != ''"; $rowresult = mysql_query($sqlagentdetails);  while($row = mysql_fetch_array($rowresult, MYSQL_ASSOC)){     $pc1 = $row['pc1'];     $pc2 = $row['pc2'];     $pc3 = $row['pc3'];     $pc4 = $row['pc4'];                           $emailAgent = $row['user_email'];                           $user_id = $row['id'];  $myQuery =  mysql_query("  SELECT *     FROM user_property upr    WHERE (postcode = '$pc1' OR          postcode = '$pc2' OR          postcode = '$pc3' OR          postcode = '$pc4') AND          datediff(CURDATE(), upr.creation_date) &lt;= 7 AND          NOT EXISTS(SELECT ofr.property_id                        FROM offers ofr                       WHERE ofr.property_id = upr.property_id AND                            ofr.agent_id IN(SELECT id                                               FROM users                                              WHERE company_name !=''                                           )                    ) ORDER BY property_id DESC"); $num =  mysql_num_rows($myQuery); while($row = mysql_fetch_array($myQuery)){        /// data is showing here............      }// second while statement  }// first while statement ?&gt;   It's showing following data column  Email | Pcode | Quote | type | House | type | B | Ba | P | Value | Date |  Listed | Status
What is the most efficient way to convert a MySQL query to CSV in PHP please?  It would be best to avoid temp files as this reduces portability (dir paths and setting file-system permissions required).  The CSV should also include one top line of field names.
Why should I use the keyword "final" on a method parameter in Java? Bash script to remove the oldest file from from a folder I want to make a bash script to delete the older file form a folder. Every time when I run the script will be deleted only one file, the older one. Can you help me with this? Thanks I have a script that reads a text stream and generates a file of sed commands that is later run with sed -f. The generated sed commands are like:  s/cid:image002\.gif@01CC3D46\.926E77E0/https:\/\/mysite.com\/files\/1922/g s/cid:image003\.gif@01CC3D46\.926E77E0/https:\/\/mysite.com\/files\/1923/g s/cid:image004\.jpg@01CC3D46\.926E77E0/https:\/\/mysite.com\/files\/1924/g   Assume the script which generates the sed commands is something like:  while read cid fileid do     cidpat="$(echo $cid | sed -e s/\\./\\\\./g)"     echo 's/'"$cidpat"'/https:\/\/mysite.com\/files\/'"$fileid"'/g' &gt;&gt; sedscr done   How can I improve the script to ensure all regex metacharacters in the cid string are escaped and interpolated properly? How can I change the field names (not the alias) in ArcGIS 10.2? I already found this page on ArcGIS support: &quot;&quot; but there is is not &quot;Defense Mapping&quot; on Customized Mode Categories In my ArcCatalog! Without access to Defense Mapping, how can I change the field names? Using expect for inputting commands Heres the thread I'm bouncing off of:   So I'm trying to run this command: cd /etc/openvpn/easy-rsa; . ./vars; ./build-key username  However, after running that command, I need to input nothing [just press enter] 10 times, and press y twice. The user on the last thread suggested I use except, but I couldn't get it working. Here are the questions it asks:  root@suffice-vpn:/etc/openvpn/easy-rsa# ./build-key usernamtest Generating a 2048 bit RSA private key ..................+++ ........+++ writing new private key to 'usernamtest.key' ----- You are about to be asked to enter information that will be incorporated into your certificate request. What you are about to enter is what is called a Distinguished Name or a DN. There are quite a few fields but you can leave some blank For some fields there will be a default value, If you enter '.', the field will be left blank. ----- Country Name (2 letter code) [US]: State or Province Name (full name) [NY]: Locality Name (eg, city) [Merrick]: Organization Name (eg, company) [IceWare]: Organizational Unit Name (eg, section) [IceWare]: Common Name (eg, your name or your server's hostname) [usernamtest]: Name [server]: Email Address [iceware@programmer.net]:  Please enter the following 'extra' attributes to be sent with your certificate request A challenge password []: An optional company name []: Using configuration from /etc/openvpn/easy-rsa/openssl-1.0.0.cnf Check that the request matches the signature Signature ok The Subject's Distinguished Name is as follows countryName           :PRINTABLE:'US' stateOrProvinceName   :PRINTABLE:'NY' localityName          :PRINTABLE:'Merrick' organizationName      :PRINTABLE:'IceWare' organizationalUnitName:PRINTABLE:'IceWare' commonName            :PRINTABLE:'usernamtest' name                  :PRINTABLE:'server' emailAddress          :IA5STRING:'iceware@programmer.net' Certificate is to be certified until Jan 14 18:27:48 2026 GMT (3650 days) Sign the certificate? [y/n]:y   1 out of 1 certificate requests certified, commit? [y/n]y   As you can see, I press enter 8 times initially [to keep the default input] and then press enter another 2 times to skip the optional commands. Then, I need to press y twice. How can I automate this? I need to have this all happen in one command. Any suggestions? Thanks in advance. My iPhone 5 won't boot anymore and when I plug it in my MacBook, it goes to recovery mode (cable logo => iTunes logo).  So I tried to restore it using iTunes but I keep getting this error    Any idea how to fix it?  While it was plugged in I tried holding power + home, it reboots the device and goes back to recovery mode and then any restore attempt results in a 2001 error as well. When it's not plugged in nothing will make it boot. This is sort of a follow-up to a feature request that resulted in obscuring spam / offensive content from 10K-visible answers:   Suggest the same to be done for questions. As of now, spam questions (, ) preserve their titles and content. Suggest to revise the titles to something like     This question was marked as spam or offensive and is therefore not shown   And the text to something like:     This question was marked as spam or offensive and is therefore not shown - you can see the revision history for details".   Where "the revision history" links to the question revision history.    For those interested, here is a link to screen shots of how spam shines through my flagging summary page and is displayed to me when I click the link to one of deleted questions: .  For the sake of precision, flagger having less than 10K rep would see only upper screen shot - the one that lists question titles ("Call giRℒs blah blah &lt;phone number&gt;") - in their  page. Evaluating the nested radical $ \sqrt{1 + 2 \sqrt{1 + 3 \sqrt{1 + \cdots}}} $. How does one prove the following limit? $$   \lim_{n \to \infty}   \sqrt{1 + 2 \sqrt{1 + 3 \sqrt{1 + \cdots \sqrt{1 + (n - 1) \sqrt{1 + n}}}}} = 3. $$ I have several AppExchange apps installed that are failing tests. What is the recommended approach to resolving this? Are tests run when a new package is installed? Is there a way to determine what is actually failing besides the name of the method and something like "expected true, actually false"? The test results rarely show enough information to be useful.   What I'm doing atm, is checking for updates for the packages, and then writing the company with the failing test results.   Any feedback would be appreciated. What it's the best way to generate a string of \t's in C#  I am learning C# and experimenting with different ways of saying the same thing.    Tabs(uint t) is a function that returns a string with t amount of \t's  For example Tabs(3) returns "\t\t\t"  Which of these three ways of implementing Tabs(uint numTabs) is best?  Of course that depends on what "best" means.     The LINQ version is only two lines, which is nice.  But are the calls to Repeat and Aggregate unnecessarily time/resource consuming? The StringBuilder version is very clear but is the StringBuilder class somehow slower? The string version is basic, which means it is easy to understand.   Does it not matter at all?  Are they all equal?   These are all questions to help me get a better feel for C#.     private string Tabs(uint numTabs) {     IEnumerable&lt;string&gt; tabs = Enumerable.Repeat("\t", (int) numTabs);     return (numTabs &gt; 0) ? tabs.Aggregate((sum, next) =&gt; sum + next) : "";  }    private string Tabs(uint numTabs) {     StringBuilder sb = new StringBuilder();     for (uint i = 0; i &lt; numTabs; i++)         sb.Append("\t");      return sb.ToString(); }    private string Tabs(uint numTabs) {     string output = "";     for (uint i = 0; i &lt; numTabs; i++)     {         output += '\t';     }     return output;  } Why does GPS depend on relativity? What happens if you use a Clone Effect on a Double Faced Card that's Transformed? Say someone has , which is a 0/3 Defender, and after some mechanics, transforms into a 13/13 Lizard Horror with Trample.  Say this someone managed to transform said card into its 13/13 Trample form, and then cast  on it (or any other clone type card if it would matter between different ones). Does the Metamorph/Clone/etc. come into play transformed, or as the 0/3 Defender? "To delete" is to "deletion" as "to discard" is to what? "To delete" is to "deletion" as "to discard" is to what? Delete specific line number(s) from a text file using sed? I want to delete one or more specific line numbers from a file. How would I do this using sed? How to show that there is an element of order $51$ in the multiplicative group $(Z/103Z)^∗.$  I can't use Cauchy's theorem since $51$ is not prime. How do Stack Overflow questions appear in Google search results in seconds? Show that the sequence $a_0 = 1$, $a_{n+1 }= \sqrt{2+a_n}$ is monotonically increasing Given the sequence $a_0 = 1$, $a_{n+1}= \sqrt{2+a_n}$, how can I show that it is monotonically increasing?  I need it to show, that the sequence converges. I already proved boundedness but I can't figure out this last part. $$\int^2_{-2}\frac{x^2}{1+5^x}$$  How do I start to integrate this?  I know the basics and tried substituting $5^x$ by $u$ where by changing the base of logarithm I get $\frac{\ln(u)}{\ln 5}=x$, but I got stuck.  Any hints would suffice preferably in the original question and not after my substitution.  (And also using the basic definite integrals property.)  Now I know only basic integration, that is restricted to high school, so would prefer answer in terms of that level. Unix epoch time to Java Date object I have a string containing the , and I need to convert it to a Java Date object.  String date = "1081157732"; DateFormat df = new SimpleDateFormat(""); // This line try {   Date expiry = df.parse(date);  } catch (ParseException ex) {   ex.getStackTrace(); }   The marked line is where I'm having trouble. I can't work out what the argument to SimpleDateFormat() should be, or even if I should be using SimpleDateFormat(). "Whether" Vs. "If"