PHP - Divide Registrations Into Groups Based On Age?

I have a list of x,y coordinates. (drill positions)

I have Three Primary x,y co-ords. (station positions)

I want to assign drill positions to stations based on how close they are and the priority of the station(1, 2 or 3).

I also want the option of making all stations have a priority or 1 so they divide equally.(for drill positions that are close to two stations)

I have absolutely no idea how to tackle this.
Is there a formula anyone is aware of?
Can anyone even attempt to show me how to tackle this. I am 100% lost.

Hello everyone,

i'm trying to get the following scenario done:

I've got a shop system which is kind of a cms and shop in one thing but that's not really important here, now there's some kind of vouchers which can be used in my shop to fund the account balance aka "Credits", now everything works fine, my script checks the voucher for validity and balance and the user gets the voucher balance credited as his account balance, in short:

User1 uses Voucher with amount 10$
Script sets User1 Shop-Credits/Balance to 10$

Now what i want to achieve is, that the user get's only 50% of the original voucher amount credited to his shop-credits/balance basically just divide the voucher amount by 2 before it get's credited to the account.

My code to write/update the credits in mySQL looks like this:

$query2 = "UPDATE `shop_user` SET `credits` = `credits`+'".$psc->value."' WHERE `userid` = '".$_SESSION["userid"]."' AND `username` = '".$_SESSION["username"]."'";

Now this .$psc->value. is the part where it checks for the value first and then sets the same amount as "credits" in the shop.

Now isn't there just some simple piece of code that would let me divide this by 2, which would be 50% obviously.

something like .$psc->value /2. which obviously doesn't work, but should give you an idea of what i need.

Any help is greatly appreciated.

Sabine

Hi everyone. I have this code that suppose to divide the query result 3 columns in a row. Like this :
Shoes   Hats   Jeans
Shorts  Shirts  Belts
But for some reason this one doesn't work. It gave me everything in a single row. Like this: Shoes Hats jeans Shorts Shirts Belts. I noticed that before I put this two 2 lines of code, it's working fine. It didn't give me any error messages or anythings. Can someone point me out what did I did wrong?

This is two lines I put in:
Code: [Select]
$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
 while ($product_check = tep_db_fetch_array($vuong_query)) {
This is the whole piece of code:
    Code: [Select]
  <tr>
    <td><table width = "100%" border="1" bordercolor="maroon">
      <tr>
<?php
$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
 while ($product_check = tep_db_fetch_array($vuong_query)) {

$categories_querys = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $product_check['categories_id'] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
    

    $number_of_categories = tep_db_num_rows($categories_querys);

    $rows = 0;
    while ($categories = tep_db_fetch_array($categories_querys)) {
      $rows++;
      $cPath_new = tep_get_path($categories['categories_id']);
      $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
      echo '         <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
      if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
echo '       </tr>' . "\n";
echo '       <tr>' . "\n";
      }
    }
}
    ?>
      </tr>
            </table>
          </td>
        </tr>
Thanks anyone for helping me out.
Vanvoquan

This topic has been moved to PHP Math Help.

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

I have a MySQL query that pulls multiple columns with many rows.  I want to break each column into its own array.
Here is what I have to this point but doesn't seem to be working.  Is this the right direction or is there something easier?
Thanks!

Code: [Select]

$query = "SELECT name, address, city, state FROM customers WHERE sku = '12345'";
$result = mysqli_query($dbc, $query) or die();

$name = array();
$address = array();
$city = array();
state = array();

while ($data = mysqli_fetch_assoc($result)) {
  $name = $data['name'];
  $address = $data['address'];
  $city = $data['city'];
  $state = $data['state'];
}