PHP - Displaying Results Based On Location

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 have a PHP while loop that pulls from an SQL database and displays the contents in a table with two columns.

// Check Connection
    if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

// Select Data Table
    $result = mysqli_query($con,"SELECT * FROM Recommendations") or die(mysqli_error);

// Split Data
    $mid = ceil(mysqli_num_rows($result)/2);

// Display Content
    while ($rows = mysqli_fetch_array($result)) {
        $Name = $rows['Name'];
        $Author = $rows['Author'];
        $Cover = $rows['Link to Cover'];
        $Link = $rows['Link to Profile'];
    echo "<table><tr><td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td>
    <td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td></tr></table>";
    }
?>

I want to be able to display the looped results side by side in columns of two. Example: 1 2 3 4
5 6   I've tried using pseudo classes to display only the even and odd results in the different table columns, but honestly have no idea how to do this. I'm new to PHP, so my apologies if the results are really obvious. Thanks in advance!

Hello,

Im trying to display some results from mysql database, however none display.
Can anyone tell me where im going wrong please?

Code: [Select]
 
</head><body>
<div id="listhold">
<div class="list">
<a href="Restaurants.html">Restaurants</a><br />

<?php
mysql_connect("","",""); 
mysql_select_db("") or die("Unable to select database"); 
$result = mysql_query("SELECT name FROM business WHERE type ='restaurant' ORDER BY name");
$number_of_results = mysql_num_rows($result);
$results_counter = 0;
if ($number_of_results != 0) 
{while ($array = mysql_fetch_array($result))
$results_counter++;
if ($results_counter >= $number_of_results);}
?>
</div>

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!

^.^
 

Dear all,
I am new in this forum. This is my code

  $query = "
  SELECT webdb.id, webdb.writer, writer.picLoc, webdb.title FROM webdb, writer WHERE webdb.writer=writer.name and 
  category = 'Researchworks' and language = 'Farsi' ORDER BY writer DESC"; 
  $resultaat = mysql_query($query, $LinkID);
  $column_count = mysql_num_fields($resultaat) or die (mysql_error()."<br>Couldn't execute query: $SQLquery");
  
  $counter=1;
  echo "<table border=\"0\" width=\"700\" border color=white><tr>";
  while ($row = mysql_fetch_row($resultaat))
  {
  if ($author !== $row[1])
  {
  $author = $row[1];
  echo "<td align=right width=220 valign=top style=\"margin: 5px; float: right border-bottom-color:#000; border-left-color:#000;\">";
  echo "<img width=\"50\" height=\"80\" src=\"admin/writers/$row[2]\" border =\"0\"><br>".$row[1]."<br>";
  echo "<a href=\"poems.php?writer=$row[1]\">".$row[3]."</a><br>";
  echo "</td>";
  if($counter%3==0) 
  {
  echo"</tr><tr>";
  }
  $counter++;
}
  }
  echo"</tr></table>";


i have authors with different articles on a certain topic. What i want is, displaying the name of the author only once and all his titles under his name. I also want a dynamic table where i display three authors in each row and soon as there a fourth author a new row must start. My problem now is is the title is also being filtered and i can only display one title.

Thanks in advance

I'm trying to create a list that groups information by username. Only part of it is working. The first query ($get_item_sql) is grouping the information perfectly but the second query ($get_sold) is lumping the $item_price and $item_amount_due as one total for each one and outputting the same amounts into every username. I'm stuck on this and would appreciate your help.

For example:  Username   item fees   image fees item sales  item price  total due
                       Jim                   2               $0.40      $100.00        $3.00     $3.40
                       Kelly                 5               $1.00      $100.00        $3.00     $4.00

This example shows the columns in red as being the problem where Kelly didn't sell anything so her "item sales" and "item price" should be $0.00 but is carrying Jim's totals into hers.

Hope this helps!  Thank you!     

$get_item_sql = mysql_query("SELECT id, username, date, ROUND(price,2) AS price, SUM(item_fee) AS fee, item_fee, SUM(sold) AS sales, SUM(ROUND(price,2)) AS total FROM product WHERE MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username" )
or die(mysql_error());

if (mysql_num_rows($get_item_sql) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_info = mysql_fetch_array($get_item_sql)) {
   $item_username = $item_info['username'];
   $item_date = $item_info['date'];
   $item_price = $item_info['price'];
   
   $item_fee = $item_info['fee'];
   $image_fees = $item_fee * .20;
   $item_sold = $item_info['sales'];
   
  
 $get_sold = mysql_query("SELECT SUM(ROUND(price,2)) AS total, SUM(ROUND(sold,2)) AS sales, date, username FROM product WHERE sold = '1' AND MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username")
or die(mysql_error());

if (mysql_num_rows($get_sold) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_sold2 = mysql_fetch_array($get_sold)) {
   
   
   $item_sales = $item_sold2['total'];
   $item_price = ($item_sold2['total']) * .03;
  
$item_amount_due = $image_fees + $item_price; 

  
  

$content .= "<form action=\"add_artist.php\" method=\"post\"><table class=\"anotherfont\" width=\"670\" border=\"0\">

<tr><td width=\"201\">{$item_username}</td>
                    <td width=\"109\">{$item_fee}</td>
<td width=\"109\">{$image_fees}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_sales}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_price}</td>
<td width=\"109\"><input name=\"balance_due\" type=\"text\" value=\"{$item_amount_due}\" /></td>
</tr><br /></table></form>"; 

   }
  }
  }
  }

