<?php

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query = "SELECT name,type,MIN(totalprice) FROM transactions GROUP BY name,type";
$result = mysql_query($query) or die(mysql_error());

$data = '';
while ($row = mysql_fetch_array($result) {
$data .= 'Name: ' . $row['name'] . ', Type: ' . $row['type'] . " ";
}

$myFile = "testFile.txt";
file_put_contents($myFile, $data, FILE_APPEND);

?>

Originally posted by Trcyng:

ok you see...

 

SInce

 

$myFile = "testFile.txt"; // is specific the file
$fh = fopen($myFile, 'a') or die("can't open file"); //open
$stringData = "New Stuff 1 "; //write in (This is I am trying to put data here from  database)
fwrite($fh, $stringData);
$stringData = "New Stuff 2 "; //write in (This is I am trying to put data here from  database)

fwrite($fh, $stringData);
fclose($fh);

Just a question before we continue, are you developing on PHP 4 or PHP 5?

 

Ask for threesome.

 

Originally posted by Trcyng:

Is there any easier examples based on the codes below??

<?php

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
 
 
$query = "SELECT name,type,MIN(totalprice) FROM transactions GROUP BY name,type";
$result = mysql_query($query) or die(mysql_error());

$myFile = "testFile.txt"; //Specific Flie
$fh = fopen($myFile, 'a') or die("can't open file"); //open file
$stringData = "New Stuff 1 ";
fwrite($fh, $stringData);

$stringData = "THE SQL COMMAND CODES MAYBE $query ???"; // HELP NEEDED HERE
fwrite($fh, $stringData);

$stringData = "New Stuff 2 ";
fwrite($fh, $stringData);

fclose($fh);

I can't tell what you are trying to achieve from your code. Why are you storing the SQL query string in the text file? And there's no function call to fetch the data from $result.

 

Well, don't you think you're lucky that it only took you a D&T textbook to reveal the worm in that bad apple, when some others might have lent their friends thousands of dollars only to find them vanished into thin air on the following day?

 

Ironically, its wife looks like a guy.

http://celebgalz.com/tracy-lagondino-photos-thomas-beatie-photos/

 

"We are accepting a maximum of 500 completed surveys only, so click here to participate in this survey NOW!"

"Premier membership is not immediate... I can only add PM after the survey is over and I get the list of emails that are completed. But don't worry - you will surely get it!"

Need 500 members who are 30+ lau aunties wor. But maybe we do have that many aunties here. 

 

Later TS turn out to be bisexual and 1-vs-1 the victim. 

It would actually be "New Stuff1 New Stuff2 ". The text file would only contain one single line. And there's no WHERE clause in an INSERT statement. The code to write text into a file can be simpler with the file_put_contents() function if you happen to be using PHP 5 (see example below). If you want to query the database and save the output into a text file, it would be something like this:

Database

Table: some_table

id - user - score
1 - Dokuro - 12345
2 - Zakuro - 2345
3 - Sakura - 345

Application

<?php

$db = new mysqli('localhost', 'database_username', 'database_password', 'name_of_database'); // establish a database connection

$result = $db->query("SELECT user FROM some_table WHERE id = 1"); // query the database
$row = $result->fetch_array(); // retrieves a row from the query result as an array
$name = $row['user']; // get the value stored in the "user" column from the row retrieved

for ($i = 1; $i <= 4; $i++) { // writes the name 4 times in the file
file_put_contents('filename.text', $name . "\r\n", FILE_APPEND); // "\r\n" is used to "push" any following text onto the next line
}

?>

Resulting Text File (filename.text)

Dokuro
Dokuro
Dokuro
Dokuro

 

Originally posted by Evo4eva:

ermm,i want to noe the code for reading in the first alphabet as a input only.
eg: NAME   den take in N only....help me?...lol..

Assuming you already know how to get input using the Scanner class, just chain the charAt() method after calling the next() method.

http://forums.macrumors.com/showthread.php?t=148798#post_message_1729620

More information about the charAt() method here.

http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html#charAt(int)

Basically, what you are doing here is, when you call the next() method, it returns a String object which contains the input from the user (it's actually a token of the user input but we won't talk about it here). The charAt() method, coming from the String class, allows you to pick a character out of a String object. Say, for example, a user types in "sgForums" as input. If I want to retrieve the 3rd letter 'F', the offset of the letter would be 2 (skip 2 letters), thus I would call next().charAt(2) from a Scanner object.

If you don't understand any part of my post, please don't hesitate to clarify with me.

 

Please perform a Wuxi Fingerhold on your joystick. And flex your pinky after that.

 

"Teacher, I need some sperm cell samples to study them under the microscope. Can you help me, please?" 

 

Take it easy. The announcement is not even out and you're looking down on yourself already.

Those who have a similar CCA during their secondary education would definitely gain an upper hand in getting into the competition. Who knows, maybe they have committed as much time as you do into their CCA while they were still secondary students. But as the Chinese always say, "学如逆水行舟，不进则退". If they actually don't bother to turn up for any more practice sessions, thumbs up for you - you're one big step closer to beating them this year, if not next year.

Just ask yourself, are you really passionate about your CCA? Because no one would give up what they love just because of the obstacles they face in pursuit of their dreams. If, say, you've just joined a CCA about playing DotA. Then your team got pwned by another who has played it for 5 years and they were like gulping coke and munching pizzas while they cleared your team. You don't say "zzz. we too n00bs le. tio pwnzor by pr0s sia. i wan quit dota liao sio.", but look forward to the next match, hoping to defeat them with lots of training in between.

I wish you all the best.

 

Originally posted by ghast.:

i suggest u tell her friends about it. maybe her friends can help to tell her abt it more conveniently. she probably wont lose her temper on her frens that easily

I can tell you, if he does that, the next quarrel will start with "euu lather tok to my frens than me izit? euu dun rikes me anymore har?'" bla bla bla. I think it would be better for TS to approach her directly in a more discreet manner instead; simply remind her about her promise tactfully (eg. in a joking tone) every time she throws her tantrum.

 

Originally posted by bus555:

Anyway, guess the person who create the "girl" somehow must be like took 50 mins to complete it

It depends on whether you are doing it manually, or by using a software like AscGen.

 

The download speed you get on torrents very much depend on the number of users seeding (providing) the files you are downloading. Think of these seeders as water taps somewhere far far away from you and Singnet as a water pipe bringing water from the taps to your house. If the water taps can only output small amounts of water, having a bigger pipe wouldn't bring you more water no matter what.

Try this torrent, seeded by 1200+ users as of now, which should be able to use up your entire downstream of 8mbps, assuming that there is no issue with the configuration you have for uTorrent and you did not cap your download.

http://releases.ubuntu.com/8.04/ubuntu-8.04-desktop-i386.iso.torrent

 

Originally posted by ndmmxiaomayi:

http://cuteworm.com/

Know anything about this?

There was a conflict between the owner of Zion, a VPN in the form of an mIRC add-on script once popular among gamers, versus one of the main programmers of Zion otherwise known as CuteWorm (a Singaporean in fact).

What CuteWorm did was that he exposed one of the vulnerabilities in Zion which allowed remote code execution and pointed out where the code can be located within the script. He has also advised visitors on his site to boycott Zion and use alternatives instead. Coincidentally, there was a new patch for Zion around the same time which seemed to have removed it, but on top of that, it modifies the hosts file on the system to point cuteworm.com to their own servers (ZincPlay.com, 66.212.25.134) so that no one using Zion will be able to access CuteWorm's site and find out that the existence of the vulnerability, on the pretext of protecting its users from TrojanH.CuteWorm (which probably didn't exist).

