Barand

$a[2014][123456]['EMPS']=114350; $b[2014][60]['EMPS']=1470; $c = $a; foreach ($b as $y => $ydata) { foreach ($ydata as $k => $v) { $c[$y][$k] = $v; } } echo '<pre>',print_r($c, true),'</pre>'; /* RESULT Array ( [2014] => Array ( [123456] => Array ( [EMPS] => 114350 ) [60] => Array ( [EMPS] => 1470 ) ) ) */

Are you sure those are the correct columns for your join?

Yes, I know. But there is no way that I can I help with that one line of code quoted out of context. The code was tested before posting. BTW, the recursive code I just posted is not the same as that posted earlier in this thread.

It's just the same problem in reverse. If you use the query method, reverse the fields in the joins $sql = "SELECT r.id , r.acct_name , r.ref_id , r1.acct_name as first , r2.acct_name as second , r3.acct_name as third , r4.acct_name as fourth FROM test_referral r LEFT JOIN test_referral r1 ON r1.refer_id = r.ref_id LEFT JOIN test_referral r2 ON r2.refer_id = r1.ref_id LEFT JOIN test_referral r3 ON r3.refer_id = r2.ref_id LEFT JOIN test_referral r4 ON r4.refer_id = r3.ref_id WHERE r.acct_name = 'john' ORDER by id"; +----+-----------+--------+-------+---------+-------+--------+ | id | acct_name | ref_id | first | second | third | fourth | +----+-----------+--------+-------+---------+-------+--------+ | 1 | john | J1234 | frank | tommy | NULL | NULL | | 1 | john | J1234 | doe | girly | NULL | NULL | | 1 | john | J1234 | bull | ronaldo | NULL | NULL | | 1 | john | J1234 | jimmy | kim | henry | fred | | 1 | john | J1234 | frank | tom | NULL | NULL | +----+-----------+--------+-------+---------+-------+--------+ Or if you want to go to any depth, use the recursion method $sql = "SELECT id , acct_name , ref_id , refer_id FROM test_referral"; $data = array(); $res = $mysqli->query($sql); while ($row = $res->fetch_assoc()) { $names[$row['ref_id']] = $row['acct_name']; $data[$row['refer_id']][] = $row['ref_id']; } $id = 'J1234'; getRefs($data, $names, $id); // // recursive function to get list of referrees // function getRefs(&$data, &$names, $id, $level=0) { $indent = str_repeat('--- ', $level); echo "$indent {$names[$id]}<br>"; if (isset($data[$id])) { foreach ($data[$id] as $refid) { getRefs($data, $names, $refid, $level+1); } } } /// OUTPUTS ////////////////////// john --- bull --- --- ronaldo --- doe --- --- girly --- frank --- --- tommy --- --- tom --- jimmy --- --- kim --- --- --- henry --- --- --- --- fred

use exit instead of break

These are my results mysql> select * from test_referral; +----+-----------+--------+----------+ | id | acct_name | ref_id | refer_id | +----+-----------+--------+----------+ | 1 | john | J1234 | 0 | | 2 | bull | B3456 | J1234 | | 3 | doe | D5567 | J1234 | | 4 | frank | F7788 | J1234 | | 5 | jimmy | J9990 | J1234 | | 6 | tommy | T6784 | F7788 | | 7 | tom | T9988 | F7788 | | 8 | girly | G8866 | D5567 | | 9 | fred | F0099 | H7654 | | 10 | ronaldo | R7722 | B3456 | | 11 | henry | H7654 | K1234 | | 12 | kim | K1234 | J9990 | +----+-----------+--------+----------+ SELECT r.id , r.acct_name , r.ref_id , r1.acct_name as first , r2.acct_name as second , r3.acct_name as third , r4.acct_name as fourth FROM test_referral r LEFT JOIN test_referral r1 ON r.refer_id = r1.ref_id LEFT JOIN test_referral r2 ON r1.refer_id = r2.ref_id LEFT JOIN test_referral r3 ON r2.refer_id = r3.ref_id LEFT JOIN test_referral r4 ON r3.refer_id = r4.ref_id WHERE r.acct_name = 'fred' ORDER by id; +----+-----------+--------+-------+--------+-------+--------+ | id | acct_name | ref_id | first | second | third | fourth | +----+-----------+--------+-------+--------+-------+--------+ | 9 | fred | F0099 | henry | kim | jimmy | john | +----+-----------+--------+-------+--------+-------+--------+

