Jump to content

jenny kaur

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

jenny kaur's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. [code] This is my db +----+------------+--------------+--------------+----------+ | id | bookdate   | Enddate      | Room_number  |   Guest  | +----+------------+--------------+--------------+----------+ | 1  | 1149609600 | 1149695999   |       1      |   Jones  | +----+------------+--------------+--------------+----------+ | 1  | 1149523200 | 1149609599   |       1      |   Smith  | +----+------------+--------------+--------------+----------+ [/code] below is my code [code] <?php [code] This is what i get output on screen   +---------+------------+------------+-----------+ | Room #  | 06/05/2006 |06/06/2006  |06/07/2006 | +---------+------------+------------+-----------+ |     1   |            |   Jones    |           |       +---------+------------+------------+-----------+ |     1   |   Smith    |            |           | +---------+------------+------------+-----------+ [/code] i am trying to get room 1 displayed once and Smith and Jones in the same row. like this: [code] +---------+------------+------------+-----------+ | Room #  | 06/05/2006 |06/06/2006  |06/07/2006 | +---------+------------+------------+-----------+ |     1   | Smith      |   Jones    |           |       +---------+------------+------------+-----------+ [/code] can someone tell me where i am going wrong?
  2. i need to know how to display a message if a certain day "2006-05-28" is in a date range input via a html form. [code]$start_date="2006-05-20"; $end_date="2006-05-29"; $start = strtotime("$start_date"); $end = strtotime("$end_date"); [/code] how would i display a message in the case above, i.e, your date selection includes "2006-05-28" which is a special day! however if the date is from 2006-05-29 to 2006-05-30, there should be no message. only if the date range features the 28th! please help, cheers!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.