Barand

That is the reason we use forms rather then one big text area; so the order and type of information can be controlled.

We used to have a PC filter where I worked, so messages containing words like "tart" or "Scunthorpe" (town in UK) were flagged for moderation. The recipient was notified they had received a message with banned content and, after reviewing, an administrator might, or not, release the message.

As soon you see the words "For simplicity..." then you know this isn't a copy of the actual code being executed. Spending any time on what is posted is, therefore, just a waste of effort. Just my 0.02 worth.

CAUTION when add time periods to dates at the end of the month $dateToUse = '2015-01-31'; $plus1month = date('Y-m-d', strtotime("$dateToUse +1 months")); echo $plus1month; //--> 2015-03-03 !!! [edit] I don't know how sqlserver handles it but MySQL gives a more natural result mysql> SELECT '2015-01-30' + INTERVAL 1 MONTH; +---------------------------------+ | '2015-01-31' + INTERVAL 1 MONTH | +---------------------------------+ | 2015-02-28 | +---------------------------------+

I'm going to pass on that because when I run your code to build the array I get <select name="birthyear" class="date"> <option value="-2">Please choose</option> <option value="-1">N/A</option> <option value="1997">1997</option> <option value="1996">1996</option> <option value="1995">1995</option> <option value="1994">1994</option> <option value="1993">1993</option> <option value="1992">1992</option> <option value="1991">1991</option> <option value="1990">1990</option> <option value="1989">1989</option> <option value="1988">1988</option> <option value="1987">1987</option> <option value="1986">1986</option> <option value="1985">1985</option> <option value="1984">1984</option> <option value="1983">1983</option> <option value="1982">1982</option> <option value="1981">1981</option> <option value="1980">1980</option> <option value="1979">1979</option> <option value="1978">1978</option> <option value="1977">1977</option> <option value="1976">1976</option> <option value="1975">1975</option> <option value="1974">1974</option> <option value="1973">1973</option> <option value="1972">1972</option> <option value="1971">1971</option> <option value="1970">1970</option> <option value="1969">1969</option> <option value="1968">1968</option> <option value="1967">1967</option> <option value="1966">1966</option> <option value="1965">1965</option> <option value="1964">1964</option> <option value="1963">1963</option> <option value="1962">1962</option> <option value="1961">1961</option> <option value="1960">1960</option> <option value="1959">1959</option> <option value="1958">1958</option> <option value="1957">1957</option> <option value="1956">1956</option> <option value="1955">1955</option> <option value="1954">1954</option> <option value="1953">1953</option> <option value="1952">1952</option> <option value="1951">1951</option> <option value="1950">1950</option> <option value="1949">1949</option> <option value="1948">1948</option> <option value="1947">1947</option> <option value="1946">1946</option> <option value="1945">1945</option> <option value="1944">1944</option> <option value="1943">1943</option> <option value="1942">1942</option> <option value="1941">1941</option> </select> The code I used <?php define("_VARS_USER_CHOOSE_", -2); define("_VARS_USER_NONE_", -1); define("_VARS_USER_UNDEF_", 'N/A'); $vars['user-birthdate-years'] = array(_VARS_USER_CHOOSE_ => "Please choose", _VARS_USER_NONE_ => _VARS_USER_UNDEF_); for ($i = date('Y') - 18; $i > date('Y') - 75; --$i) { $vars['user-birthdate-years'][$i] = "$i"; } $opts = ''; foreach ($vars['user-birthdate-years'] as $k=>$yr) { $opts .= "<option value='$k'>$yr</option>\n"; } ?> <select name="birthyear" class="date"> <?=$opts?> </select>

When you write to your JS in PHP (on the server) you write whatever is in $year and $balance at the time. Later (on the client) the JS loops using those single values. You need an array of years and values. I would use AJAX from your JS to get a JSON array and then use that for the chart. BTW, I am getting many errors flagged regarding incorrect nesting of tags EG <p>Would you like to see the calculations? <a href="#" class="show_hide" rel="#slidingDiv"> Show Me</span></p> </a>

What happened to the code tags?

Show us the whole code, not isolated snippets, so we can see the logic flow. Use code tags or the <> button in the toolbar

