NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Query2Tree v.2. Convert any query to tree
38678
Query2Tree v.2. Convert any query to tree
http://www.tsiros.net/query2tree/
1. select continent,country,concat("area: ",area," population: ",population) from countries
2. select left(country,1) as lex,country from countries
3. select continent,left(country,1) as lex,concat(country," (",capital,")") from countries
4. select concat(conti.continent," (",FORMAT(sum_pop,0),")") as cont_pop,country,FORMAT(country.population,0) from (select continent,sum(population) as sum_pop from countries group by continent) as conti left join (select continent,country,population from countries) as country on conti.continent=country.continent PHP > Scripts and Programs > Database Tools Aug 7, 2008 P.Tsiros send email to P.Tsiros
2. select left(country,1) as lex,country from countries
3. select continent,left(country,1) as lex,concat(country," (",capital,")") from countries
4. select concat(conti.continent," (",FORMAT(sum_pop,0),")") as cont_pop,country,FORMAT(country.population,0) from (select continent,sum(population) as sum_pop from countries group by continent) as conti left join (select continent,country,population from countries) as country on conti.continent=country.continent PHP > Scripts and Programs > Database Tools Aug 7, 2008 P.Tsiros send email to P.Tsiros
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Query2Tree v.2. Convert any query to tree: |
|||
Other links owned by this user
This web application is especially design for small to medium car dealership businesses. It is database driven and the content is fully updatable through an online back end interface.
Category:
Create Web based configuration wizards
Category:
As our data getting mobile and copying picture is annoying for me I decide to save the picture in the database (mysql).
Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel).
Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel).
Category:
Learn how to use the Select Case functionality in ASP.
Category:
If you are not happy about such names of your photo files as “Img_0275.jpg”, “Dsc00403.jpg”, you need a tool to solve this problem – it is Fast Photo Renamer. You can rename either each photo separately or all photos in a folder at once.
Category:
6. Screen Ruler
Measure anything on your screen with this free
Screen Ruler tool...
Screen Ruler tool...
Category:
Select the Text tool (T).In the Property inspector below the scene, choose Dynamic (see left part of the image below), and type somewhere above the preloader 99%. See the picture
Category:
Welcome to Zeustemplates.com, where we offers premium Frontpage templates, Expression Web templates and Dreamweaver templates. For just one low price of $49.95, you have unlimited access to downloads all the Frontpage templates, Expression Web templates and Dreamweaver templates for a full 6 months. Not only that, new Frontpage, Expression Web and Dreamweaver templates are added frequently as well.
Category:
calculator is fully functional, so if you want to check whether you are overweight and how to fix that, go ahead. The instructions below are for webmasters which want to use this calculator on their websites for free.
Category:
Here is a Demo both scripts linked note the (broadcast) link in the myspace clone and the Social link in the youtube clone menus. Can be on 1 domain or 2, even setup with your current site as 3rd
Category:
Using an admin page, you can delete users, and send your message. You have an option of HTML or Text message sending. The archive.php page you can view past newsletters.
Category:
Certainly you experienced that your personal email address has been caught by spammers because you receive a lot of junk mail (Spam). Some people react defensive by creating a second personal email address to place in the web. Or they replace their mail address with a contact form or even set an image containing the address instead.
But all of these security actions do not work properly if you get a lot of junk mails today. And all of these actions reduce the functionality of your website, because its not more possible to click on an image and write you a personal mail.
But all of these security actions do not work properly if you get a lot of junk mails today. And all of these actions reduce the functionality of your website, because its not more possible to click on an image and write you a personal mail.
Category:
Learn how to create simple and in the same time very attractive and useful picture appearance using the Color Mixer Panel and gradient. To make this tutorial, you don't have to use action script.
Category:
In the spirit of Web 2.0, ClipShare ( Video Sharing Community Script ) now comes with a wide range of free CSS Tableless Templates. ClipShare is the ultimate solution for starting your own highly profitable video sharing & uploading community website just like the big boys: Youtube, DailyMotion, MySpace Videos, MetaCafe. Clip Share video sharing software offers a powerful and feature rich solution and most important of all, at an extremely affordable price.
Category:
This code shows how to read in the contents of a text file and save it to a variable.
Category:
16. Class: DNServer
17. Chat Bar
This is a cool software that will allow you to have a chat bar your site
What is this all about?
This scroll messages which your site visitors can post. They can chat with each other in a nice way nicer than a chat room or a shoutbox. The messages can flash all the time in a small range that is you can through the char bar anywhere in your site without messing up your site also Its not made as a scrolling chat bar its flashing so its very fast in loading. The best place where you can find such as these bars is in many TV stations they have a news scrolling bar at the bottom of there screen, or even chat bar of the viewers by sms . This script will do almost the same thing.
What is this all about?
This scroll messages which your site visitors can post. They can chat with each other in a nice way nicer than a chat room or a shoutbox. The messages can flash all the time in a small range that is you can through the char bar anywhere in your site without messing up your site also Its not made as a scrolling chat bar its flashing so its very fast in loading. The best place where you can find such as these bars is in many TV stations they have a news scrolling bar at the bottom of there screen, or even chat bar of the viewers by sms . This script will do almost the same thing.
Category:
18. ChickenSMS v4
ChickenSMS v4 is a new version of my Text Messaging scripts, what this script allows you to do is send Text Messages to phones around the world. This will save you and your visitors money because they can use this instead of their cell phone. This will bring them back for more free text messages. In this version we have added a simple templating system, now you can change between the themes in a breeze and make your own. In this version their is now an Install script making it as easy as A B C to install this.
Category:
Works with ASP.NET 1.1/2.0/3.0 Seamlessly supports ASP.NET AJAX Closely integrated with Visual Studio; Free support
Category:
20. shoutbox system
Moonshout is an easy to use shoutbox system, coded in PHP and uses MySQL database to store the posted messages. Your users can view your website and post messages, which display in the scrollable box. You can easily place this shoutbox on your webpage, by following the instructions included. If you have some troubles getting the shoutbox to work correctly, please click here.
Category:
Other links at PHP > Scripts and Programs > Database Tools
IT MANIA is a professional web design and development company. We build valuable relationships with our clients and their success fuels our success. We are dedicated to developing creative professional website designs that are as rich and distinct as the world around us.
Category:
ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite
Category:
Have any of your database driven sites been rendered useless because of of lost images? Keeping them in the database is a solution to that problem. Downloads and images are often part of a website's content: If a website's content is to be derived from a database, then so should these. Although it does double the site's disk space requirements, such an approach helps ensure a truer independence of the front-end and business logic of a site from the back-end.
Category:
QLR Manager is the affordable, yet powerful, server based REPORT and CHART generator for MySQL, Oracle and PostgreSQL databases. In addition to its exceptional reporting capabilities, QLR Manager now provides support for integrated e-mail distribution, making it a powerful communications tool. User Menus can be created to simplify report generation and limit user access to sensitive data. The application is 100% HTTP server based and accessible using any newer, mainstream web browser. Accessing your databases has never been easier with its intuitive browser interface, and there is no client code to install and maintain. QLR Manager can be used as a stand alone product or as middleware to integrate REPORT OBJECTS into your website
Category:
Main Category
192
2037
816
286
175
1802
1222
911
1163
7478
70
907
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19493
Categories: 1275
Registered Users: 748
Mailing List Subscribers: 2046
Unique Outgoing Hits: 227533
Pagerank Statistics
PHP News