|
|
|
| Title : |
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 |
Benedetto Patrice |
| Date : |
Jul 17th 2000 |
| Grade : |
3 of 5 (graded 2 times) |
| Viewed : |
3343 |
| File : |
No file for this code example. |
| Images : |
No Images for this code example. |
|
| Search : |
More code by Benedetto Patrice |
|
| Action : |
Grade This Code Example
|
|
| Tools : |
My Examples List |
|
|
|
|
|
|
# having for example a room and reservations database handling room_num and dates
SELECT rooms.num , rooms.type # ... all you need to know
FROM rooms
LEFT JOIN reservations on
( ( reservations.start <= "Date begin" AND reservations.end >= "Date begin" )
OR ( reservations.start <= 'Date dep" AND reservations.end >= 'Date dep" )
OR ('Date dep" >= reservations.start AND"Date begin" <= reservations.start ) )
and reservations.room_num = room.num
where reservations.room_num IS NULL
# enjoy
|
|
| Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Safe Authorization SELECT query
Categories : MySQL, Databases, General SQL | | | Browse a MySQL database & draw a tree view & load final items into a template page.
Categories : MySQL, Complete Programs, Algorithms, 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 | | | phpEasySQL - Easily connect to your MySQL database with just 1 php file and 3 easy steps!
Categories : Databases, PHP, MySQL, General SQL | | | Paginating the mySQL data
Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP | | | 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 | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | How to "group by" only by the date when you are really using a datetime
type of field.
Categories : Databases, MySQL, General SQL | | | Output database records in multiple table columns.
multiple, table, columns, output, format, query output, html table, php
Categories : General SQL, Algorithms, PHP, MySQL | | | A very simple and efficient split bar the B-Z bar , for mysql and php ...
Tired of obfuscated code try this one ...
Categories : PHP, Databases, MySQL, Algorithms | | | Multiple Search using PHP and Mysql
Categories : PHP, Databases, General SQL, 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 | |
|
|
|