Example of the above mysql> SELECT * FROM rate; +---------+------------+------------+--------+--------+-----------+ | rate_id | from_date | to_date | season | rate | wepremium | +---------+------------+------------+--------+--------+-----------+ | 1 | 2016-01-08 | 2016-02-28 | LOW | 100.00 | 25.00 | | 2 | 2016-02-29 | 2016-03-20 | MID | 110.00 | 25.00 | | 3 | 2016-03-21 | 2016-04-10 | EASTER | 150.00 | 50.00 | +---------+------------+------------+--------+--------+-----------+ mysql> SELECT * FROM booking_days; +------------+------------+ | booking_id | date | +------------+------------+ | 1234 | 2016-02-27 | | 1234 | 2016-02-28 | | 1234 | 2016-02-29 | | 1234 | 2016-03-01 | | 1234 | 2016-03-02 | | 1234 | 2016-03-03 | | 1234 | 2016-03-04 | | 1235 | 2016-03-19 | | 1235 | 2016-03-20 | | 1235 | 2016-03-21 | | 1235 | 2016-03-22 | | 1235 | 2016-03-23 | +------------+------------+ SELECT booking_id , DATE_FORMAT(date, '%a %D %b %Y') as date , season , SUM(r.rate + CASE WHEN DAYOFWEEK(b.date) IN (1,6,7) THEN r.wepremium ELSE 0 END) as price FROM booking_days b JOIN rate r ON b.date BETWEEN r.from_date and r.to_date GROUP BY booking_id, date WITH ROLLUP; +------------+-------------------+--------+---------+ | booking_id | date | season | price | +------------+-------------------+--------+---------+ | 1234 | Sat 27th Feb 2016 | LOW | 125.00 | | 1234 | Sun 28th Feb 2016 | LOW | 125.00 | | 1234 | Mon 29th Feb 2016 | MID | 110.00 | | 1234 | Tue 1st Mar 2016 | MID | 110.00 | | 1234 | Wed 2nd Mar 2016 | MID | 110.00 | | 1234 | Thu 3rd Mar 2016 | MID | 110.00 | | 1234 | Fri 4th Mar 2016 | MID | 135.00 | +------------+-------------------+--------+---------+ | 1234 | 825.00 | +------------+-------------------+--------+---------+ | 1235 | Sat 19th Mar 2016 | MID | 135.00 | | 1235 | Sun 20th Mar 2016 | MID | 135.00 | | 1235 | Mon 21st Mar 2016 | EASTER | 150.00 | | 1235 | Tue 22nd Mar 2016 | EASTER | 150.00 | | 1235 | Wed 23rd Mar 2016 | EASTER | 150.00 | +------------+-------------------+--------+---------+ | 1235 | 720.00 | +------------+-------------------+--------+---------+ | TOTAL | 1545.00 | +------------+-------------------+--------+---------+

I'd have a single table with contiguous dates and also include a column for midweek price and another for the additional weekend premium. Also, when making a booking I would generate a booking record for each day of the stay. Then it's easy to "JOIN ON booking.date BETWEEN price.startdate AND price.enddate" and pick up the rate, applying the premium for dates that fall on weekend

What happens for those days that fall between the dates in your season table, the date bands are not contiguous?

Those errors are because your query failed. Check mysql_error() to find why.

Read what the error message is telling you then look at the code on that line. It says the MySQL link resource is invalid here: $query0 = mysql_query("SELECT username FROM Users WHERE mxitid=$mid", $con); So why is it invalid? Look here: $conn = mysql_connect('*****','*******','*******') or trigger_error("SQL", E_USER_ERROR); Not difficult.

SNAP!

The array key should be "options" and not "option" $valYoB = array('options' => array('min_range' => 1900, 'max_range' => 2000));

Unexpected $end usually means you have a "{" somewhere without a corresponding "}". You also have some php code amongst your HTML without surrounding <?php..?> tags

you could do something like this $sevenDaysAgo = (new DateTime('-7 days'))->format('Ymd'); foreach($xml->gms->g as $games) { $eid= substr($games['eid'], 0, ; // get date part if ($eid < $sevenDaysAgo) continue; // skip and process next if(!empty($games['vtn'])) . . . . . . }

or skip the array and use xpath. Try $xml = simplexml_load_string($xmlstring); foreach ($xml->xpath('//device') as $dev) { echo "$dev->name state is $dev->state<br>"; }

The answer to my question in #11 above was "NO", not yes as you stated. You are only processing the final batch. Try something like this <?php $visitor = $_GET["visitor"]; $f_pointer=fopen($visitor,"r"); // file pointer $users = array(); while ($ar=fgetcsv($f_pointer)) { if ($ar[0] != '') $users[] = $ar[0]; //only store line in new array if it contains something } fclose ($f_pointer); $batchSize = 2; // set size of your batches $batches = array_chunk($users, $batchSize); require_once ('MxitAPI.php'); /* Instantiate the Mxit API */ $key = $_GET["key"]; $secret = $_GET["secret"]; $app = $_GET["app"]; $message = $_GET["message"]; $api = new MxitAPI($key, $secret); $api->get_app_token('message/send'); foreach ($batches as $batch) { $list = join(',', $batch); // process the batch list here $api->send_message($app, $list, $message, 'true'); } echo 'Success'; ?>

While your at it you may as well format it too in the SQL SELECT DATE_FORMAT(date + INTERVAL 2 HOUR, '%H:%i') as time, ...

Well if you replaced the whole of my code with yours then I cannot even know what it is doing now, let alone take any responsibility for it.

This will take your date field, add 2 hours and format as time $dt = new DateTime(mysql_result($result,$i,"Date")); $adjustedTime = $dt->add(new DateInterval('PT2H'))->format('H:i'); Don't use mysql_ functions, you will only have to rewrite them all soon when they disappear from PHP and you certainly should not be using mysql_result(). You should be using xxx_fetch_row() or xxx_fetch_assoc() as they are far more efficient

Your data table contains "period". Where is that coming from? How does the number you are entering into the fourth field relate to the Monday, Tuesday, ..., Saturday fields in the table? If it is day number to indicate the column, what value goes into the day column? What are you trying to achieve in the end?

Are you sending each batch of 50 where I indicated, inside the foreach() loop?