I'm realitivly new to PHP and was hoping somebody could help.

I have a mysql database that stores information about books. I am currently using the code below to query the database and extract the 3 most recent entries and showing them in a dynamic list:

Code: [Select]
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 3");
$productCount = mysql_num_rows($sql);
if ($productCount > 0) { // ensure a book exists
while($row = mysql_fetch_array($sql)){
             $id = $row["id"];
$title = $row["title"];
$author = $row["author"];
$price = $row["price"];
$date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
$dynamiclist .= //My table showing the products
}
} else {
$dynamicList = "There are currently no Books listed in this store";
}
This works well when showing the most recent books 1 below the other. However, I would like to show these products side by side, horizontally across the page.

Can somebody please point me in the right direction?

Many thanks

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!

Hi

I have got results being displayed after clicking the search button in a form on my home page but it brings up all the results which is ok but how do I get onlt the results a user searches for for example a location or property type etc as its for a property website

The coding is below for the results page

Also sorry how do I add a background image to the php page, I tried using css but wouldn't work

Code: [Select]
<style type="text/css">
body {background-image:url('images/greybgone.png');}
</style>

<?php
 
mysql_connect ("2up2downhomes.com.mysql", "2up2downhomes_c","mD8GsJKQ")  or die (mysql_error());
mysql_select_db ("2up2downhomes_c");

echo $_POST['term'];

$sql = mysql_query("select * from properties where typeProperty like '%$term%' or location like '%$term%'");

while ($row = mysql_fetch_array($sql)){
    echo 'Type of Property: '.$row['typeProperty'];
    echo '<br/> Number of Bedrooms: '.$row['bedrooms'];
    echo '<br/> Number of Bathrooms: '.$row['bathrooms'];
echo '<br/> Garden: '.$row['garden'];
echo '<br/> Description: '.$row['description'];
echo '<br/> Price: '.$row['price'];
echo '<br/> Location: '.$row['location'];
echo '<br/> Image: '.$row['image'];
    echo '<br/><br/>';
    }
 
?>

