ambrennan

[!--quoteo(post=362472:date=Apr 7 2006, 05:11 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ Apr 7 2006, 05:11 AM) [snapback]362472[/snapback][/div][div class=\'quotemain\'][!--quotec--] I see you indent your code, but in an irregular way so your code blocks dont line up. You should of added two closing braces just before the closing PHP tag (?>). Here is you corrected code: [code]<?php require_once('Connections/xxx.php'); if($_GET['action'] == "xxxxxxxx") {     $arrDate_day   = $_POST['arrDate_day'];     $arrDate_mon   = $_POST['arrDate_mon'];     $arrDate_year  = $_POST['arrDate_year'];     $RoomType      = $_POST['RoomType'];     $SmokingYesNo  = $_POST['SmokingYesNo'];     $deptDate_day  = $_POST['deptDate_day'];     $deptDate_mon  = $_POST['deptDate_mon'];     $deptDate_year = $_POST['deptDate_year'];     $arrivalday    = $arrDate_year . "-" . $arrDate_mon . "-" . $arrDate_day;     $departuredate = $deptDate_year . "-" . $deptDate_mon . "-" . $deptDate_day;     if($arrivalday >= $departuredate)     {         echo "<h2>Your arrival date cannot be greater than your departure date</h2>";         $query = "SELECT * FROM `room_desc_t` t LEFT JOIN `reservations_t` r WHERE t.room_type='{$RoomType}' AND         room_smoking='{$SmokingYesNo}' AND r.res_arrival_date >= '{$Arrival}' AND r.res_departure_date < '{$Departure}'";         $result = mysql_query($query) or die("Unable to execute query: ".mysql_error()); //(mysql_error());         if (mysql_num_rows($result) > 0)         {             echo"<table cellpadding=\"2\" cellspacing=\"2\" border=\"2\">";             while ($line = mysql_fetch_array($result, MYSQL_ASSOC))             {                 echo"<tr>";                 foreach ($line as $col_value)                 {                     echo"<td>$col_value</td>";                 }                 echo"</tr>";             }             echo"</table>";         }         else         {             echo"<p>There is no availability for these dates</p>";         }     } //this one and the one below it was missing, causeing the error. } ?>[/code] [/quote] Thanks, Will try this out tonight and hopefully have success - Thanks again

[!--quoteo(post=362415:date=Apr 6 2006, 09:11 PM:name=earl_dc10)--][div class=\'quotetop\']QUOTE(earl_dc10 @ Apr 6 2006, 09:11 PM) [snapback]362415[/snapback][/div][div class=\'quotemain\'][!--quotec--] it may be to the fact that you have 6 opening brackets, but only 4 closing ones [/quote] Thanks for that! I spotted the missing brackets when I went back working on the code and put them in but I'm still getting the same weird error. I've only started php and am likely to make silly mistakes - any more ideas on what could be wrong.

I am using the folowing code to search a db and bring back results but am getting the following error "Parse error: parse error, unexpected $ in C:\Program Files\xampp\htdocs\search-example2.php on line 47" but my code only has 45 lines in it - What am I doing wrong? [code]<?php require_once('Connections/xxx.php'); ?> <?php     if($_GET['action']=="xxxxxxxx")     {         $arrDate_day=$_POST['arrDate_day'];         $arrDate_mon=$_POST['arrDate_mon'];         $arrDate_year=$_POST['arrDate_year'];         $RoomType=$_POST['RoomType'];         $SmokingYesNo=$_POST['SmokingYesNo'];         $deptDate_day=$_POST['deptDate_day'];         $deptDate_mon=$_POST['deptDate_mon'];         $deptDate_year=$_POST['deptDate_year'];                  $arrivalday=$arrDate_year."-".$arrDate_mon."-".$arrDate_day;         $departuredate=$deptDate_year."-".$deptDate_mon."-".$deptDate_day;                  if($arrivalday >= $departuredate)     {         echo "<h2>Your arrival date cannot be greater than your departure date</h2>";              $query = "SELECT * FROM `room_desc_t` t LEFT JOIN `reservations_t` r WHERE t.room_type='{$RoomType}'     AND room_smoking='{$SmokingYesNo}' AND r.res_arrival_date >= '{$Arrival}' AND r.res_departure_date < '{$Departure}'";     $result = mysql_query($query) or die("Unable to execute query: ".mysql_error()); //(mysql_error());          if (mysql_num_rows($result) > 0)     {         echo"<table cellpadding=\"2\" cellspacing=\"2\" border=\"2\">";         while ($line = mysql_fetch_array($result, MYSQL_ASSOC))         {             echo"<tr>";             foreach ($line as $col_value)             {                 echo"<td>$col_value</td>";             }             echo"</tr>";         }         echo"</table>";     }     else     {         echo"<p>There is no availability for these dates</p>";     } ?>[/code]

Hi all I am trying to write a query which will search the database for whatever rooms are available on the dates selected (arrival and departure ) which involes querying different tables. I'm new to php and mysql and really struggling with this - The code below is my feeble attempt - Can you help $query = "SELECT room_number, room_description FROM room_desc_t, WHERE room_type = $RoomType, room_smoking = $SmokingYesNo, AND room_number NOT IN SELECT res_room_number from reservations_t " WHERE res_arrival_date <= $arrivalday, res_depart_date > $departuredate SELECT res_room_number from reservations_t WHERE res_arrival_date >= $arrivalday AND res_arrival_date < $departuredate" $result=mysql_query ($query) or die ("Unable to execute query: ".mysql_error()); //(mysql_error());

I'm new to php and having trouble writing an If statement (at least I think it should be an if statement)which would check whether the user has entered an invalid date for a month and display an error message like "there are only 28 says in February" or 30 days in April. I have been trying the code below which is not working if ($arrDate_mon = 2, $arrDate_day <28) { echo "<h2>There are only 28 days in February</h2>"