PHP - Output Loop Results In Descending Order??

I have this code
Code: [Select]
$nArr = array('A', 'B', 'C', 'D', 'E', 'F');

$counter = 3;
while ($counter > 0) {
    $chunkedValues[$counter][0] = 1;
    for ($j = 0 ; $j < $counter ; $j++) {
        $chunkedValues[$counter][$j + 1] = $nArr[$j];
    }
    $nArr = array_slice($nArr, $counter--);
}
var_dump($chunkedValues);
that outputs:
Code: [Select]
array
  3 =>
    array
      0 => int 1
      1 => string 'A' (length=1)
      2 => string 'B' (length=1)
      3 => string 'C' (length=1)
  2 =>
    array
      0 => int 1
      1 => string 'D' (length=1)
      2 => string 'E' (length=1)
  1 =>
    array
      0 => int 1
      1 => string 'F' (length=1)
But i need this index structu
Code: [Select]
array
  0 =>
    array
      0 => int 1
      1 => string 'A' (length=1)
      2 => string 'B' (length=1)
      3 => string 'C' (length=1)
  1 =>
    array
      1 => int 1
      2 => string 'D' (length=1)
      3 => string 'E' (length=1)
  2 =>
    array
      2 => int 1
      3 => string 'F' (length=1)
I want to avoid loops with ceil.

Any idea? thanks for your time.

I am working to echo the results in a while or for loop... Both of my sample codes work, but the results are wrong!

The while loop ONLY echos a result IF the first record in the postings table matches the id passed (does not display a result unless the first record has a match)

The if loop displays ALL listings with the same name (counts them all) so there are no unique listings!


<?php

$posts_by_city_sql = "SELECT * FROM postings WHERE id='$_GET[id]'";
$posts_by_city_results = (mysqli_query($cxn, $posts_by_city_sql)) or die("Was not able to grab the Postings!");

/* While Loop  */
while($posts_by_city_row = mysqli_fetch_array($posts_by_city_results)) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
}

/* For Loop  */
$posts_by_city_row = mysqli_fetch_array($posts_by_city_results);
 
for ($i=0; $i<sizeof($posts_by_city_row); $i++) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
 }

?>

