Barand

After the mysqli_query line, add if (!$res) echo $con->error; That should tell you why.

IDs have to be unique within a document. If you have multiple objects, use classname instead.

here's mine, with the data you sent weirdsort.php

how's this? usort($data, function($a,$b) { list($a1,$a2,$a3) = splitParts($a); list($b1,$b2,$b3) = splitParts($b); $x = strcmp($a1,$b1); if ($x == 0) { $y = $b2 - $a2; if ($y == 0) { return $b3 - $a3; } return $y; } return $x; }); function splitParts($s) { $k = strlen($s); $a = ['','','']; $i = 0; $p = 0; while ($i < $k) { $c = $s[$i++]; if (ctype_digit($c) && $p==0) $p = 1; if ($c=='-') { $c = $s[$i++]; ++$p; } $a[$p] .= $c; } return $a; }

Thanks, saves a lot of editing Now which bits are ascending and which are descending in the required sort?

More generalized case $x=1; $y=111; $z = $x + $y/pow(10,strlen($y));

As this is a math help forum $x=1; $y=1; $z = $x + $y/10; echo $z;

Post the array again using the output from var_export($array); That gives us processable code. AAA XXXX YYYY - which bits are ASC and which bits DESC?

I copied your extra ")" if ($values['Workings1'] == "F") { $values['ExpiryDate'] = $values['Workings2']; } else if ($values['Workings1'] == "D") { $dateObj = new DateTime($values['IssueDate']); $dateObj->modify("+{$values['Workings3']} days"); $values['ExpiryDate'] = $dateObj->format('Y-m-d'); }

try if ($values['Workings1'] == "F") { $values['ExpiryDate'] = $values['Workings2']; } else if ($values['Workings1'] == "D") { $dateObj = new DateTime($values['IssueDate']); $dateObj->modify("+{$values['Workings3']}) days"); $values['ExpiryDate'] = $dateObj->format('Y-m-d'); }

What is your code where you create $values['IssueDate'] ?

Sounds like you you have "modified_date" column in both tables. You have to specify which one to use order_history.modified_date or research_queue.modified_date

What is the code where you (try to) create the object that is being cloned?

"clone" doesn't use parentheses. EG $copy = clone $obj;

By applying some thought to the problem and coming up with a logical sequence of events.

The trick is to organize your code so that you collect the error messages before you do the print.

Do you expect to see something when you print the contents of an empty array?

OK, so you create an empty array print each value in this empty array put an item into the array So what error are you getting? What are you expecting that isn't happening? What is happening that you don't expect? Give me a clue!

Use your table of member payments so you know which ones have been paid and when.

Then you may be doing something wrong.

Change line 8 to $Privilege = ""; At the moment $Privilege is defined inside a whilef() condition. If the condition is false (no records) then it is not defined.

foreach() loop

What you are now asking for is not what you originally asked for. I am not getting involved in an ever-escalating spiral of requirements (Not for free anyway). Hint: make "Africa/Abidjan" the key of the returned array and "[uTC/GMT +00:00] Africa/Abidjan" the value then build your options using both.

Create a dateTime object for each timezone. Format the time with 'P' format. class Time_zone { private $regions = array( 'Africa' => DateTimeZone::AFRICA, 'America' => DateTimeZone::AMERICA, 'Antarctica' => DateTimeZone::ANTARCTICA, 'Artic' => DateTimeZone::ARCTIC, 'Asia' => DateTimeZone::ASIA, 'Atlantic' => DateTimeZone::ATLANTIC, 'Australia' => DateTimeZone::AUSTRALIA, 'Europe' => DateTimeZone::EUROPE, 'Indian' => DateTimeZone::INDIAN, 'Pacific' => DateTimeZone::PACIFIC ); public function generate_list() { $time_zones = array(); foreach ($this->regions as $name => $mask) { $time_zones[$name] = DateTimeZone::listIdentifiers($mask); } foreach ($time_zones as &$zones) { foreach ($zones as &$zstr) { $zn = new DateTimeZone($zstr); $t = new DateTime('now', $zn); $offset = $t->format('P'); $zstr = "[UTC/GMT $offset] $zstr"; } } return $time_zones; } }