Like this code?
Show the author your appreciation.
The example is useful to search a database. If we want to retrieve the data by a persons name then we just write one query and then it returns but my example mainly focus on multiple searches such as if you want to search into multiple tables by name [Table 1], by date of birth [Table 1] , by academic [Table 2] , by department [Table 3] then my example gives you a very simple way to search.
Please see attached file above.
|Point and Click Interface ala MS Access for creating SQL statements.|
Categories : MySQL, Complete Programs, General SQL, PHP, Databases
|This function will populate the options in a drop down HTML select list
in a form from a database query.
Categories : MySQL, General SQL, PHP, HTML and PHP, Databases
|I`d like to use the mysql_fetch_row function along with a "randomizer"
function that would give me a random result from a mySQL table.|
Categories : General SQL, MySQL, PHP, Databases
|bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager|
Categories : MySQL, PHP, MySQL, Complete Programs, Databases
|This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.|
Categories : Databases, MySQL, Complete Programs, PHP, Databases
|phpEasySQL - Easily connect to your MySQL database with just 1 php file and 3 easy steps!|
Categories : Databases, PHP, MySQL, General SQL
|Solution to those 'tell-a-friend' type email issues|
Categories : PHP, Email, Databases, MySQL
|PostGreSQL and MySQL 2 in 1 db Manager|
Categories : PHP, PHP Classes, Databases, PostgreSQL, MySQL
|A template script to provide the ability to get the next or previous n records from a MySQL database.|
Categories : Databases, PHP, MySQL
|Education Center is a set of PHP-scripts to administer a corporate education and examination system via Internet/intranet written in PHP for MySQL.
Categories : PHP, Databases, MySQL, Complete Programs
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL
|BBS system for easy customization. Utilizes mySQL.|
Categories : Complete Programs, MySQL, PHP, Databases
|You have a set of many resources , and You need to know wich of these resources are available for a given use during a given period but MySql does not allow SUB-Selection :(
here is the right way to do that in a single query
Categories : MySQL, General SQL, Databases, Algorithms
|Returns the last row from a select where multiple rows have been selected.
In this case it is used to determine the last number in an AUTO_INCREMENT column. I use it to create "ticket numbers" or anything that needs a unique ID in sequence.|
Categories : mSQL, MySQL, Databases, PHP
|myCSV-dump converts a simple CSV-flatfile-database into an MySQL-dump.|
Categories : PHP, MySQL, Databases, Complete Programs