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
1. Color Mapper
This is a very powerful utility which reads an image and ultimately generates the sed commands to modify existing CSS files to reflect the colors of that image
Category:
Learn how to create a simple AD rotator script without using database. The script can display both text and image ads and you can control the number of ads to be displayed at once.
Category:
Learn how to create e-mail button in flash using a little action script code. You can use this button for any web site, and on that way, enable every users to sent e-mail.
Category:
- Click in Star rating style , the code are generated for you.
- Cut and paste the code in your page !
- All Rating are unique if need 1+ more rating per page need to generate a new code
- Cut and paste the code in your page !
- All Rating are unique if need 1+ more rating per page need to generate a new code
Category:
This script has error handling to check whether the upload was successful or not. If the uploading failed, the user will be notified of this with an error message. Case the upload was successful, the file which have been uploaded will be placed in a folder on your server and the user will be provided with a success message, including information regarding the file which has been uploaded. The filename, filesize and filetype will be outputted for the user to view once the uploading has been completed
Category:
In-function caching can be used to greatly improve the performance of our software. Applying this technique effectively is important to avoid spiraling memory usage and bizarre bugs that can be caused by old cache data lingering around.
Category:
Looking to add an auto suggest box on your website that searches your database? This article shows you how to use the Scriptaculous Ajax.AutoCompleter with PHP and MySQL to build a database powered autosuggest box.
First make sure you have the Scriptaculous library downloaded and included in your webpage. After you have downloaded the library and placed it in your website’s folder, including it is as simple as adding the following script tags between your head tags.
First make sure you have the Scriptaculous library downloaded and included in your webpage. After you have downloaded the library and placed it in your website’s folder, including it is as simple as adding the following script tags between your head tags.
Category:
ASP Form2Excel and Mail is an extension for Adobe Dreamweaver MX or later versions, which allows sending every field of a form filled by a user, into an Excel file formatted as CSV, while adding other data that help to know more about the user and allow to offer a better technical support and give a more personalized answer. This way, you will receive all the information collected by the forms, and later you can open the file in Excel and apply filters, calculations, graphs, etc., thereby using Excel as a analisys tool.
Category:
This handy PHP script will allow you to check if a website is banned from Google. Just enter a domain name and see if it is included in the Google index.
Server requirements
This Google ban checker script requires PHP 4.1.0 or higher. No installation required - just upload it to your server and you are all set.
Server requirements
This Google ban checker script requires PHP 4.1.0 or higher. No installation required - just upload it to your server and you are all set.
Category:
ZZEE DHTML Menu is a library for Javascript and PHP that you can use to create familiar dropdown menus like in desktop applications. Please see the detailed description in the help file.
ZZEE DHTML Menu is fairly easy to install and embed into your existing HTML or PHP pages.
ZZEE DHTML Menu is fairly easy to install and embed into your existing HTML or PHP pages.
Category:
We offer a simple and effective way to host and share your images / photographs with friends and family, use on auction listings and websites or other online use.
Category:
ProBulletin is a professional bulletin board system written in a combination of Perl, HTML, Javascript and CSS and is suitable for small to large websites alike.
Category:
14. Shopcart 3
Shopcart 3 script is a fully functional, feature rich, popular and high in demand digital items delivery shopping cart script. The script has many advanced options that allows you to set up your online store web site exactly the way you want! Shopcart 3 script supports 4 payment gateways: Paypal, Alertpay, SFIPay and SafePAY. Note that this is not automated shopping cart script! You as a webmaster will send download link to your customer manually after you verify payment! Script comes with many options that can increase your earnings and have integrated banner rotator on every page thruout the script. Script also comes with intuitive and clean admin area that will make maintenance smooth and fast! Entire script is covered with css file which makes changing colors and tables and fonts really easy! Many protection features are implemented to prevent thieves to snoop around! Every download link you generate thru admin area have unique combination of 9 digits/characters username and 9 digits/characters password!
Category:
Pars4u Music/Video Portal is one of the most advanced Music/Video Portal on the net. You can easily start your new business in les than 10 mins. everything is ready for you to start earning money from ads on top of your webpages. users can : - Brows Music/Video/Images easily - They can download Music and videos - see their favorite singers pictures and read their biography admin can : - add/edit/delete singer - add/edit/delete Albums to a Singer - add/edit/delete Music To an album - add/edit/delete News - Edit About Us Block - add/edit/delete Ads - add/edit/delete videos to a singer. - and much more *NOTE : There are some functions missing on the server that our demo is currently on, and that cause our script's index page to not working properly. there is a picture of the proper index page you can check it out : http://tinypic.com/view.p hp?pic=4g9688y the inproper one : http://i7.tinypic.com/2zg zy8n.jpg Live Demo: http://www.pars4u.com/dem o/ Admin Panel: http://www.pars4u.com/
Category:
Traditional way of generating passwords is using rand() function: concatenate several random-selected letters together. Something like this:
Category:
Learn how to create a boat animation in flash 8 on a simple way in few steps, with no Action Script. You will also learn how to use Free Transform Tool (Q), how to convert a bitmap image into a Movie Clip Symbol and more
Category:
Fresh Email Script is a very unique script that you will Never find anywhere else. The first to implement it, we have created this script to revolutionise the file uploading system integrating an email upload feature.
Category:
LetSnow Flash Component
is a standard extension for Adobe Flash CS3.
We have built our component to be easily customizable and easy to use.
is a standard extension for Adobe Flash CS3.
We have built our component to be easily customizable and easy to use.
Category:
True Font Family is a script in order to use True Type web fonts as if they were supported by current browsers. This means, you can use any font on the Internet using standard CSS without any kind of manual work. Just install True Font Family once and that is all. It will save a lot of time and offer new possibilities.
Category:
Other links at PHP > Scripts and Programs > Database Tools
apgDB2xls is a PHP script capable of converting a database table
Category:
A tool that helps with MSSQL to MySQL converting/replicating under *nix. It is possible to use it with crontab also for regular data fetching. Keeping mySQL-based data warehouse refreshed could also be one of the possibilities of using this script. Small MSSQL command line client and tutorial for setting it all up is also included in the tar.gz/zip file.
Category:
3. txtSQL
PHP:Paging is a PHP component that will help you create paging easy and quickly. Creating good paging is often a big hassle, and you often have to use a lot of if-else statements or use difficult template language. PHP:Paging does this all for you, and all you need to do is write some simple HTML.
With PHP:Paging you will be able to create simple or advanced paging within seconds. You will be able to link directly to certain pages, link to next pages, link to different 'perpage' links, and more. It's all explained in the manual.
With PHP:Paging you will be able to create simple or advanced paging within seconds. You will be able to link directly to certain pages, link to next pages, link to different 'perpage' links, and more. It's all explained in the manual.
Category:
5. SQLmax v1.0
SQLmax is an independant SQL layer (database free)
wich prodive you a complete POO class with automatic file cache system support.
It works in PHP
wich prodive you a complete POO class with automatic file cache system support.
It works in PHP
Category:
Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
175
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: 20048
Categories: 1275
Registered Users: 790
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234751
Pagerank Statistics
PHP News