Code: [Select]
<?php 
$result = mysql_query("SELECT * 
FROM FamilyTbl
INNER JOIN PeopleTbl ON (FamilyTbl.Name_ID = PeopleTbl.NameID) 
WHERE FamilyTbl.House_ID = '$address'
ORDER BY NameLast, NameFirst
") OR die(mysql_error());

WHILE ($row = mysql_fetch_array($result) )  { 

   echo $row[NameLast]. ", ". $row[NamePrefix]. " ". $row[NameFirst]. " ". $row[NameMiddle]. $row[NameSuffix]. " "; 
}
?>

OK, some of these queries return A LOT of names.  I'd like to be able to display them in columns in a table like so:
Code: [Select]
Charne, Mr. Michael   Glanger, Mrs. Karin      Kling, Mr. Wayne 
Charne, Mrs. Suzette  Glanger, Mr. Trevor      Lazarow, Mrs. Fiona 
Charney, Mrs. Linda   Jochelson, Mrs. Barbara  Lazarow, Mr. Mark 
Charney, Mr. Norman   Jochelson, Mr. Neil      Norton, Mr. Charles 
Cohen, Mr. Brendan    Karlan, Mr. Dennis       Norton, Mrs. Jodi 
Cohen, Mrs. Joanna    Karlan, Mrs. Helen       Roy, Mr. Michael 
Flekser, Mrs. Jean    Kling, Mrs. Danielle     Roy, Mrs. Nicki 
Frysh, Dr. Howard     Kling, Mrs. Melanie      Tsafrir, Mrs. Lauren 
Frysh, Mrs. Sandra    Kling, Mr. Nevil         Tsafrir, Mr. Thomer 

That way it reads top to bottom THEN left to right.

math-wise, it's simple to set up:
Code: [Select]
$num_results = number_of_$results;
$numcols = 3;
$numrows = trunc($numresults/numcols);
<table>
for row_loop=1 to numrows
<tr>
for col_loop = 1 to numcols
<td>
echo result(col_loop-1)*(numrows)+row_loop
</td>
next col_loop
</tr>
next row_loop
</table>

Anyone want to give this a shot?

Revraz already directed me to http://www.phpfreaks.com/forums/index.php/topic,95426.0.html but that displayed the data from left to right then up to down like so:
Code: [Select]
Charne, Mr. Michael   Charne, Mrs. Suzette  Charney, Mrs. Linda 
Charney, Mr. Norman   Cohen, Mr. Brendan    Cohen, Mrs. Joanna 
Flekser, Mrs. Jean    Frysh, Dr. Howard     Frysh, Mrs. Sandra 
Glanger, Mrs. Karin   Glanger, Mr. Trevor   Jochelson, Mrs. Barbara 
Jochelson, Mr. Neil   Karlan, Mr. Dennis    Karlan, Mrs. Helen 
Kling, Mrs. Danielle  Kling, Mrs. Melanie   Kling, Mr. Nevil 
Kling, Mr. Wayne      Lazarow, Mrs. Fiona   Lazarow, Mr. Mark 
Norton, Mr. Charles   Norton, Mrs. Jodi     Roy, Mr. Michael 
Roy, Mrs. Nicki       Tsafrir, Mrs. Lauren  Tsafrir, Mr. Thomer 

It's a good temp solution, but if anyone is good with for loops, I'd appreciate the help, thanks!

-Dave

Hi, fairly new to PHP over the last couple weeks. Been having a problem with certain queries. I have a database with football results, games, teams etc. I can filter these using drop down and that's all well and good. The problem I'm having is displaying the data via gameweek. I've been asked to display the table like so - Gameweek1 will display week1 teams, results etc. Gameweek2 will display week2... and so on. I can manage to do this in a drop down. But I've been asked to display this using links like "Previous, 1, 2, 3 Next". I've tried pagination but I couldn't figure it out. Can anyone point me in the right direction? If I need a GET() method, how would I go about coding that so it will be used in a link(s)? Been searching and searching to find an answer but to no avail...

//Database connection etc...

$gameweek = "SELECT * FROM games WHERE gameweek= 1";
    
    //if(isset($_GET['gameweek']))
    //{
    //    $gameweek = $_GET['gameweek'];
    //    
    //}
    //....
    $result=mysqli_query($connection, "select * from games WHERE gameweek= 1");
 //Print table and table headings...
    
    mysqli_close($connection);
?>
<a href="http://weeks.php?gameweek=2">Week 2</a>
<a href="http://weeks.phpgameweek=3">Week 3</a>

</body>
</html>

Hello Everyone was wondering if I could get some help with the following code? I am querying a database for results of listings that are in a database these listings are displayed on the page in a form. I am wanting each listing to be on a different page. Below is my code.
Code: [Select]


$lim=1;
if (!isset($s) || $s < 1 || !is_numeric($s)) {
            $s = 1;
        }


    $start = ($s - 1) * $lim;
     $sql = "select id,bussimg,imagewidth,imageheight,email,usridm,company,businesscategory,address1,address2,state,city,zip,website,email,repname,description,phonenumber,country,status from $approvecheckbusinesses where usridm='$user_id'";
    $result=db_query($sql);
     



        $countpages = $sql;
        $sql = $sql . " order by id asc limit $start, $lim";
       $result=db_query($sql);
        $pages = ceil(mysql_num_rows(mysql_query($countpages)) / $lim);
     
   


$result=db_query($sql);
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$Listid= mysql_result($result, $i, "id");

$usridm= mysql_result($result, $i, "usridm");
$CompanyName= mysql_result($result, $i, "company");
$realname= mysql_result($result, $i, "repname");
$email= mysql_result($result, $i, "email");
$BusinessCategory= mysql_result($result, $i, "businesscategory");
$status= mysql_result($result, $i, "status");
   



echo ("FORM IS TO BE DISPLAYED HERE");

}

if ($pages > 1) {
            echo("<p align=left style='font-size: 85% color=white'>");
            for ($i = 1; $i <= $pages; $i++) {
                echo("[");
                if ($i == $s) {echo("<b>");}
                else {echo("<a id=home_offerLink href='index.html?EditMemberListing&user_id=$user_id&s=$i'>");}
                echo("Page $i");
                if ($i == $s) {echo("</b>");}
                else {echo("</a>");}
                echo("]  ");
            }
            echo("</p>")


Page Numbers here using the above code.. The problem I seem to be running into is that it only displats the first record. The page numbers show up page 1 page 3
page 2 and three are blank there is no mysql error or anything for some reason I only get that first result out of three

Hi everyone.

I'm stuck on the following query. I need to display all the fields listed below on a page, but linked via communications.CommID.  I'd appreciate any assistance you can provide. thank you.

Code: [Select]

<?php
 $result = mysql_query("SELECT records.NameFirst_1, records.NameLast_1, records.CompanyName, records.CompanyBranch, records.CompanyReferenceNumber, records.CaseOwnerSelect, communications.ConversionType, communications.Contact, communications.ContactFrom, communications.CommID, communications.ContactPosition, communications.ContactTelephone, communications.ContactEmail, communications.ContactFax, communications.CallDate, communications.CallTime, communications.ActionTextField
FROM records INNER JOIN communications ON records.IDNumber = '$IDNumber'")

 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
?>