PHP - Help! Mysql Results Based On Combo Box.

Hello,

I am trying to get a page that shows a list of parts, with their quantities, condition and type.

So parts that are identical are counted as 2, 3 etc if they are the same part, condition and type.

But if one or more parts of the same type has any one of those variables different to the rest, it/they need to come out on a new line with the correct quantity against them.

I have tried using arrays and I can get the quantities working against each part but don't know how to adapt it to achieve what I want.

Here is what I have so far:

// GET ALL THE PARTS FROM THIS **ONE SUPPLIER** AND FIND OUT THE QUANTITIES...

include("../dbconnectlocal.php") ;
$result = mysql_query("SELECT supplier, partNumber, newUsed, jobType, directIndirect, currency, vat, total FROM pourbaskets

  WHERE enquiryRef = '$enqId' AND supplier = '$sSup' ORDER BY

  partNumber DESC")or die(mysql_error()) ;
$quantity = 0 ;
$currentCount = 1 ;

$partQuantityArray = array() ; // The box for our parts against their quantities.
$partsBag = array() ; // For finding out how many unique parts there are later.
$partCount = mysql_num_rows($result) ; // How many parts in total.
while($row = mysql_fetch_assoc($result)) { // While we are going through each part found...

$part = $row['partNumber'] ;

$cond = $row['newUsed'] ;

$jtyp = $row['jobType'] ;

$curr = $row['currency'] ;

$vat  = $row['vat'] ;

$tota = $row['total'] ;

array_push($partsBag, $part) ;

if($partCount == 1) { // Just one part...

$quantity = 1 ;

array_push($partQuantityArray, $part, $quantity) ;

}

if(!$prevItem && $partCount != 1 { // Is the first item and not the only one...

$prevItem = $part ; // Set it to be the previous...

$quantity++ ; // Increase quantity (to 1 now)...

}

elseif($currentCount == $partCount && $partCount != 1) { // If it's the last one in the list and not the only one...

if($prevItem != $part) {

array_push($partQuantityArray, $prevItem, $quantity) ;

$quantity = 1 ;

array_push($partQuantityArray, $part, $quantity) ;

//$prevItem = $part ;

}

elseif($prevItem == $part) { // The final part is the same as the last one...

$quantity++ ;

array_push($partQuantityArray, $part, $quantity) ;

}

else {

array_push($partQuantityArray, $part, $quantity) ;

}

}

elseif($prevItem == $part) { // If the current item is the same as the last item...

$quantity++ ;

// Increase quantity...

}

elseif($partCount != 1) { // If it's a new item and not the only one, store the quantity of the last item, and start at 1...

array_push($partQuantityArray, $prevItem, $quantity) ;

$quantity = 1 ;

$prevItem = $part ;

}

$currentCount++ ;
}
print_r($partQuantityArray) ;exit();

//////////////////// END OF QUANTITY FINDER //////////////////////////////

I have attached what I would like it to come out as.

I'm trying to pull results from a database based on where the user is located based upon the variables $usr_lat & $usr_lng, and search for by a radius of x amount of miles/km (need to make it optional). I can't seem to find exactly what I'm looking for on google so I thought I'd asked here. Any help would be appreciated.

hi 

I have 2 tables (members & friendship)



Members table columns:
--------------------------------------------
username | password |    email    | etc ....
--------------------------------------------
Person 1     xxxxxx        x@x.com
person 2     yyyyyy        y@y.com
 
Friendship columns:

---------------------------------------
username |   friend   |  status  |
---------------------------------------
person 1     person 2     friends
person 2     person 1     friends
person 1     person 3     pending



I want to query the friendship table: "SELECT friend FROM friendship WHERE username ='$_SESSION['myusername'];'  AND status='friends' "

(so its basically getting the user names of anyone who is the logged in users friend)

And then use the returned user names  to select their data from the members table.

Any help much appreciated!

^.^
 

I have a search form that has a drop down
Code: [Select]
<select name="radius" id="radius">
      <option value="5">5 mi.</option>
      <option value="10">10 mi.</option>
      <option value="15">15 mi.</option>
      <option value="20">20 mi.</option>
      <option value="50">50 mi.</option>
      <option value="100">100 mi.</option>
    </select>

I'm trying to limit the results in a foreach loop within what was selected.

Meaning, if someone selects 10, results within 10 miles will show
The foreach is
Code: [Select]
foreach ($stores as $k=>$v) {
            $output = "<h3 style='margin:0;padding:0'><b>".$storeinfo[$k]['MktName']."</b><br>(approx ".$v." miles)</h3>";
            $output .= "<p style='margin:0 0 10px 0;padding:0'>".$storeinfo[$k]['LocAddSt']."<br>";
            $output .= $storeinfo[$k]['LocAddCity'].", ".$storeinfo[$k]['LocAddState']." ".$storeinfo[$k]['zipcode']."</p>";
            print_r($output);           
        }

$v being the distance. So I need to show only the results of $v that are less than $r.

How would I go about doing this?

Right now, $v displays numbers like 5.04, 173.9 and so forth.

Can anybody help me out?

Thanks in advance.

I'm very new to this and really could use some help. I've got a Web app that has one form that collects data from the user and puts it into a mysql database and has another form that allows the user to select critiera to find records in the database and display them on the page.  All this is working just fine, but now that my database is getting more data in it, I want to add functionality to display 10 records on a page with results page navigation links so the user can move forward and backward in the results set.  This part is not working and I've put in echo statements to figure out what the code is doing.

The problem I'm having is that when the selection critiera pulls more than 10 records from the database, the first page of results is correct per the selection criteria entered by the user on the select form.  When the 'next' link is selected to review the second page of results, the query is executed again.  But this time the form variables have been reset and the results now contains the entire contents of the db.  The start record is set to look at the 11th instance of the results set, so the second page starts with the 11th record in the database instead of the 11th record in the original results set.

The original select statement is built by determining which criteria is selected using $_POST against each form variable.  How can I retain the form variables or the original select statement  so the second execution of the select statement results in the same results set as the first? The other option that may be better is to retain the original results set and avoid re-executing the select statement altogether.  But I don't know how to do that either.  Any suggestions, code samples or adivice is much appreciated!