Add a TIMESTAMP type column and ORDER BY that.

I have run your query against the test_referral table that you provided (after adding adding a couple of extra referrals to give a chain of 4 names) and it works fine. I can only assume the problem is when you run it against your ca_categories table, which I cannot help with.

If you are after the id of the record just inserted into movimiento, use mysql_insert_id() http://php.net/manual/en/function.mysql-insert-id.php

To get the values automatically you close your eyes and make a wish. However, as this seldom works, you have to write the code. Why are you looping 3 times through the same array? $maxshipping1=$maxshipping2=$maxqty=0; foreach ($_SESSION['products'] as $prod) { $maxshipping1 = max($maxshipping1, $prod['shipping1']); $maxshipping2 = max($maxshipping2, $prod['shipping2']); $maxqty = max($maxqty, $prod['qty']); if ($prod['qty'] >= 2) { echo $prod['product'] . '<br>'; echo "Ship1: " . $prod["shipping1"] . '<br>'; echo "Ship2: " . $prod["shipping2"] . '<br><br>'; } }

With a left join, cust_fname and cust_number will be NULL where there is no customer record matching the site record

$sql = "SELECT firstname, lastname FROM Players WHERE Username = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param('s', $username); $stmt->execute(); // either $stmt->bind_result($firstname, $lastname); $stmt->fetch(); echo $firstname . ' ' . $lastname; // or $res = $stmt->get_result(); $row = $res->fetch_assoc(); echo $res['firstname'] . ' ' . $row['lastname'];

try $maxshipping=0; foreach ($_SESSION['products'] as $prod) { $maxshipping = max($maxshipping, $prod['shipping1']); } echo $maxshipping;

the code is OK so either item_id is not 22 code is not executed

Don't run queries in loops. To do this use a recursive function on your data stored in an array. This code will store your data in the array $data. $data[ref_id][referrers] will be an array of the chain of referrers for each user. EG Array ( [J1234] => Array ( [acct_name] => john [refer_id] => 0 [referrers] => Array ( ) ) [B3456] => Array ( [acct_name] => bull [refer_id] => J1234 [referrers] => Array ( [0] => J1234 ) ) [D5567] => Array ( [acct_name] => doe [refer_id] => J1234 [referrers] => Array ( [0] => J1234 ) ) [F7788] => Array ( [acct_name] => frank [refer_id] => J1234 [referrers] => Array ( [0] => J1234 ) ) [J9990] => Array ( [acct_name] => jimmy [refer_id] => J1234 [referrers] => Array ( [0] => J1234 ) ) [T6784] => Array ( [acct_name] => tommy [refer_id] => F7788 [referrers] => Array ( [0] => F7788 [1] => J1234 ) ) [T9988] => Array ( [acct_name] => tom [refer_id] => F7788 [referrers] => Array ( [0] => F7788 [1] => J1234 ) ) [G8866] => Array ( [acct_name] => girly [refer_id] => D5567 [referrers] => Array ( [0] => D5567 [1] => J1234 ) ) [F0099] => Array ( [acct_name] => fred [refer_id] => J9990 [referrers] => Array ( [0] => J9990 [1] => J1234 ) ) [R7722] => Array ( [acct_name] => ronaldo [refer_id] => B3456 [referrers] => Array ( [0] => B3456 [1] => J1234 ) ) ) the code $sql = "SELECT id , acct_name , ref_id , refer_id FROM test_referral"; $data = array(); $res = $mysqli->query($sql); while ($row = $res->fetch_assoc()) { $data[$row['ref_id']] = array( 'acct_name' => $row['acct_name'], 'refer_id' => $row['refer_id'], 'referrers' => array() ); } foreach ($data as $id => $user) { getRef($data, $data[$id]['refer_id'], $id); } // // recursive function to get list of referrers // function getRef(&$data, $id, $startid) { if ($id=='0') return; $data[$startid]['referrers'][] = $id; getRef($data, $data[$id]['refer_id'] ,$startid); } That will work for any depth of referrals. Where you have a fixed depth then you can use a query with a couple of left joins SELECT r.id , r.acct_name , r.ref_id , r1.ref_id as first , r2.ref_id as second FROM test_referral r LEFT JOIN test_referral r1 ON r.refer_id = r1.ref_id LEFT JOIN test_referral r2 ON r1.refer_id = r2.ref_id; +----+-----------+--------+-------+--------+ | id | acct_name | ref_id | first | second | +----+-----------+--------+-------+--------+ | 1 | john | J1234 | | | | 2 | bull | B3456 | J1234 | | | 3 | doe | D5567 | J1234 | | | 4 | frank | F7788 | J1234 | | | 5 | jimmy | J9990 | J1234 | | | 6 | tommy | T6784 | F7788 | J1234 | | 7 | tom | T9988 | F7788 | J1234 | | 8 | girly | G8866 | D5567 | J1234 | | 9 | fred | F0099 | J9990 | J1234 | | 10 | ronaldo | R7722 | B3456 | J1234 | +----+-----------+--------+-------+--------+

