PHP - Configure User / Group Of Vhost In Webmin

Hi all, does anyone know how to perform this, or if it's even possible? I need every 6th row to be a GROUP BY of the following 5 rows, they all share a common group_id so that's what the GROUP BY is performed on.

1. GROUP BY group_id
2. item #1
3. item #2
4. item #3
5. item #4
6. item #5
7. GROUP BY group_id
8. item #6
... and so on

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306114.0

Hi

Just a quick one.

I want my output result to look like this. In its simplistic form I have 2 columns, NAME and NUMBER.

Adam
1
2
3

Becky
1
2
3

Charlie
1
2
3


So the output results are grouped by the "name" field, then ordered by the "number" field.

I thought it was GROUP BY, but that function is something else.

Iv tried searching around but im unsure what you call this form of grouping results.

Many Thanks!

Hi,

Cut down code

SELECT count(number) FROM table GROUP BY title

echo $title .'<br>'. $number;



That outputs

Code: [Select]
Title1
5

Title2
9

Title3
2

But what do i do if i wanted to retain and loop through the "$number" actual values, not JUST count the total? I still need access to what "$number" is while looping. But as GROUP BY returns one result.. im stuck.

Ideally i want this as the resulting output

Code: [Select]
title1 // grouped title
3   // total number of $numbers per grouped title
1234
12345
123456  // The actual values of $number totalling to the above grouped number

title2 // grouped title
2   // total number of $numbers
1234
123456  // The actual values of $number totalling to the above grouped number

im trying to pull the information for a post which is to include 3 db tables(posts, users, attachments)

Ive tried the following code:

Code: [Select]
$query = $link->query("SELECT
            p.*,
            u.u_username, u.u_posts, u.u_avatar,
            u.u_signature, u.u_avatar_cropped,
            group_concat(a.a_name, a.a_size, a.a_date_posted separator '<br />') attachments
            FROM ".TBL_PREFIX."posts as p
            JOIN ".TBL_PREFIX."users as u
            ON (u.u_username = p.p_poster)
            LEFT JOIN ".TBL_PREFIX."post_attachments as a
            USING (".TBL_PREFIX."posts.p_pid)
            WHERE p.p_tid = '$tid'
            GROUP BY p.p_pid
            ORDER BY p.p_time_posted ASC")or die(print_link_error());


but that generates the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.p_pid)
         WHERE p.p_tid = '158'
         GROUP BY p.p_pid
         ORDER BY p.p_time_pos' at line 10"

All i am trying to do is pull everything from posts, join users and select all attachments that belong to the post.
Here is my database setup(shortened)

asf_posts
p_pid | p_name | p_poster
  1            test    doddsey65

asf_users
u_uid | u_username
  1        doddsey65

asf_attachments
a_aid | a_pid | a_name
  1            1      name

can anyone help?

G'day to all,

I need some help building a site that has the ability to accept members and deposit those members in a database.

When the members join they will have the ability to add features to their profile; like, skills and certificates. Upload pictures of certificates and a profile pic.

The admin area needs to have the ability to add membership types and give those members specific abilities.

The admin also needs to have the ability to create profile options, like additional skills.

Like a type 1 member has the ability search and see all type 2 members who have a particular skill set.

type 2 members just get to see their own profile and the tasks the type 1 members list.

 

This all might sound like a bunch of brambles but please let me know if you are interested and we can get more involved.

Thank you so very much for your help in advanced...

Juan

Hi    I am reading in data from a csv file

if (($handle = fopen("data.csv", "r")) !== FALSE) {

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

echo "User Name: $data[0]";
echo "Booking IDs: $data[1]";

}

echo "<hr>";

The problem is some of the usernames are duplicated so get outputted the same user name 20 times but with different IDs, obviously but I am unsure how to group them together.    I can't seem to figure out how to write if the next username is the same as current then just add another ID not go through the entire loop.    Any ideas?   Thanks  

Hi All,

I hope i'm posting in the right place but also hope someone can help!

