mysql - PHP opening times & embassy holidays -

-

i've been using code:

 $rawsql = "select  *      _erc_foffices n  inner join      _erc_openings o on n.id = o.branch_id , o.dotw = dayofweek(current_date())  inner join      _erc_openings_times t on o.id = t.opening_id  (     unix_timestamp(current_timestamp()) between unix_timestamp(concat(current_date(), ' ', t.open)) , unix_timestamp(concat(current_date(), ' ', t.close))  )  ,  (     n.id = %d ) ;";  $sql = sprintf($rawsql, mysql_real_escape_string($id));  $result = mysql_query($sql);  /*these if & while statements decide whether or not information should displayed. if no results returned query above alternative message shown.*/  if(mysql_num_rows($result) > 0) {     while ($row = mysql_fetch_array($result, mysql_assoc)) {          echo "<div class='address'><p>" . $row["title"] . "<br/>";         echo $row["address_1"] . "<br/> " . $row["address_2"] . "<br/> " . $row["address_3"] . "<br/> " . $row["address_4"] . "<br/> " . $row["address_5"] . "</p>";         echo "<div class='buttons'><img src='http://localhost/erc/images/texttouser_button.png'/><br/><a href='" . $row["url"] . "' target='blank'><img src='http://localhost/erc/images/website_button.png'/></a></div></div>";         echo "<div class='email'>" . $row["email"] . "</div>";         $extra_notes = $row["extra"];      } } else {          $embassy_closed = mysql_query("select * _erc_foffices id = '$embassy_id'");          while($row = mysql_fetch_array($embassy_closed))                       {          echo "<div class='address'><p>" . $row["title"] . "<br/>";         echo $row["address_1"] . "<br/> " . $row["address_2"] . "<br/> " . $row["address_3"] . "<br/> " . $row["address_4"] . "<br/> " . $row["address_5"] . " <font color='red'>the embassy closed.</font></p>";         echo "<div class='buttons'><img src='http://localhost/erc/images/texttouser_button.png'/><br/><a href='" . $row["url"] . "' target='blank'><img src='http://localhost/erc/images/website_button.png'/></a></div></div>";         echo "<div class='email'>" . $row["email"] . "</div>";         $extra_notes = $row["extra"];                         }   }

which takes opening times embassies database , decides whether or not embassy open. if it's not, message saying 'the embassy closed' shown. need add in public holidays, have altered query this:

    $rawsql = "select      *              _erc_foffices n      inner join          _erc_openings o on n.id = o.branch_id , o.dotw = dayofweek(current_date())      inner join          _erc_openings_times t on o.id = t.opening_id         left join      _erc_holidays h on h.branch_id = n.id          (         unix_timestamp(current_timestamp()) between unix_timestamp(concat(current_date(), ' ', t.open)) , unix_timestamp(concat(current_date(), ' ', t.close))      )      ,      (         n.id = %d     )         , (     unix_timestamp(current_timestamp())      not between unix_timestamp(h.begins_at) , unix_timestamp(h.ends_at) )         ;";

but outputs address/email etc twice.

could point out i'm doing wrong please?

thanks help

edit: have fixed now, used 2nd query , if/else loop.

i wouldn't profess expert , joins complicated, in experience if you're getting duplicates in query haven't grouped , can't see group @ in query.

hope helps.

by way... did source public holiday data? i'm looking exact same thing @ moment how came across post.


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more