Results with for loop (there are 7 total unique book names, but it's just counting the first match on id 7 times like below):

AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners

Hi Guys

I have a product page in mysql as below:

id         itemnumber    order_id
1         348939012     2
2         535432454     1
3         543253424     4
4         987698769     3


I need to order this in my PHP mysql_fetch_assoc by order id.

What I mean is I need to list them by  order_id: 1,2,3,4

I have used ORDER BY order_id but still it wont work,

any ideas?

I'm trying to make a function which will display the top X results of the row Y which I set, for this instance I'm using the row browser and the top 5 results from my table statistics, the where is just to eliminate Search Bot results from showing up. I also want it to return the count of the amount of rows as well. So say there was 10 results for the browser 'Safari', then it would return the count of 10 for that result as well as the result itself.

Code: [Select]
$display->show_list('statistics', 'browser', '5', 'WHERE browser!=\'Search Bot\'');
Here is my function. I'm cleaned it up a bit to remove certain checks and outputs if the query were to fail, etc.

Code: [Select]
function show_list($table, $row, $limit = 5, $where = NULL) {

$item = mysql_query("SELECT DISTINCT $row FROM $table $where LIMIT $limit");

            $result = array();

while ($fetch = mysql_fetch_array($item)) {

            $result[] = $fetch;
}
            return $result;
}
Basically, how would I go about making it count the amount of rows for the row I've set, and then to output that along side the result?

How do I present these documentaries like this:   0-9 10 Things You Need to Know About Sleep 20 Animals That Will Kill You   A Ant Kingdom Atkins Diet   B Battle of the Brains Body Talk   I don't even know where to start!   I'm not asking anyone to do this for me; I just need a push in the right direction.   Any help will be appreciated.  

Hi guys,

I have this SQL query which I use in my PHP search script Code: [Select]
$query_for_result=mysql_query("SELECT * FROM customer WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%'");
It works fine, the only problem is now my database is bigger I would like to be able do SORT or ORDER BY id so that my search results are in order from asc to desc.

Is this possible? if so can you help me.

Thanks

Hi guys,  Having problems sorting mysql results. I can easily order/sort table columns but would like to order the results by a variable.(Distance in Miles).
Havent much experience in PHP and really struggling with this. Basically a query echoing out car make and models and how far they are located from a postcode. Can get it to work no porblem, but not to order/sort by least distance.

Heres what i'm working with:
Code: [Select]
$res=mysql_query("SELECT * FROM cars");
while ($row = mysql_fetch_assoc($res)){

echo $row['Make'];
echo $row['Model'];

//variable will be determimed by user input form
$postcode="W12 3SR";

$start=$postcode;
$ends = array();

//finds value from database field
{
$ends[]=$row['Location'];
}

// Postcode entered by user via input form
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$start'");
while($row=mysql_fetch_array($result)){
$gridn[0]=$row['Grid_N'];
$gride[0]=$row['Grid_E'];
}

foreach($ends as $fin){
// Postcodes within mysql table
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$fin'");
while($row=mysql_fetch_array($result)){
$gridn[1]=$row['Grid_N'];
$gride[1]=$row['Grid_E'];
}

// TAKE GRID REFS FROM EACH OTHER TO WORK OUT DISTANCE.
$distance_n=$gridn[0]-$gridn[1];
$distance_e=$gride[0]-$gride[1];

// CALCULATE THE DISTANCE BETWEEN THE TWO POSTCODES AND DIVIDE BY 1.6 TO CONVERT KM TO MILES
$hypot=sqrt(($distance_n*$distance_n)+($distance_e*$distance_e))/1.609;

//VARIABLE FOR DISTANCE AND ROUNDED OF TO NEAREST WHOLE NUMBER.
$distance=''.round($hypot/1000,0).'';


  echo " $distance miles";
  echo "<br>";
}
}
?>
I wish i could just do something like this but isnt possible, is it ?
Code: [Select]
"Select * FROM cars ORDER BY $distance";
Thanks!

I wish to order my results by its occurrence inside the $status array.

Basically all of the results with the status 'New' are to be listed first, then the results with the status Today, Tomorrow, Soon and so on.

Is this possible, or is there alternatively a different approach to ordering my results how I desire?

Code: [Select]
$status = array('New', 'Today', 'Tomorrow', 'Soon', 'Future', 'Complete');

$display->get_results("SELECT * FROM todo ORDER by status DESC");

Here's the query:
Code: [Select]
$sql = mysql_query("SELECT * FROM resources WHERE gameCat = '' ORDER BY systemCat,order_id");
I want something to happen when the systemCat changes in the results. Like this:

Code: [Select]
if($row['systemCat'] CHANGES){
echo '<div id="seperator"></div>';
}

Any ideas? Thank you!

Below is my query which works fine:

 $query = "
          SELECT st.CourseId, c.CourseName, st.Year, st.StudentUsername, st.StudentForename, st.StudentSurname,
          s.ModuleId, m.ModuleName, m.Credits, s.SessionId, s.SessionWeight, gr.Mark, gr.Grade
          FROM Course c
          INNER JOIN Student st ON c.CourseId = st.CourseId
          JOIN Grade_Report gr ON st.StudentId = gr.StudentId
          JOIN Session s ON gr.SessionId = s.SessionId
          JOIN Module m ON s.ModuleId = m.ModuleId
          WHERE
          (st.StudentUsername = '".mysql_real_escape_string($studentid)."')
          ";

Below is my results outputted by using php:

    Course: INFO101 - Bsc Information Communication Technology Year: 3
    Student: Mayur Patel (u0867587)
   
    Module: CHI2550 - Modern Database Applications
    Session: AAB 72 (A)
   
    Course: INFO101 - Bsc Information Communication Technology Year: 3
    Student: Mayur Patel (u0867587)
   
    Module: CHI2513 - Systems Strategy
    Session: AAD 61 (B)
   
    Course: INFO101 - Bsc Information Communication Technology Year: 3
    Student: Mayur Patel (u0867587)
   
    Module: CHI2550 - Modern Database Applications
    Session: AAE 67 (B)

How do I display it using php so that it only shows Course details and Student details only once, it will show each module in the course only once and shows each session being below each module it belongs to:

The output from above should look like this in other words:

     Course: INFO101 - Bsc Information Communication Technology Year: 3
        Student: Mayur Patel (u0867587)
       
        Module: CHI2550 - Modern Database Applications
        Session: AAB 72 (A)
        Session: AAE 67 (B)
       
        Module: CHI2513 - Systems Strategy
        Session: AAD 61 (B)


PHP code to output the results:

    $output1 = "";
   
            while ($row = mysql_fetch_array($result)) { //$result is the query
              
        $output1 .= "
             <p><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Year:</strong> {$row['Year']}<br/>
              <strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})
              </p>";
             
        $output1 .= "     
        <p><strong>Module:</strong> {$row['ModuleId']} - {$row['ModuleName']} <br/>
              <strong>Session:</strong> {$row['SessionId']} {$row['Mark']} ({$row['Grade']})
              </p>";
                }
               
                echo $output1;