I've got the following code:

            <?php
			$variations = $product->get_available_variations();
            if ($variations):
                ?>
                <div class="table-responsive">
                    <table class="table table-striped">
                        <tbody> 
                        <?php foreach ($variations as $key => $value) : ?>
                            <tr>
                                <td><?php echo $value['sku']; ?> <?php echo $value['variation_id']; ?></td>

                                <?php foreach ($value['attributes'] as $attrKey => $attr) :
                                    $tax = str_replace('attribute_', '', $attrKey);							
                                    $term_obj = get_term_by('slug', $attr, $tax); ?>
                                    <td><?php echo $term_obj->name;  ?></td>                             
                                    
                                <?php endforeach; ?>
                            </tr>

                        <?php endforeach; #$variations?>
                        </tbody>
                    </table>
                </div><!-- /table-responsive -->
            <?php endif; #$variations ?>

This produces the following table:

Product code System Pack Quantity Variation XT1ECWH 234 System 1 2 N/A XT2ECLWH 236 System 2 2 Left XT2ECRWH 237 System 2 2 Right XT3ECWH 238 System 3 2 N/A

However, is it possible to alter the code to group the information? So it looks like the below?

System 1 System 2 System 3 System 1
XT1ECWH 234
Pack Quantity: 2
Variation: N/A System 2
XT2ECLWH 236
Pack Quantity: 2
Variation: Left

 

XT2ECRWH 237
Pack Quantity: 2
Variation: Right System 3
Sorry, not sure why it's not formatted correctly but hopefully you can see what I'm trying to achieve.

The array for $variations is as follows:

Array
(
    [0] => Array
        (
            [attributes] => Array
                (
                    [attribute_pa_system] => system-1
                    [attribute_pa_pack-quantity] => 2
                    [attribute_pa_variation] => n-a
                )
            [sku] => XT1ECWH
            [variation_description] => 
            [variation_id] => 234
        )

    [1] => Array
        (
            [attributes] => Array
                (
                    [attribute_pa_system] => system-2
                    [attribute_pa_pack-quantity] => 2
                    [attribute_pa_variation] => left
                )
            [sku] => XT2ECLWH
            [variation_description] => Left
            [variation_id] => 236
        )

    [2] => Array
        (
            [attributes] => Array
                (
                    [attribute_pa_system] => system-2
                    [attribute_pa_pack-quantity] => 2
                    [attribute_pa_variation] => right
                )
            [sku] => XT2ECRWH
            [variation_description] => Right
            [variation_id] => 237
        )

    [3] => Array
        (
            [attributes] => Array
                (
                    [attribute_pa_system] => system-3
                    [attribute_pa_pack-quantity] => 2
                    [attribute_pa_variation] => n-a
                )
            [price_html] => 
            [sku] => XT3ECWH
            [variation_description] => 
        )

)

If it helps, I need to always group by the first attribute, in this case : attribute_pa_system

Any help on this would be very much appreciated!

Thank you in advanced.

I have a table that has pairs of matching records that are identified as matching on a specific column.  In other words, 2 users submit data on the same record, and they are identified as matching and belonging to the same record data because the table column gameid is the same for the pair.

How can I output the information for the pair of matching records for each of these into a table repeating it until Ive looped through all records?

In other words I want to create 1 table with headers for each matching pair all the way down...

thanks in advance.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=353968.0

Hi all,

I have a script that is essentially a log file of all preious versions of an article (versioning)

You can see the script I am talking about in action at:

http://danielrhyshardy.com/AWT/forumadmin.php

What I would like to do is, instead of displaying the title of each instance (you will see there are two instances named "apple", as they are two previous versions of an article), I would like to display that title once, and then all of the instances of that title be displayed below.

I hope that makes sense.

Here is the code Code: [Select]
<?

$sql = "SELECT id,title,message,date_added FROM messages2 ORDER BY id "; 
 
 
 
 
   $result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
   
   



   while(list($id,$title,$message,$date_added)=mysql_fetch_row($result)){





     
echo '<div style="color:#bb0000;width:250px;text-align:center;float:left;margin-left:15px;margin-bottom:15px;padding-bottom:20px;"><b>'.$title.'<br>'.$date_added.'</b>
 
<input id="'.$message.'" type="radio" name="admin[]" value="'.$id.'"  onclick="javascript:document.form22.car.value=this.id"
  >


</font></div>'."\n";
   
   

   

 
}



