MP3 - Storage/Player/SearchEngine
This program act like the famous iTunes software..
Upgraded POS
This is my Upgraded POS I was uploaded in this site 6 months later … I am using now ms access as a back end.. It is only cover the most important feature in the point of sale system.. (1.) the costumer walk in features (2).the Look up/search features… I hope that it will help to the student that have a point of sale thesis writing…. In this tutorial you can make your first step.. ( just add the
Folder Locker
This program is useful to those who are used in a shared computer coz sometimes we have personal data that we don’t want other people to view or access… in this software, you can now locked your private file with security by supplying a password to make sure that only you can unlock your folder again … to do, just double clicked the locked folder icon and enter the same password that you are
MP3 Player With Play List
I want to share my created MP3 Player with Play List coz in my search to this kind of program,, I was only found MP3 Player but no Play list feature.. So I think this is a big help for the newbie who want to do the same… this program play mp3 song continuously (Top to Bottom), detect if the song is finish playing, then jump to the next song in the play list..
Auto Copy USB/Pen Drive all Folder and Files
This program copy automatically all data (Folder and Files) inside the USB/Pen Drive when it is inserted into your computer and store that Data to (“C:\CopyUSB”) the folder created by the program in your computer…
Customized Button
It is a simple Tutorial on how to make a customized button for the replacement to the default gray button in vb6.. In this tutorial, I am using a picture box that act as a real button by the help of mouse event to make the illusion that it is really pressed by changing its color back and forth when you clicked and released your mouse button….
Facebook Clone Script / Look alike code
This code is made by me with the help of google.com and Sir Jomar Pabuaya our php instructor. In this code you can learn on how to make facebook like application. Such as on how to create facebook like live search, wall post, delete wall post, add friend and other that can be found in this application.
Guessing Game
How to Play: The game generates a random number from 1 - 1000. It will give you a hint through a percentage on how close you are the number. If you guessed the number, components will be disabled. What's your take? You may leave comments below or email me to xpginger at gmail dot com
SQL HAVING Clause
The HAVING Clause is always used after the GROUP BY clause, it can not come without the GROUP BY clause. It works the same as the WHERE Clause, it is therefore also used to apply conditions on the aggregate_functions which was impossible by using simple WHERE clause.
The HAVING clause simply contains the conditions to filter data just like in WHERE clause.
SQL HAVING Syntax
SQL FOREIGN KEY Constraint
A FOREIGN KEY is a key in another table that relates from the PRIMARY KEY in the parent table. A Foreign Key is needed in the related table to connect data from the primary table.
Let's take a look at the following example
Course Table
| CourseID | Course |
| 1 | Math 101 |
| 2 | English 101 |
Students Table