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
|phpAds, a complete banner and ad management system with detailled tracking and stats.|
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases
|ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL,
Oracle, Interbase,ODBC, Microsoft Access and FoxPro.|
Categories : PHP Classes, Databases, PHP, General SQL, ODBC
|How to group by only by the date when you are really using a datetime type of field.|
Categories : Databases, MySQL, General SQL
|Count how many weeks in the month have a specified day, such as Mon, Tue, etc. Var avail - number of days - first day name of the month, occurrences of Sun, occurrences of Mon, etc. Allows you to calculate number of working hours exclude Holidays.|
Categories : Calendar, Date Time, PHP, Databases, MySQL
|Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.|
Categories : Databases, PHP, MySQL, Complete Programs
|Link Manager for Link Exchangers|
Categories : PHP, PHP Classes, Databases, MySQL, CURL
|SQL / PHP based Integrated Authentication|
Categories : PHP, Authentication, Databases, MySQL
|Record Set Paging with PHP (RSP)|
Categories : PHP, MySQL, Navigation, Databases, HTML and PHP
|Message of the Day - Random Message (Needs MySQL!)|
Categories : Databases, HTML and PHP, PHP, MySQL