?>

I would use something like
Code: [Select]
if ($title = "apple") {

but this would obviously not work for new posts, unless I wanted to constantly update my code.

I am sure there is a simple way to achieve this.

Perhaps someone can tell me!?

Thanks in advance

Dan

I would appreciate your assistance, there are tons of login scripts and they work just fine. However I need my operators to login and then list their activities for the other operators who are logged in to see and if desired send their clients on the desired activity. I have the login working like a charm and the activities are listed just beautifully. How do I combine the two tables in the MySQL with PHP so the operator Logged in can only make changes to his listing but see the others.

FIRST THE ONE script the member logges in here to the one table in MSQL:
<?php
   session_start();
   
   require_once('config.php');
   
   $errmsg_arr = array();
   
   $errflag = false;
   
   $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
   if(!$link) {
      die('Failed to connect to server: ' . mysql_error());
   }
   
   $db = mysql_select_db(DB_DATABASE);
   if(!$db) {
      die("Unable to select database");
   }
   
   function clean($str) {
      $str = @trim($str);
      if(get_magic_quotes_gpc()) {
         $str = stripslashes($str);
      }
      return mysql_real_escape_string($str);
   }
   
   $login = clean($_POST['login']);
   $password = clean($_POST['password']);
   
   if($login == '') {
      $errmsg_arr[] = 'Login ID missing';
      $errflag = true;
   }
   if($password == '') {
      $errmsg_arr[] = 'Password missing';
      $errflag = true;
   }
   
   if($errflag) {
      $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
      session_write_close();
      header("location: login-form.php");
      exit();
   }
   
   $qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'";
   $result=mysql_query($qry);
   
   if($result) {
      if(mysql_num_rows($result) == 1) {
         session_regenerate_id();
         $member = mysql_fetch_assoc($result);
         $_SESSION['SESS_MEMBER_ID'] = $member['member_id'];
         $_SESSION['SESS_FIRST_NAME'] = $member['firstname'];
         $_SESSION['SESS_LAST_NAME'] = $member['lastname'];
         session_write_close();
         header("location: member-index.php");
         exit();
      }else {
         header("location: login-failed.php");
         exit();
      }
   }else {
      die("Query failed");
   }
?>

................................................. ................................
Now I need the person who logged in to the table above to be able to make multiple entries to the table below

<?
$ID=$_POST['ID'];
$title=$_POST['title'];
$cost=$_POST['cost'];
$activity=$_POST['activity'];
$ayear=$_POST['aday'];
$aday=$_POST['ayear'];
$seats=$_POST['special'];
$special=$_POST['seats'];
mysql_connect("xxxxxx", "xxx350234427", "========") or die(mysql_error());
mysql_select_db("xxxx") or die(mysql_error());
mysql_query("INSERT INTO `activity` VALUES ('ID','$title', '$cost','$activity', '$aday', '$ayear', '$special', '$seats')");
Print "Your information has been successfully added to the database!"
?>
Click <a href="member-profile.php">HERE</a> to return to the main menu
  <?php      
?>

hi,

i have made a website where people resgister their details of them and products.

they have to enter the following details in form

Name of company

name of the product

company address

email id 

password 

mobile number contact

and 

brief details about their company 

after filling all details user is registered on website.

user can then login with email id and pwd.

now after login ..user will get a page where he can upload the photos of products images and their price, so now my question is that when he finishes uploading (|by clicking on upload button) the product images and price text box ..then on final uploaded webspage it should show all other things which he registerd before (company name , mobile number etc) along with images and price...hence the main question that user does not need to enter mobile and address while uploading images and filling proce ..but on the final page it should show mobile and address along with price and images..as user is not going to enter mobile and address again and again as he will have multiple products to upload.

thanks in advance .

Hi,

so far I have managed to set up a somewhat basic login website with a mysql database backend.

Once they have logged on they go to a "main menu" page.

What I need to define is that user A sees button A but only that button, etc.

(Then of course that same rule would have to apply if they tried to directly go to the page, but I am guessing I can do that in the same way that I currently do to force a login).

If anyone has any tutorials or sample code I would much appreciate it.

Thanks,