PHP - Need To Add Grouping In My Data Table

Hello,  I have a family website with an address book.  I have it set so that you can select people based on who's family they are part of.  So everyone in the family is part of my grandmother so when you select her group then everyone should display.  Then I have it so that when you select my aunt or uncle then it will display only their families and so forth.  so everyone except my grandmother has more than one family_id.  I have a master_id specific to each master_name, then each master_id can have up to 3 family_id's.  my issue is when I select all (my grandmother's group) i need it to group by my aunt's and uncle's families.  and right now it is just in order of how I entered it into the database.

My query selects all family_id's that = my $_POST[fam_id] from a dropdown list.  So when I select my grandmother's group it will only return family_id "1".  but i need to group by family_id 2-15, whichever is assigned to my aunt or uncle under my grandmother.  since the query does not ask for it obviously i cannot sort by it.  If I ask for everyone, grouped by family_id then I cannot select only by aunt or uncle as well.  i'm at a total loss.  please help.

Here is my basic query right now:

$sel_id= "SELECT master_id FROM master_family where family_id = '$_POST[fam_id]' ORDER BY master_id";

Please know this is my first website so I am very new to this and hope my question is not too lame.

hello friends 

I'm dealing with this problem for two days. I put here the screenshot for easier understanding.Sorry about my bad english.

Here is the ss

http://i61.tinypic.com/2rz5q55.jpg

I don't want to inner join or table join. All image links  which same sku should displayed in single row where products.resimler colon
I can join the tables but i want to one table.Because i can import single csv file for e-commerce script.How can I use a update query for list multiple images in table products.
Edited by nogai, 10 October 2014 - 07:01 AM.

Hey everyone,

I have a database for projects and each entry has one or more project type category that it falls into. The values are separated with a semi-colon to make the distinction. I've used the following code to output the data onto the page:

Code: [Select]
$sql = "SELECT project_type FROM projects ORDER BY project_type";
$result = mysql_query($sql);


while ($rs = mysql_fetch_array($result)) {
$database_value = $rs['project_type'];
$array = explode(';', $database_value);

foreach($array as $key => $value){
echo " ".$value."<br />"; 
}


}
This outputs the following:

Code: [Select]
Agriculture
Agriculture
Agriculture
Agriculture
Agriculture
Agriculture
Agriculture
Agriculture
Export Development
Agriculture
Impact Assessments
Impact Studies
Agriculture
M & E
Agriculture
Private Sector Development
Corporate and Public Governance
Corporate and Public Governance
Corporate and Public Governance
In PHP, how can I group these values together, similar to SQL's GROUP BY method? I've tried grouping it in the query but some of the data goes lost because it must be exploded first.

Can anybody help?


Thanks in advance!

Karen

Often in the very beginning of index.php, I will define a bunch of constants.  To make sure I can quickly identify them as being one of my defined constants, I will often include some sort of prefix.

define ('xzy_somecontant',123);
define ('xzy_anothercontant',321);

Sometimes I have a bunch of constants that are related;

define ('xzy_id_for_page1',123);
define ('xzy_id_for_page2',231);
define ('xzy_id_for_page3',312);

It would be nice to somehow group them into say "xzy_page_ids", and then access them by some index such as "page1" or "1" (or whatever makes sense for the given naming structure).   Is this possible?  Is there another defacto way of doing so such as a static class or something?   Thanks

Can someone tell me the best way to group elements in an XML file?

Code: [Select]
<item>
             <title>Event 1</title>
             <dc:date>2010-09-25T01:00:00+01:00</dc:date>
             <dc:date>2010-10-02T01:00:00+01:00</dc:date>
             <dc:date>2010-10-09T01:00:00+01:00</dc:date>
</item>

<item>
             <title>Event 2</title>
             <dc:date>2010-09-25T01:00:00+01:00</dc:date>
             <dc:date>2010-10-02T01:00:00+01:00</dc:date>
             <dc:date>2010-10-09T01:00:00+01:00</dc:date>
</item>
Above is an example of what im trying to do and below is what i want the output to be

Code: [Select]

   25th September 2010

                   Event 1
                   Event 2

   2nd October 2010

                    Event 1
                    Event 2


And so on, can anyone point me in the right direction on where to start looking to do something like this in PHP.

Thanks

Garry

Hello everyone,

Could be possible someone help me on this code please?

I need to group and sort $search_query. They are the keywords extracted from $_SERVER[HTTP_REFERER] (referer in the query).

Thank you in advance.


Code: [Select]
$query = ("SELECT referer, browser_ip, date, customers_id, counter, browser_id, browser_language FROM visitors WHERE SUBSTRING(browser_language,1,1) != '[' ORDER by date DESC");
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {

$referer = $row[0];
IF($referer)
{
    PREG_MATCH("/[\&\?]q=([^&]*)/", $referer, $matches);
        $search_query = RAWURLDECODE($matches[1]);
        $search_query = STR_REPLACE("+", " ", $search_query);
}

........................

Hello all,

Need a little help with grouping and summing using an array. I can't do this directly from the database because the vendor package we are using (Tivoli Data Warehouse) stores date in a proprietary format as a CHAR in the database and in GMT so I have to get the data first and then manipulate the date to get it human readable and in the right EST date.

I have my query (and my date conversion) from the database returning the data in a format that looks like this:

The reason each date has the service repeated is because it was selected from the database by hour (needed to convert Tivoli's weird timestamp and use of GMT)

Service TX_Count Date
-------------------------------------------------------------------------------------------
Service1 23451 2010-01-01
Service1 93874 2010-01-01
Service1 82363 2010-01-01
Service1 56245 2010-01-02
Service1 73453 2010-01-02
Service1 18965 2010-01-02

I have successfully gotten the data in to an array and I can group by date and then sum the tx_count, or I can group the services and sum the tx_count.

What I really need to be able to do is to get the transaction counts by service by day so that I would get something like this as a result

Service1 2010-01-01 199688
Service1 2010-01-02 148663

So I need to group by service and then date and then sum it all out of the array.

Any advice and direction is appreciated

I have multiple arrays containing data for each entry.

What I am trying to do is group each item in the array by the date which is also in an array.

Where do I start??

Code: [Select]
array
  'pubDate' => string 'Mon, 15 Feb 10 00:00:00 +0000' (length=29)
  'title' =>
    object(SimpleXMLElement)[6]
  'description' =>
    object(SimpleXMLElement)[7]
  'guid' => string 'http://www.dailyinfo.co.uk/events.php?colname=Events&period=7&eventday=25&eventmonth=9&eventyear=2010#72741' (length=107)
  'link' => string 'http://www.dailyinfo.co.uk/events.php?colname=Events&period=7&eventday=25&eventmonth=9&eventyear=2010#72741' (length=107)

array
  'date' =>
    array
      0 => string '2010-09-25T01:00:00+01:00' (length=25)
      1 => string '2010-10-02T01:00:00+01:00' (length=25)

-------------------------------------------------------------------------------------------------------------------

array
  'pubDate' => string 'Fri, 26 Feb 10 00:00:00 +0000' (length=29)
  'title' =>
    object(SimpleXMLElement)[5]
  'description' =>
    object(SimpleXMLElement)[8]
  'guid' => string 'http://www.dailyinfo.co.uk/events.php?colname=Events&period=7&eventday=1&eventmonth=10&eventyear=2010#73266' (length=107)
  'link' => string 'http://www.dailyinfo.co.uk/events.php?colname=Events&period=7&eventday=1&eventmonth=10&eventyear=2010#73266' (length=107)

array
  'date' =>
    array
      0 => string '2010-09-25T01:00:00+01:00' (length=25)
      1 => string '2010-09-30T01:00:00+01:00' (length=25)

-------------------------------------------------------------------------------------------------------------------

hi, i have a field for price that gets returned.

is there a way to do ORDER BY 'category' so that i can have tally at the bottom of each category that adds all the prices together?

Hello,   I was wondering if maybe someone could help me on this. I am having trouble with this query. I need to send an email to the users but group all the records related to that user instead of sending one email per record to the user. I hope this makes sense. Here is the code I have so far. All records are being displayed but how can I get all the records for each user (infant_specialist field) send one email and then go to the next user and send the other email and so on.   Thank you for your help

$conn = mysqli_connect('localhost','root','','dbname');

$sql = "SELECT case_no, client_name, infant_specialist.full_name, infant_specialist.is_email FROM ies_clients INNER JOIN infant_specialist ON ies_clients.infant_specialist = infant_specialist.is_id WHERE (date_closed IS NULL OR date_closed >=  DATE_FORMAT(NOW() ,'%Y-%m-01')) ORDER BY client_name ASC";
$q = mysqli_query($conn,$sql);

//echo mysqli_num_rows($q) . '<br/>';

while($row = mysqli_fetch_array($q) ){
	
	echo $row['client_name'] . ' --- ' , $row['full_name'] . ' --- ' . $row['is_email'] . '<br/>';
}

Edited by stivenbr, 07 October 2014 - 02:05 PM.

Hi everyone.
I need to display a list of departments and a total of occurrences of each department in mysql/php.
eg.
There are 3 Administration types.
There are 5 Government types.
etc.
there is no error when i run the code below, but nothing displays happens either. i'd appreciate anyone's help. Thanks.

Code: [Select]
<?php
$query = mysql_query("SELECT CompanyName, CompanyBranch, DateRecorded, DateClosed, Year(DateRecorded) AS Year, CaseOwner.UsersDepartment
FROM records LEFT JOIN CaseOwner ON CaseOwner = CaseOwner.ProperName
GROUP BY CompanyName, CompanyBranch, DateRecorded, DateClosed, CaseOwner.UsersDepartment
ORDER BY CaseOwner.UsersDepartment") or die("SELECT Error: ".mysql_error());
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(CaseOwner.UsersDepartment)'] ." ". $row['CaseOwner.UsersDepartment'] ." types.";
echo "<br />";
}
?>

I was wondering if this is possible. I have a list of criteria each with their own checkboxes, and I want to query a database when one or more of the checkboxes is submitted. So if 3 are checked, I want to query the database to find those 3 items. If one only is checked, I want to query the dataabse for one item.

any ideas greatly appreciated thank you.

this is basically a criteria based search

I'm trying to dynamically group a range of rows using PHPSpreadsheet and having a lot of trouble thinking through the logic. My code so far looks like this:

$worksheet = $spreadsheet->getActiveSheet();
// Get the highest row number and column letter referenced in the worksheet
$highestRow = $worksheet->getHighestRow(); // e.g. 10
$highestColumn = $worksheet->getHighestColumn(); // e.g 'F'
// Increment the highest column letter
$highestColumn++;

$job_num_chk = '';
$grp_start_row = '';

//format the inserted records
for ($row = 2; $row <= $highestRow; ++$row) {
	//$spreadsheet->getActiveSheet()->getRowDimension($row)->setRowHeight(53);
	for ($col = 'A'; $col != $highestColumn; ++$col) {
		
		$spreadsheet->getActiveSheet()->getStyle($col . $row)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
		$spreadsheet->getActiveSheet()->getStyle($col . $row)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT);
		
		if ($col == 'B') {
			$cur_job_num = $spreadsheet->getActiveSheet()->getCell($col . $row)->getValue(); //get current job number
			
			//check if job number is different
			if ( $job_num_chk !== $cur_job_num ) {
				$spreadsheet->getActiveSheet()->insertNewRowBefore($row, 1); //insert dividing row
				
				//set dividing row to black
				$spreadsheet->getActiveSheet()->getStyle('A'.$row.':N'.$row)->getFill()
					->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
					->getStartColor()->setARGB('000000');
				
				$job_num_chk = $cur_job_num; //update job number
			}
			
		}

	}
	
}

This line: 

$grp_start_row = '';

Is where I'm hitting a mental wall...here's what the spreadsheet looks like so far:

I want to be able to group the rows 101-105 in that example like below:

I need to be able to determine where the start row is and the end row is in order to use the grouping feature (https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#groupoutline-a-row)

Thanks everyone.

i have list of movies A to Z in array i can do simple sort but i want them to sort in grouping like this
A
[movie name],
[movie name],
[movie name],
[movie name],

B
[movie name]
[movie name]
[movie name]
[movie name]
[movie name]

C
[movie name]
[movie name]
[movie name]
[movie name]

D
[movie name]
[movie name]
[movie name]
[movie name]

and go on

all movies name will be links but A,B,C,D will be remain simple
how can i do this
i wanna show list like this see this website
please visit
http://mp3hungama.com/music/genre_albums.php?id=3

thanks

I'm using smarty and php to collect parameters from a user defined tag in cmsms that looks like this... 

Code: [Select]
{schedule date="2010-11-13" time="7:05 p.m." location="Evansville" home="Oakland City" vs="Evansville" winner="University of Evansville" results="82-42"}

{schedule date="2010-11-15" time="7:00 p.m." location="Oakland City" home="Oakland City" vs="OSU-Lima" winner="OSU-Lima" results="68-67 2OT"}
etc...

As you can see each {schedule tag above has the same home="" value.  Thats because its schedule dates just for THAT team (i.e. Oakland City).  So I may have 10 of these tags on the same page.  But I also have other places where the schedule tag is used with a different $home name for another team.  So basically I'm calling ALL these schedule tags into one for loop like this...


Code: [Select]
for ($i=0; $i < count($params['date']); $i++) {
    $date= $params['date'];
    $time=$params['time'];
    $location= $params['location'];
    $home= $params['home'];
    $vs= $params['vs'];
    $winner= $params['winner'];
    $results= $params['results'];
    $gameinfo = array("date", "time","location","home","vs","winner","results");
    $game_info = compact($gameinfo);   

}

All I want to do is spit back out the total wins for each $home team.  I am pulling out my hair out trying to get this thing to work but no luck yet, even though I see a little light. This is what I got so far...

Code: [Select]
for ($i=0; $i < count($params['date']); $i++) {
    $date= $params['date'];
    $time=$params['time'];
    $location= $params['location'];
    $home= $params['home'];
    $vs= $params['vs'];
    $winner= $params['winner'];
    $results= $params['results'];
    $gameinfo = array("date", "time","location","home","vs","winner","results");
    $game_info = compact($gameinfo);   

  if($home == $winner) {
    $wins = array('team' => $winner, 'win' => count($winner));
  }

}

 $smarty->append('mwins',$wins);

print '<pre>';
print_r($wins);
print '</pre>';


and I get this...

Code: [Select]
Array
(
    [0] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [1] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [2] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [3] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [4] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [5] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [6] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [7] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [8] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [9] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [10] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [11] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [12] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [13] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [14] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [15] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [16] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [17] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [18] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [19] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [20] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [21] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [22] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [23] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [24] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [25] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [26] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [27] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [28] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [29] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [30] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [31] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [32] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [33] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [34] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [35] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [36] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [37] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

etc...


I want to take all the [win] values for each [team] and add them up this way my final array looks like this...

Code: [Select]

Array
(
    [0] => Array
        (
            [team] => Oakland City
            [win] => 18
        )

    [1] => Array
        (
            [team] => Southern Indiana
            [win] => 24
        )


I know I'm so close but don't know how to solve the condition I need. Any suggestions would be great!!!

bh