Tryangled Dev

SELECT sports_name
FROM sports
WHERE id
IN (

SELECT sports_id
FROM sports_key
WHERE user_id =1
)

In this query we have selected field(sports_id) from the table(sports_key) and also we checed the field(user_id) This process has been done in subquery. Then finally, we have selected field (sports_name) from the table (sports_key) according to receiving field (id) values from subquery.

 <a href=”contactus.php?act=contactus” onclick=”javascript:window.open(’contactus.php?act=contactus’ ,’contactus‘,’width=564PX,height=600PX,scrollbars=yes,top=0,left=0′); return false;”>
Contact Us</a>

in the above code when the highlighted window name is given without space..

But by mistake if u give a space in between the name like “contact us” then this will not work in Internet Explorer  and the same will work in Mozilla Firefox

SEO - Making your page “optimal” for visibility in various search engines. Nothing social about that unless you’re using something like Mahalo.

Social Media Optimization - the phrase Social Media Optimization was first invented by Rohit Bhargava.It means Making your web pages and your site content easy to bookmark, share, recommend to friends, to comment on or even to syndicate on Facebook, other blogs etc. Things like adding chicklets for Digg and Delicious, email this link options, post to Facebook, embed video links, add to social shopping sites (for ecommerce)…

Social Media Marketing - this is the off-page stuff. This gets into link building a bit, if you’re using social networks to build links. For example, you make a certain type of handmade Stone (Granite , Marble ETC….). You can join the social shopping engine Etsy which focuses on hand-made and Kitchen COuntertops, submit your products to the social shopping site FiveLimes that loves the green friendly business, and write an article about how your product saves the planet and post it on Green friendly sites like Care that allow you to post your own blog entries. Include keyword optimized contexual link within the article, and you’re SMM’ming and SEO’ing.

The main point of internet marketing is to generate traffic and lead visitors and customers to your site. Your site’s visibility will be the key factor for you to attract customers and make sales. Online marketing strategies have this purpose in mind.Let us count the simple ways of marketing online:
Link Building:
To achieve greater visibility in the Web, you have to have a high ranking in the search engines. To have a high ranking among the search engines, building links is vital. Search engine spiders crawl across the Web to look for the number of links you have and use it as one of the important bases on ranking your website. Build links all over the Web by reciprocal linking, creating quality content, and submitting your site to the site directories!
Keyword Search:
Search for your main keyword and other terms that are related to your site. When making links, you can use your keyword and terms as an anchor text for more visibility to your site. Make use of keyword tools available online to search for the most searched for word that you can use as your keyword.
Site Directories:
By submitting your site to site directories, you are also placing another link for the search engines to crawl. This adds to your number of links and can increase your rank among the search engines.
Article Submissions:
One technique in leading visitors and generating traffic to your site is by submitting relevant and interesting article to article directories. Submitting articles to the directories can also help you build more links to your site, thus gaining you more links and increasing your rankings. Don’t forget to make the article creative and relevant, of course. Readers won’t be curious to see your website if your article doesn’t get their attention.
Affiliate Marketing:
The downside of this strategy is that you’ll have to spend for the commissions of affiliate sales. Nevertheless, this strategy is used by many internet marketers. Affiliate marketing usually works by networking with other websites that are in the same niche as you. Now since you are both in the same niche, most usually the traffic that you can generate through affiliate marketing is targeted. This is about the best thing abut affiliate marketing (aside from generating sales). You are also building links through the links (in the ads) on the website that you are affiliated with.
Newsletters and Subscriptions:
Sending newsletters to the customers and clients will not only help in building professional and friendly relationships with them, but also brings in targeted traffic to your web site. Whenever you have something new to talk about and events to promote, newsletters can be a great way to let the clients and customers in on the news.
Email Marketing:
This is another popular way to generate traffic and occasionally make repeat sales. This is kind of like sending newsletters, only your are more or less not sending news but rather promoting your latest products and services. Remember that when making your emails, you should avoid making it spammy and annoying. Make your email content original, creative and interesting.
Forums:
You can see the most eager visitors of the online community in forums. Participating and giving great content in the replies will help in establishing you as an expert in your niche. This will give you a boost in the eyes of the online community. You’ll be able to form relationships among the community and get them to be interested in your site and business. Plus, you can place links to your website on your signature every time you make a post! This can increase your rankings and visibility in the search engines.