I think they have resolved the issue among themselves already, I guess, seeing that there's once again a download link for Zion on CuteWorm's site (it was previously removed when the vulnerability was exposed).

Long time short, speaking as an ex-user of Zion, Zion sucked, just like its owner.

 

Once again, change the encoding of the XML file to UTF-8.

<?xml version="1.0" encoding="utf-8"?>

 

Originally posted by weiyang999:

i loves too...i like armpit too

So fast come out of jail liao ah?

 

I have recently read an interesting article which seems to apply in this case regarding school bullying and I would like share it here.

Excerpts from Why Nerds Are Unpopular:

Originally posted by Deino:

everyone deserves to die...but at the same time they deserve to live too...

everyone deserve their own judgement also...but that doesn't mean they have the right to execute their judgement...

 

Me don't understand what you are trying to express. Mind elaborating?

 

Originally posted by Daisuke-kun:

intelligent people dun kill demselves.

they plan up a counterattack on the bullies.

i have to say something to this boy.

You don't deserve to live if you can't handle this.

You don't have the right to judge whether he deserves to live for

i. you are not him
ii. you are not in anyway related to him
iii. you don't know how much stress he was under from all that bullying.

A person, no matter how intelligent he is, will break down under immense pressure.

 

Originally posted by fudgester:

Self-fulfilling prophecy.

You are becoming more and more short-tempered this month precisely because you believe in what your friend predicted.

Chances are that you're not more or less short-tempered than before.... you simply perceive yourself as being more short-tempered because of what your friend said.

So don't think so much about all this stuff.

Yep, it may turn out to be a self-fulfilling prophecy if you believe what your friend said was true. An example would be that you decide to go overseas on a ship instead of a plane because of the prediction, and Mas Selamat happened to be on that ship. Just believe that it's just a random guess by your friend and put it at the back of your mind.

 

Originally posted by XiaoWangZi:

malware? what is that. Wad program should i use to scan?

A good anti-virus program will do the job nicely.

 

Set the character encoding to UTF-8.