By default, when you sort an array of arrays, the arrays are sorted on the first element. So you could put the distance at the start of each array and then just sort(). $results = [ [5, 'abc', 'defg'], [8, 'def', 'efg'], [12, 'ghj', 'fghij'], [10, 'klm', 'ghijk'], [8, 'nop', 'lmn'], ]; sort($results); echo '<pre>SORTED ',print_r($results, true),'</pre>'; gives SORTED Array ( [0] => Array ( [0] => 5 [1] => abc [2] => defg ) [1] => Array ( [0] => 8 [1] => def [2] => efg ) [2] => Array ( [0] => 8 [1] => nop [2] => lmn ) [3] => Array ( [0] => 10 [1] => klm [2] => ghijk ) [4] => Array ( [0] => 12 [1] => ghj [2] => fghij ) )

Or you could sidestep the problems and not allow any dates after the 28th of any month edit : If the recurring value is monthly or higher

You could add COUNT(DISTINCT l.likes_username) as userCount to the select clause

Does this help? SELECT trans_ref , acct_num , payee , company , acct_no , amt , purpose , recurring , due_date , CASE recurring WHEN 'weekly' THEN due_date + INTERVAL 7 DAY WHEN 'bi-weekly' THEN due_date + INTERVAL 14 DAY WHEN 'monthly' THEN due_date + INTERVAL 1 MONTH WHEN 'quarterly' THEN due_date + INTERVAL 3 MONTH WHEN 'half-yearly' THEN due_date + INTERVAL 6 MONTH WHEN 'yearly' THEN due_date + INTERVAL 1 YEAR END as next_due , status , pay_status FROM $tbl_name ORDER BY trans_id DESC LIMIT $start, $limit And throw away that useless first query.

I really don't know whether to laugh or cry when I read your code. You are supposed to incorporate the CASE statement that Kicken gave you into your query so you calculate the next_due for every row.

Then you are processing the results incorrectly mysql> SELECT recurring, due_date, -> CASE recurring -> WHEN 'weekly' THEN due_date + INTERVAL 7 DAY -> WHEN 'bi-weekly' THEN due_date + INTERVAL 14 DAY -> WHEN 'monthly' THEN due_date + INTERVAL 1 MONTH -> WHEN 'quarterly' THEN due_date + INTERVAL 3 MONTH -> WHEN 'half-yearly' THEN due_date + INTERVAL 6 MONTH -> WHEN 'yearly' THEN due_date + INTERVAL 1 YEAR -> END as next_due -> FROM tblchidi; +-----------+------------+------------+ | recurring | due_date | next_due | +-----------+------------+------------+ | monthly | 2014-12-25 | 2015-01-25 | | Bi-Weekly | 2014-12-10 | 2014-12-24 | | yearly | 2014-12-20 | 2015-12-20 | | quarterly | 2014-12-24 | 2015-03-24 | +-----------+------------+------------+

You should notice that my code uses mysqli (as you should, or PDO) Instead of : mysql_select_db($database_conexxion, $conexxion); use this to create a mysqli connection: $mysqli = new mysqli (host, username, password, databasename); using your credentials.

Create a table "whatever" (where whatever is a meaningful name for the data) and load the data into it. Once it is in a table you can manipulate further if required. CREATE TABLE `whatever` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(255) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `cname` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) With the exception of the single quotes instead of double quotes, each line looks as though it is json encoded, so you could loop through each line, decode and insert into the table.

What are the relationships between the entities represented by each line and those contained within each line?

Strange you got no results. I ran the code against your data and got this (I reversed the order of the column heads)