April 10th, 2008
Viruses, worms and Trojans that have circulated across the net have reached an all time high of one million, the highest number of malicious programme to date. Security firm Symantec revealed in its bi-annual report, that most of these malicious programmes have been created in the last 12 months. The Latest Symantec reportedly detected approximately 499,811 malicious code threats during the second half of 2007. This had increased in the first half of 2007 by 136%.

However, 2007 was a year that Symantec had detected over 711,912 new threats amounting to 1,122,311 of malicious programs. The report stated, “…almost two thirds of all malicious code threats currently detected were created during 2007.” Many of the cyber criminals have created programs that fool anti-virus software to look for characteristics already seen by them.

Resource files are the files containing data that is logically deployed with an application.These files can contain data in a number of formats including strings, images and persisted objects. It has the main advantage of If we store data in these files then we don’t need to compile these if the data get changed. In .NET we basically require them storing culture specific informations by localizing application’s resources. You can deploy your resources using satellite assemblies.

Full Assembly reference: A full assembly reference includes the assembly’s text name, version, culture, and public key token (if the assembly has a strong name). A full assembly reference is required if you reference any assembly that is part of the common language runtime or any assembly located in the global assembly cache.

We can dynamically reference an assembly by providing only partial information, such as specifying only the assembly name. When you specify a partial assembly reference, the runtime looks for the assembly only in the application directory. We can make partial references to an assembly in your code one of the following ways:
Use a method such as System.Reflection.Assembly.Load and specify only a partial reference. The runtime checks for the assembly in the application directory.
Use the System.Reflection.Assembly.LoadWithPartialName method and specify only a partial reference. The runtime checks for the assembly in the application directory and in the global assembly cache.

Class instances often encapsulate control over resources that are not managed by the runtime, such as window handles (HWND), database connections, and so on. Therefore, you should provide both an explicit and an implicit way to free those resources. Provide implicit control by implementing the protected Finalize Method on an object (destructor syntax in C# and the Managed Extensions for C++). The garbage collector calls this method at some point after there are no longer any valid references to the object. In some cases, you might want to provide programmers using an object with the ability to explicitly release these external resources before the garbage collector frees the object. If an external resource is scarce or expensive, better performance can be achieved if the programmer explicitly releases resources when they are no longer being used. To provide explicit control, implement the Dispose method provided by the IDisposable Interface. The consumer of the object should call this method when it is done using the object.

Dispose can be called even if other references to the object are alive. Note that even when you provide explicit control by way of Dispose, you should provide implicit cleanup using the Finalize method. Finalize provides a backup to prevent resources from permanently leaking if the programmer fails to call Dispose.

ID identifies and sets style to one and only one occurrence of an element while class can be attached to any number of elements. By singling out one occurrence of an element the unique value can be declared to said element.
CSS
#eva1 {background: red; color: white}
.eva2 {background: red; color: white}
HTML - ID
<P ID=eva1>Paragraph 1 - ONLY THIS occurrence of the element P (or single occurrence of some other element) can be identified as eva1</P>
<P ID=eva1>Paragraph 2 - This occurrence of the element P CANNOT be identified as eva1</P>
HTML - CLASS
<P class=eva2>Paragraph 1 - This occurrence of the element P can be classified as eva2</P>
<P class=eva2>Paragraph 2 - And so can this, as well as occurrences of any other element, </P>

CSS allows Unicode characters to be entered by number. For example, if a CLASS value in some Russian document contains Cyrillic letters EL PE (Unicode numbers 041B and 041F) and you want to write a style rule for that class, you can put that letter into the style sheet by writing:
.41B41F {font-style: italic;}
This works on all keyboards, so you don’t need a Cyrillic keyboard to write CLASS names in Russian or another language that uses that script.
The digits and letters after the backslash (\) are a hexadecimal number. Hexadecimal numbers are made from ordinary digits and the letters A to F (or a to f). Unicode numbers consist of four such digits.
If the number starts with a 0, you may omit it. The above could also be written as:
.\41B\41F {font-style: italic;}
But be careful if the next letter after the three digits is also a digit or a letter a to f! This is OK: .\41B-\41F, since the dash (-) cannot be mistaken for a hexadecimal digit, but .\41B9\41F is only two letters, not three.
Four digits is the maximum, however, so if you write:
.41B941F {font-style: italic;}