<?xml version="1.0" encoding="utf-8"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>Lowyat.NET: Latest topics by THE DEEPER</title>
        <description></description>
        <link>http://forum.lowyat.net/</link>
        <lastBuildDate>Tue, 09 Jun 2026 17:09:30 +0800</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>how when a couple have different life plans?</title>
            <link>http://forum.lowyat.net/topic/2410172</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;I&amp;#39;ve known a girl for almost a year now. We have an incredible chemistry that I never felt with someone else. She deeply loves me and I love her too. And we can&amp;#39;t stay away from talking to each other more than one day. &lt;br /&gt;&lt;br /&gt;I currently work overseas in a very lucrative job and she is a teacher in KL and plans to start her masters overseas. We want to get married so badly but our problem is we both place high value on our future plans. I want to continue working at my current job for additional couple years to collect money and start my own business one day, and she wants to get scholarship and further her studies. If she gets scholarship, by contract she has to work for the government for a number of years (min 3 years).&lt;br /&gt;&lt;br /&gt;She is proposing to get engaged for couple years until I get back to the country. But I don&amp;#39;t think I can wait that long. I want her as my wife today if possible&amp;#33; Plus I might move permanently to overseas if I find better opportunities which she can&amp;#39;t do because of her scholarship contract. Another conflict, I believe I can afford a very good life to her so I don&amp;#39;t want her to work after we get kids, but she insists to work even after we have kids. &lt;br /&gt;&lt;br /&gt;We are two stubborn people. Everytime we discuss about this, we end up fighting. But we forget it the next day (which is something I love about her, we never stay angry more than a day  &lt;!--emo&amp;:wub:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/wub.gif' border='0' style='vertical-align:middle' alt='wub.gif' /&gt;&lt;!--endemo--&gt; )  But We didn&amp;#39;t open this discussion for couple weeks now and for me I need to do something. I don&amp;#39;t like this stateless position.  &lt;br /&gt;&lt;br /&gt;What do you advise???? Any advise will help&amp;#33;&lt;br /&gt;&lt;br /&gt;Thank you&amp;#33;  &lt;!--emo&amp;:rolleyes:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/rolleyes.gif' border='0' style='vertical-align:middle' alt='rolleyes.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Cupid&amp;#39;s Corner</category>
            <pubDate>Sun, 01 Jul 2012 18:19:45 +0800</pubDate>
        </item>
        <item>
            <title>WTA Miniature Figures Manufacturer</title>
            <link>http://forum.lowyat.net/topic/1559365</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;I&amp;#39;m not sure if this is the right place. But I want to ask does anyone know any place that make/manufacture miniature figures?? like small models/action figures?&lt;br /&gt;&lt;br /&gt;I want to build a miniature version of a strategic game called Field Runners on the iPhone/iPad as a gift to a friend. Please let me know if you have any source&amp;#33; thanks &lt;!--emo&amp;:peace:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_rolleyes.gif' border='0' style='vertical-align:middle' alt='icon_rolleyes.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Gamers Hideout</category>
            <pubDate>Sun, 12 Sep 2010 18:29:38 +0800</pubDate>
        </item>
        <item>
            <title>[WTA] How&amp;#39;s salary in Jeddah, Saudi?</title>
            <link>http://forum.lowyat.net/topic/1512751</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;I got an offer for a job in saudi as an IT Consultant. Any idea how&amp;#39;s the average salary for IT guys there?? &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Jobs &amp;amp; Careers</category>
            <pubDate>Tue, 03 Aug 2010 16:16:08 +0800</pubDate>
        </item>
        <item>
            <title>What Java Web Framework do you use/recommend?</title>
            <link>http://forum.lowyat.net/topic/1509440</link>
            <description>Hi there, &lt;br /&gt;&lt;br /&gt;Need your consultation gurus..&lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;Soon I&amp;#39;m going to start a new project in which I have to use Java to build a web application. Since I&amp;#39;m more like a PHP guy, my knowledge is quite limited in Java. I know basic JSP and servlets. I took the project coz it&amp;#39;s challenging and it&amp;#39;s a good chance to have some hands-on training in Java, but at the same time I have to find the fastest way to get it done on time. So currently I&amp;#39;m researching which development tools to use to speed up the project. I heard about Java Web Frameworks and it seems they are powerful stuff, but there&amp;#39;re hundreds of them.  &lt;!--emo&amp;:x--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/doh.gif' border='0' style='vertical-align:middle' alt='doh.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;So guys which framework do you use or think it&amp;#39;s commonly used? and which one do you recommend? My criteria is simple: it has to have short learning curve (relative to the rest) and also should be MVC based architecture coz I&amp;#39;m familiar with MVC and I use PHP MVC frameworks a lot.  &lt;!--emo&amp;:hyper:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/rclxm9.gif' border='0' style='vertical-align:middle' alt='rclxm9.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;Looking forward for ur suggestions &lt;!--emo&amp;:respect:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/notworthy.gif' border='0' style='vertical-align:middle' alt='notworthy.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Codemasters</category>
            <pubDate>Sat, 31 Jul 2010 19:04:20 +0800</pubDate>
        </item>
        <item>
            <title>To be a designer or to be a coder?</title>
            <link>http://forum.lowyat.net/topic/1470932</link>
            <description>&lt;br /&gt;These days I&amp;#39;m thinking a lot about this topic. Currently, I play both roles in my projects, I design and code the system. However, I&amp;#39;m starting to think I should specialize more into coding (coz I feel I&amp;#39;m a little bit stronger in it) and get a full designer to help with the design stuff. The benefits I could foresee from this separation are as follow:&lt;br /&gt;&lt;br /&gt;1. I will produce better code because I will only be focusing on that part.&lt;br /&gt;2. Save time. I can work on the code while the designer do the design.&lt;br /&gt;3. Overall better quality coz two brains will work on the project instead of one. When you do everything in the project sometimes you miss the big picture.&lt;br /&gt;&lt;br /&gt;The disadvantages in my opinion are:&lt;br /&gt;&lt;br /&gt;1. Communication would be an added overhead. coz now you have to coordinate with someone else.&lt;br /&gt;2. A possible increase in project cost.&lt;br /&gt;3. Hard to find very good, dependable, web designers.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;What do you guys think of the developers who do both the design and the coding for web applications? &lt;br /&gt;&lt;br /&gt;Do you think that&amp;#39;s a good thing or a bad thing? is it possible or not? And is there any limit?&lt;br /&gt;&lt;br /&gt;Finally, are you a coder or a designer?????&lt;br /&gt;</description>
            <author>THE DEEPER</author>
            <category>Codemasters</category>
            <pubDate>Sat, 26 Jun 2010 20:51:55 +0800</pubDate>
        </item>
        <item>
            <title>Planning to offer a free WP template</title>
            <link>http://forum.lowyat.net/topic/1453807</link>
            <description>&lt;br /&gt;I just finished a big project recently and I have some free time before the next one starts. I&amp;#39;m planning to utilize this time to do some community work and offer a free wordpress template. I need some suggestions from you LYN bloggers. &lt;br /&gt;&lt;br /&gt;What themes should I do? e.g. Corporate, Technology blogs, news, personal blog...etc. I&amp;#39;m currently thinking to do a real-estate related theme.</description>
            <author>THE DEEPER</author>
            <category>Content Creators, Blogmasters &amp;amp; Webmasters</category>
            <pubDate>Fri, 11 Jun 2010 11:58:25 +0800</pubDate>
        </item>
        <item>
            <title>PHP Security Tips</title>
            <link>http://forum.lowyat.net/topic/1438016</link>
            <description>Hi there, &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Just sharing with you the top 7 security precautions I think you should take care of when you are building a web application using PHP. Feel free to add more tips if you&amp;#39;d like.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;1. User&amp;#39;s input is dirty until proven otherwise.&lt;br /&gt;&lt;/b&gt;Don&amp;#39;t ever trust user&amp;#39;s input. Period.  Always filter whatever input your application gets from users. There are so many ways unvalidated user input could cause problems, headache and embarrassment to you. Also, be very strict. If you are expecting a phone number (019123456), then don&amp;#39;t accept (019-123456). Use Casting all the time. PHP functions of htmlspecialchars() , htmlentities(), and strip_tags() are there to help you, use them. &lt;br /&gt;&lt;br /&gt;Don&amp;#39;t trust your forms too. Always make some rules/conditions when you are accepting data submitted by forms. Someone could create a fake form and send it to your processing page. so before you start processing the form, make sure it&amp;#39;s coming from your application not somewhere else.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;2. Clean Your Output&lt;/b&gt;&lt;br /&gt;whether you are saving data to DB or printing out the output, make sure you clean your output using PHP functions of htmlentities(), and  mysql_real_escape_string(). &lt;br /&gt;&lt;br /&gt;This step and the one above can actually solve many of the security issues in PHP.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;3. Show the errors&lt;/b&gt;&lt;br /&gt;While you are developing your app, enable ERROR_REPORTING(). It helps finding any errors, obviously, but more importantly, it will alert you if a variable is not initialized properly.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;4. Validate Your Users&lt;br /&gt;&lt;/b&gt;Use multiple variables when you are validating the user E.g. Session ID+User Group or user_id+session_id+an encrypted user agent data. Previously I used to depend mostly on Session ID but I learned sessions can be hacked so be careful. And I&amp;#39;d also prefer to save all sessions-related data into a DB instead of cookies or just PHP Session variables. If possible, don&amp;#39;t implement features like &amp;quot;Remember ME&amp;quot; coz to leave a user logged in for long periods is quite dangerous.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;5. Use SQL Prepared Statements&lt;br /&gt;&lt;/b&gt;SQL Prepared statements are really underestimated. Beside providing performance gains, they can add additional security to your code by limiting what data can be passed to MySQL as a query. &lt;br /&gt;&lt;br /&gt;&lt;b&gt;6. Use .htaccess as much as practical&lt;/b&gt;&lt;br /&gt;Protect your folders and files with htaccess as much as you feel practical. Ideally any config file or system file should be put outside the www folder if possible. For e.g. if you are using CodeIgniter Framework, you should only have the application folder in wwww folder, the rest should be resided on a higher level.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;7. Security Through Obscurity&lt;br /&gt;&lt;/b&gt;I simply love this rule. It basically means don&amp;#39;t provide your enemy enough information about your application that he can use to launch his attack.  The less your attacker knows about your app, the more frustrated he would be. And to make a hacker frustrated is a win already. Therefore, in live sites (production sites) always disable error reporting. Also don&amp;#39;t use common names for your admin section (e.g. admin/administration/backend..etc) or make the admin user name = admin&amp;#33; If you are using a framework or a CMS try to change the default folder names (e.g. change the wp-admin folder in Wordpress)</description>
            <author>THE DEEPER</author>
            <category>Codemasters</category>
            <pubDate>Thu, 27 May 2010 22:30:26 +0800</pubDate>
        </item>
        <item>
            <title>Can get AppleCare plan from Amazon?</title>
            <link>http://forum.lowyat.net/topic/1237481</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;Just wondering is it possible to get the AppleCare Protection Plan from Amazon? They&amp;#39;re currently selling for (after conversion) RM600. While resellers in malaysia sell it for min RM840. I&amp;#39;m not sure but I&amp;#39;m thinking since the protection plan is not hardware, so they might not have restrictions on it as they do on buying Macbook for non US markets.&lt;br /&gt;&lt;br /&gt;Anyone knows something about this may please enlighten us. &lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Apple Byte</category>
            <pubDate>Tue, 24 Nov 2009 03:11:23 +0800</pubDate>
        </item>
        <item>
            <title>What if I stop paying Astro?</title>
            <link>http://forum.lowyat.net/topic/1222565</link>
            <description>I&amp;#39;m fed up with astro....there is like four months left in the one year contract&amp;#33;&amp;#33; I wanted to cancel bt they said I have to pay the remaining months&amp;#33; what the heck is that?  so I plan to stop paying them at all...what they can do beside harassing you on the phone? &lt;!--emo&amp;:sweat:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/sweat.gif' border='0' style='vertical-align:middle' alt='sweat.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Serious Kopitiam</category>
            <pubDate>Tue, 10 Nov 2009 12:30:16 +0800</pubDate>
        </item>
        <item>
            <title>Plz review my personal website</title>
            <link>http://forum.lowyat.net/topic/1170556</link>
            <description>Hi, &lt;!--emo&amp;:P--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/tongue.gif' border='0' style='vertical-align:middle' alt='tongue.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;I really need your help to review my portfolio. I need your suggestions and comments in order to make it better and better, coz am sure it is far far away from Perfect yet.&lt;br /&gt;&lt;br /&gt;Please go here : www.ahmedjabar.com&lt;br /&gt;&lt;br /&gt;Thanx alot in advance&amp;#33;&amp;#33;&amp;#33;&amp;#33; &lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Content Creators, Blogmasters &amp;amp; Webmasters</category>
            <pubDate>Tue, 22 Sep 2009 10:43:32 +0800</pubDate>
        </item>
        <item>
            <title>The unknow soliders: The freelancers&amp;#33;</title>
            <link>http://forum.lowyat.net/topic/1127336</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;It is a fact.&lt;br /&gt;&lt;br /&gt;Freelancers are really treated badly in Malaysia. Just last week had a big issue with a client of mine and I felt undermined and disrespected coz I&amp;#39;m not representing a company but only myself....*sigh*.. I solved the issue somehow, but it left a painful thought of how bad is the experience of working as a freelance  in Malaysia.&lt;br /&gt;&lt;br /&gt;So here I&amp;#39;am asking all my fellow freelancers to share their experience. What are the main issues you all are facing as freelancers and What possible solutions you could suggest to tackle these issues?&lt;br /&gt;&lt;br /&gt;Finally, in your opinion is it worth it to work as a freelancer in Malaysia??  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Jobs &amp;amp; Careers</category>
            <pubDate>Wed, 12 Aug 2009 10:25:25 +0800</pubDate>
        </item>
        <item>
            <title>Here &amp;amp; There...my 1st gallery.</title>
            <link>http://forum.lowyat.net/topic/1070373</link>
            <description>Hi  &lt;!--emo&amp;:clap:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/rclxms.gif' border='0' style='vertical-align:middle' alt='rclxms.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;I took these in Bukit Nanas Forest Reserve.&lt;br /&gt;&lt;br /&gt;1. &lt;br /&gt;&lt;img src='http://photos-f.ak.fbcdn.net/hphotos-ak-snc1/hs108.snc1/4919_220662735178_532225178_7457717_6414707_n.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;&lt;br /&gt;2.&lt;br /&gt;&lt;img src='http://photos-c.ak.fbcdn.net/hphotos-ak-snc1/hs088.snc1/4919_220666515178_532225178_7457802_4641351_n.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;&lt;br /&gt;3. &lt;br /&gt;&lt;img src='http://photos-b.ak.fbcdn.net/hphotos-ak-snc1/hs088.snc1/4919_220660260178_532225178_7457681_1019276_n.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;&lt;br /&gt;4.&lt;br /&gt;&lt;img src='http://photos-d.ak.fbcdn.net/hphotos-ak-snc1/hs108.snc1/4919_220660275178_532225178_7457683_6406577_n.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;&lt;br /&gt;5.&lt;br /&gt;&lt;img src='http://photos-a.ak.fbcdn.net/hphotos-ak-snc1/hs108.snc1/4919_220660255178_532225178_7457680_3785766_n.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;&lt;br /&gt;Still starting to learn and long way ahead...  &lt;!--emo&amp;:P--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/tongue.gif' border='0' style='vertical-align:middle' alt='tongue.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;</description>
            <author>THE DEEPER</author>
            <category>Showcase</category>
            <pubDate>Sun, 21 Jun 2009 09:16:41 +0800</pubDate>
        </item>
        <item>
            <title>Spa Treatment to a lady co-worker..</title>
            <link>http://forum.lowyat.net/topic/1062036</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt; &lt;!--emo&amp;:D--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;One of my colleagues b&amp;#39;day is coming after a week or so. One day she was telling me her body feels stiff...and I tot &amp;quot;hmm, maybe i shud give her a spa treatment as b&amp;#39;day gift?  &lt;!--emo&amp;:hmm:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/hmm.gif' border='0' style='vertical-align:middle' alt='hmm.gif' /&gt;&lt;!--endemo--&gt; &amp;quot;...but is it too much of a gift for a colleague? I mean this is something usually bfs give la as I understand...so will it send a message that I actually don&amp;#39;t intend to send?&lt;br /&gt;&lt;br /&gt;kindly advice..&lt;!--emo&amp;;)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Cupid&amp;#39;s Corner</category>
            <pubDate>Sat, 13 Jun 2009 18:49:25 +0800</pubDate>
        </item>
        <item>
            <title>Is there a better way to do this Query?(SOLVED)</title>
            <link>http://forum.lowyat.net/topic/1002926</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;Guys I need your advice.&lt;br /&gt;&lt;br /&gt;I have a database application I&amp;#39;m working on currently. And in the application I have two tables, lets say admission table, and system table. &lt;br /&gt;&lt;br /&gt;The structure of the admission table is : &lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&lt;br /&gt;admission_id&lt;br /&gt;ic_no&lt;br /&gt;reference_number&lt;br /&gt;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;The structure of the system table is:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&lt;br /&gt;system_id&lt;br /&gt;sys_ic_no&lt;br /&gt;sys_reference_number&lt;br /&gt;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;What I want to do is to see if both tables share an account/data. So basically the user will give his IC NO and then the application should look into the two tables and see if the user account is in both, it should match based on two columns: ic no, and reference number. If IC NO does not exist, then it should look for the reference number. &lt;br /&gt;&lt;br /&gt;So currently I&amp;#39;m using two queries, 1st one is :&lt;br /&gt;&lt;br /&gt;&lt;b&gt;select * from admission JOIN system ON (admission.ic_no=system.sys_ic_no) where admission.ic_no=&amp;#39;xxxx-xxxx-xxxx&amp;#39;&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Then I will check if the result not empty, if not empty proceed, if empty then I launch the 2nd query:&lt;br /&gt;&lt;br /&gt;&lt;b&gt;select * from admission JOIN system ON (admission.reference_number=system.sys_reference_number) where admission.ic_no=&amp;#39;xxxx-xxxx-xxxx&amp;#39;&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;It is working OK....but I feel this is not the best way to do it....I want to combine both queries in one query..so do you have an idea on how to do that???&lt;br /&gt;&lt;br /&gt;your advice is much appreciated...&lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt; &lt;!--emo&amp;:thumbs:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/thumbup.gif' border='0' style='vertical-align:middle' alt='thumbup.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;--------------------&lt;br /&gt;&lt;br /&gt;&lt;span style='font-size:14pt;line-height:100%'&gt;&lt;b&gt;After playing around for sometime, I found the magic query and it works&amp;#33;, here it is for the public knowledge...&lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;select * from admission right join system on(admission.ic_no=system.sys_ic_no) where ic_no=&amp;#39;XXXXXX-XX-XXXX&amp;#39;&lt;br /&gt;UNION&lt;br /&gt;select * from admission right join system on (admission.reference_number=system.sys_reference_number) where ic_no=&amp;#39;XXXXXX-XX-XXXX&amp;#39;;&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;!--emo&amp;:)--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>THE DEEPER</author>
            <category>Codemasters</category>
            <pubDate>Sat, 18 Apr 2009 19:43:59 +0800</pubDate>
        </item>
    </channel>
</rss>