Thank You

Hello dear Community,

i have a large document - and i want it to parse it and spit out only this part:  schule.php?schulnr=80287&lschb= 

Question: How to i parse the stuff!?

Well i try it with FireBug and FirePath (the Xpath-tool) i do it like the following:

    * Load the document into my browser, if possible
    * start Firebug extension/add-on
    * run the FirePath extension
    *  and run the xpath

      //a[contains(@href, "schule")]/@href
    *

      then i click "Eval" button.

 i find 2030 results - that are marked - how do i get them out of the firebug - to work with them?!  If i have to be more precise - please let me know!!  Perhaps i have to write more - and to add more information

See the screenshot - here  http://img259.imageshack.us/img259/7360/sceenshoteval5.jpg

how can i copy and paste the results - in order to do further processing from thereon.


look forward to hear from you

regards

i have a php script:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                                                 //not correct
$count5 = mysql_num_rows($result5);                                   //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");



the above is not what i  want,   i want  the actual result set of the select to print in my StatsFile
how can i achieve this please???

i have a list of check boxes
im ordering it according to Amenity name ASC
im floating 2 divs (columns)side by side

how can i get the list to echo it according to ABC :
like this::?

A D
B E
C F
Code: [Select]
<?php 
              echo '<div style="height:800px;" />';
              foreach($amens as $amen) {
              echo '<div style="float:left;padding-left: 2px;width:200px;"><input onclick="changedata(this)" type="checkbox" id="mm'.$amen['Amen_ID'].'" value="'.$amen['Amenity'].'" '.checkAmenity($id, $amen['Amenity']).' /><label style="padding-left:3px;" for="mm'.$amen['Amen_ID'].'">'.$amen['Amenity'].'</label></div>';

              } 
echo '</div>';
              ?>

Help please.. 50yr old PHP noob..
I have a PHP script that runs a personality survey and returns the dominant personality type, but I need to display the results as a bar chart reflecting the % totals for each of the 4 personality types.
Code is he http://codepad.org/wQN3qN3v Grateful for any help!

Hi there,    My friend asked me to help him perform a task today and I was completely stumped as to how I should complete it. Being someone who is reasonably experienced with PHP programming I didn't think I would find it absolutely impossible to complete, maybe hard, but not impossible. So I wondered if someone would now be able to explain to me in order to assist me in expanding my knowledge how to complete this task.    https://www.dropbox....B8M6cr_z7a?dl=0   Here is a link to the files he sent me, please ignore the C++ section.   If anyone could help / begin to give an explanation please fire away. I feel so bad about myself for NOT knowing that I'm now motivated to learn more!   Many thanks!