Wednesday, July 27, 2011

CSL is SCAM COMPANY!

Hi Everybody, I have a very important announcement to make,

CSL is a shit Malaysian company.

They always up-sell crap from China for their own profit.

Even dare to sell their crap Tablet for RM1599! Ipad 2 only RM1499!
go to http://www.cslcare.com/press/droidpad-launch-in-malaysia.html and http://store.apple.com/my/browse/home/shop_ipad/family/ipad to compare yourself if you don't believe.

Btw, even their company name oso copy-cat!



Copied from a telco in Hong Kong. Go to http://www.hkcsl.com/en/about_us/corporate_profile.jsp if you all don't believe, they hire some really genius SEO to optimize their search, so you cannot find this company if you go www.google.com.my, only www.google.com.hk can find.

At last, fuck this company and all their scammers! Greedy people with short-sighted business plan will fail! Everybody, boycott their product! If you wanna buy cheap China phone, buy the real cheap China phone, don't buy up-sell stuff!

Wednesday, April 27, 2011

Advanced Streamyx Settings

This is the Streamyx settings I extracted from a telekom router, in case anybody have trouble connecting after all the basic setting is correct

VPI: 0
VCI: 35
Service Category: UBR without PCR (PCR set to 0 for TP Link)
Encapsulation: PPPoE LLC
MTU: 1492
IGMP: disable
NAT: enabled
Firewall: disabled
IP Address: Dynamic
QoS: disabled
UPnP: disabled
RIP: none (any, Streamyx dun give any Routing Protocol)
DSL Settings: G.Dmt, G.lite, T1.413, ADSL2, AnnexL, ADSL2+ (make sure Annex M is unchecked)
Phone Line Pair: Inner Pair
Bitswap: Enabled
SRA: Disabled

Friday, March 25, 2011

SQL Insert command using set option to add records to MySQL table

SQL Insert command using set option to add records to MySQL table

using

Insert into library set book_name='Learning MySQL', author='plus2net group'

is better than

Insert into library(book_name, author) VALUES('Learning MySQL', 'plus2net group')

Wednesday, January 12, 2011

Connecting two mysql tables from different databases - PHP answers

This site have interesting examples to connect 2 MySQL tables in different database on different servers
Connecting two mysql tables from different databases - PHP answers

  1. //Define your database connections and select your database want to use. In this example I use two connections and two DBs. But you can use more than two.
  2. //MySQL Server 1
  3. $dbhost1 = "127.0.0.1";
  4. $dbuser1 = "dbuser1";
  5. $dbpassword1 = "dbpass1";
  6. $db1 = "database1";
  7. $connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
  8. mysql_select_db($db1,$connection1);
  9. //MySQL Server 2
  10. $dbhost2 = "xxx.xxx.xxx.xxx";
  11. $dbuser2 = "dbuser2";
  12. $dbpassword2 = "dbpass2";
  13. $db2 = "database2";
  14. $connection2 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
  15. mysql_select_db($db2,$connection2);
  16. //The SQL statement
  17. $sql =" SELECT database1.tablename1.fieldname1 AS field1, database2.tablename2.fieldname2 AS field2 FROM database1.tablename1,database2.tablename2";
  18. //Execute query and collect results in $results
  19. $results = mysql_query($sql);
  20. //Print result until end of records
  21. while($rows = mysql_fetch_array($results)){
  22. print $rows["field1"]." | ".$rows["field2"]."
    ";
  23. }
  24. ?>

Tuesday, January 4, 2011