PHP - What Is The Problem With This While Loop And Table?

I have 2 question, which are related to each other.
They are about my current school project. Which I have been really stupid for, I took it too slow and thought I had enough time.
But no, I had to do almost my whole project in the last 3 weeks and sunday is the deadline.
I have a couple pages to make left, which one of them is the hardest one and I have the 2 questions about it.

Question 1.


I have to make a invoice with 4 different prices, divided over 3 tables in my mysql.

Let me sum up the tables.

Products
Productsid - productprice

Productrule
Productruleid - amount - productid - maintainanceid

Maintainance
Maintainanceid - price

I need to show the price
The price of each product
The amount * productprice
The amount * productprice + price

All in a table, it mustn't be edited, so it not in a form.

I know I have to use a SQL select sum for it, but I have never used it, and my querys always fail in the first place

I used a for and while loop to choose the amount of and the name of products for the mechanic page.
There was a max of 5 products to select, just to keep it easier.
If I would only pick 2, it wouldn send something empty to the database and it wasn't required.
My teacher helped me with that and it works.

So then we come to question 2, can I use that in a table, instead of a drop down menu, which I used at the mechanic page.

This is the PHP code:
Code: [Select]
for($i=1;$i<=5;$i++)
{
if(($_POST['aantal'.$i] != "") AND ($_POST['product'.$i] != ""))
{
$query3 = mysql_query ("INSERT INTO onderdeelregel SET
aantal='".$_POST['aantal'.$i]."',
onderdelenid='".$_POST['product'.$i]."',
werkzaamhedenid='".$werkzaamhedenid."'");
}
}


And the HTML:
Code: [Select]
<table border="0">
<tr>
<th>Aantal</th>
<th>Product</th>
<tr>

<!-- START BLOCK : PRODUCT_REGEL -->
<tr>
<td>
<input class="wijzigInput" name="aantal{NUMMER}" id="aantal" type="text" maxlength="2" size="2" /></td>
<td>
<select name="product{NUMMER}">
<option selected="selected" class="wijzigOption" value=""></option>
<!-- START BLOCK : PRODUCT_REGEL_OPTION -->
<option class="wijzigOption" value="{PRODUCT_REGEL_WAARDE}">{PRODUCT_REGEL_NAAM}</option>
<!-- END BLOCK : PRODUCT_REGEL_OPTION -->
</select>
</td>
</tr>
<!-- END BLOCK : PRODUCT_REGEL -->
</table>
Oh I didn't used a while loop there, but I know I have to use it in the customer page.

I know this isn't going to work on my own, and I haven't got much time left.
I would really appreciate it if anyone could give me some code, or atleast a start of the sql select sum and the for and while loop in a table.
I know I have add other stuff to the invoice, but that isn't hard, so with this I should be able to do it and finish my project in time.
I usually don't like that, I want to learn it myself, but time is very little right now
Oh and sorry for the Dutch in my code.

Please help me, I don't want to stress out and fail it.
School is very important to me and I hate myself for taking it so slow.


Thanks a lot

Chris

Hey guys,

I am using php loop to echo out all off the data in my database category within a html table. However I would like to reduce each table row to only 5 results then start a new row so that the table fits within the webpage.  Any suggestions?  Any help is much appreciated.  Thanks.

Jason

Here is what i am using, but does not fit within the page.

Code: [Select]
<table cellspacing="10">
<tr>
<?php
$query = mysql_query('SELECT photo_id, photo_name FROM gallery_photos WHERE photo_category = "Books" AND photo_approved = 1 ORDER BY rand()');

while ($row = mysql_fetch_array($query))

{

echo "<td><a href='http://www.mysite.com/view.php?pid=".$row['photo_id']."'><img src='photos/".$row['photo_id'].".jpg' width='115' height='115' /><center><h3><b>".$row['photo_name']."</b></h3></center></a></td>";
}
?>
</tr>
</table>

this is my sql code
Code: [Select]
<?php
$query = "SELECT Player, 
                 SUM(GLI) AS 'gli', 
                 SUM(Goals) AS 'goals', 
                 SUM(Saves) AS 'saves', 
                 SUM(SOG) AS 'sog', 
                 SUM(Assists) AS'assists',  
                 SUM(CK) AS 'ck',  
                 SUM(YC) AS 'yc', 
                 SUM(RC) AS 'rc'  
          FROM pinkpanther_stats 
          GROUP BY Player; ";
?>
their are 11 separate players and i want to set variables $adam_glie and $tyler_glie equal to the glie column for that player(the player being the first part of the variable) and i dont have any idea how to go about doing this 

Good day:

Im trying to get a numer from a table and use it to know how many pages are in the article so the script knows how many hyperlinks for the pages to generate (ex. links for pages 1 to 5). This is the script so far:

Code: [Select]

<?php
$aid = $_GET['aid'];
$sd = $_GET['sd'];
  $connection = mysql_connect("localhost",
        "username",
        "password");

    mysql_select_db("articles", $connection); 
$query="SELECT pages FROM articles_description WHERE articleid=$sd";

$result=mysql_query($query);

$num=$result;

mysql_close();


?>

<table width ="600" border="0" cellspacing="2" cellpadding="2" align="center">
<th><font face="Arial, Helvetica, sans-serif">pages</font></th>



<?php
$i=1;
while ($i <= $num) {

?>



<td align="center"><font face="Arial, Helvetica, sans-serif"><?php echo "<a href=\"$f3?aid=$aid&sd=$i\" target=\"_self\">$i</a>"; ?></font></td>
</td>




<?php
$i++;
}
?>


Any help will be appreciated.

The following generic code prints out a given table in my database, by first getting the fieldnames and putting them as the title of each column, and then getting the values.  How do I change it so that if the name of the field is "password", the value will echo "----" instead of the password?

$sql = "SELECT * FROM $tablename";

$result = mysql_query($sql) or die("Query failed : " . mysql_error()); 

$row = 1;
?>

<table width="90%" border="1"><?php 
//the MYSQL_ASSOC gets field names instead of numbers
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
if ($row == 1) {
?><tr><?php
foreach ($line as $col_key => $col_value) {
?><th><?php echo $col_key;?></th><?php
}
?></tr><?php
}
?><tr><?php
foreach ($line as $col_value) {
?><td><?php 

echo $col_value;?></td><?php 
}
?></tr><?php 
$row++;

I am trying to place a unique number into a mysql table.

Currently, my code generates a random number, then is supposed to scan through the table for that number.
If the code finds that number already in the table, it generates a new random number and repeats the process.
I have commented my code for the purpose of this help forum:

Code: [Select]
        $result = mysqli_query($link,"SELECT * FROM testTable");

do
{
$end = true; //prepares end of loop
$idNum = rand(1,10); //rand(1,999999);  <-- for testing purposes I have reduced the number generated
$idNumTx = (string)$idNum;

                //loop through the rows
while ($row = mysqli_fetch_assoc($result))
{
if ($row['idNum'] = $idNum) //check if the random number equal to this row
{
$end = false; //prep end of loop repeat
echo $idNumTx; //display rand number that failed for testing purposes
echo " NO! "; //display error for testing purposes
}
}
} while(!$end);

I know I must be doing something wrong, as when I run this, it runs the if statement within the while loop always executes, and I get an output like:
Code: [Select]
1 NO! 1 NO! 1 NO! 1 NO! 1 NO! 1 NO! 5 Win

Win is when it places the value before it, in this case 5, into the table. However, the value of 5 might already be in the table and it doesn't seem to matter.
I execute the code multiple times, and it seems to increase the number of "# NO!" almost (but not every) time. However, each time ALL of the "# NO!" are the same #, and the "# Win" just seems to be random (as it should be, but not unique).

Checking the table after shows me random numbers between 1 and 10 (as it should) in the correct field, but the are not unique. (Ex/ Both row 1 and 5 could have the same value, say 6)

I'm hopefully doing something simple wrong, so someone please point it out to me

Hello forum.
I'm new here, but I've been reading and finding useful things for a while now.

I'm still new to PHP and I need a little help.

I'm doing a school project and I have some things I want to do, but do not know how to write it down in PHP.

I think I'll ask a lot of questions this week, and I hope I will get some help..

For start I want to ask this:

I've been using Code: [Select]
mysql_fetch_array() for doing loops and populating check-boxes. And everything's working fine.. but what I want is to control the actual loop by clicking buttons. Let's say first time a while-do is run, my check-boxes get populated from the database and every other loop the next data from the table is added.. pretty straightforward.
I want to be able to populate once, then click "next" and the new data to be added and so on..
Code: [Select]
<?php
$tema = mysql_query("SELECT * from questions")or die(mysql_error());

function answer1($string)
{
$string1 = explode("/", $string);
echo $string1[0];
}
function answer2($string)
{
$string1 = explode("/", $string);
echo $string1[1];
}

while ($row=mysql_fetch_array($tema))
{
echo mysql_fetch_array($tema);
$tip=$row["tip"];
if ($tip==2)
{
$id=$row['prasanje_id'];
$question=$row['question'];
$answer=$row['answer'];
?>
   <label> <?php echo $question?></label><br>
   <input type="checkbox"  name="CheckboxGroup1" value="checkbox" id="CheckboxGroup1_0" />
      <?php answer1($tekst) ?></label>
    <label>
      <input type="checkbox"  name="CheckboxGroup1" value="checkbox" id="CheckboxGroup1_1" />
      <?php answer2($tekst) ?></label>
<?php
}
}
?>I want an alternative to the while-do loop..
Is it possible to do this?

Thanks!!

A WHILE loop in a FOR loop problem

Script about links and sublinks from 1 table.

In fact 2 questions about that.
1) In the FOR loop I have for example to do the loop 3 times. (needs to find 3 results withing the loop with if and else)
When first time, he's gonna search within the WHILE loop that holds (for example) 10 records of the DB in a variable.
He needs to search for rowid number 5, he found it
He goes out of the WHILE loop and goes searching again but now for rowid number 2
 
Now it seem that the WHILE loop start searching for number 2 but won't start from his first row in the variable (10 rows from the db ).
He start at row number 6 instead of beginning all over again !!!

-> so the order of the numbers of rows MUST be in an ascending order, ortherwise he won't find them all ! But the numbers I have are NOT in an ascending order !!!
Why doesn't the WHILE loop begin again from his row 1 in the variable ?

FOR loop
{
   WHILE loop    {   content here,     break;  }
 }


2) even when I get all the result in an ascending order, he won't go doing a second search but with a different rowid number that he gets from the FOR loop.
It is giving me back indeed the right new rowid number,  but the WHILE loop is doing nothing. 
I have put many echo "..."; and other stuff for checking but can't find the cause !

Here's the code :

Code: [Select]
// $ResultShow = 10 rows from mysql db
if(isset($ResultShow)){

if (mysql_num_rows($ResultShow) >= 1){


//$linksuborder = "2,3,4";
$array1 = explode(",", $linksuborder);
sort($array1);

for ($n = 0;  $n < count($array1);  $n++){ // searchin for the right row id in the variable $ResultShow where we find the numbers for next loop
$r1 = each($array1);

While($Row2 = mysql_fetch_array($ResultShow))  {
 
if($Row2["linkid"] == $r1['value'])  // found it, now look for the numbers that we'll put in an array
{  echo "---here the content---"; 

// linksuborder is where numbers from row id's are stored like  5,2,8
//now put them in an array
$array2 = explode(",", $Row2["linksuborder"]);
        sort($array2);

for ($n2 = 0;  $n2 < count($array2);  $n2++){
$r2 = each($array2);

////// here searching for the sublinks //////
While ($Row3 = mysql_fetch_array($ResultShow))
{
if($Row3["linkid"] == $r2['value']) // search for the right row id within the variable $ResultShow
{
echo "---here the content---";
  break; // found it, so no need to do the rest of the loop
 
} // end if
} //end while
////// end searching for sublinks //////

}  // end for
}  // end if

else
{
echo "--- content here ---"; 
}
 


}  // end while
}  // end for


} //end if
} // end if


Table :

linkid     linksuborder     linktitle
1                  2,3,4   
2                  9,7,8           mainlink1
3                  10               mainlink2
4                                     mainlink3
5
6
7                                      sublink3
8                                      sublink2
9                                      sublink1
10                                    sublink4

-> linksuborder 2,3,4 are the row id's for the mainlink
-> than we put the numbers 9,8,7  (also row id's)  mentioned in row linkid 2  also in a new array
-> now we can search for the sublinks
-> get the details from row linkid 9, than 7, than 8

-> First mainlink is compleet, now go to row linkid 3 to do it all over again for the next mainlink...


RESULTS from an sorted array -> sort($linksuborder);
-------------------------------------------------------------
mainlink1 : sublink1, sublink2, sublink3

mainlink2  : **no result back  but it should *

mainlink 3 : **no result back  but it should *

This way seems not good.

<?php
$username ="MANCENT";
$user_input_x = _xmouse.movement ;//FLASH
$user_input_y = _ymouse.movement ;//FLASH

while(true)
{
$updatepos = mysql_query("UPDATE users_float SET user_input_x = '$user_input_x' , user_input_y = '$user_input_y' WHERE username = '$username'");
}

This way works but whats a better way?

?>

I want to make a table for each paddler_id (Field) which exists into pushup Database

My code for paddler_id = 1 is


require "../sql.php";

$result = mysql_query("EXPLAIN pushup");
$r = mysql_query("SELECT * FROM paddlerinfo t1 LEFT JOIN pushup t2 on t2.paddler_id=t1.id LEFT JOIN practicedate t3 on t3.practice=t2.practice_id ORDER BY t1.firstname ASC ");
$r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");

echo "<table width='30%' border='1' cellpadding='0' cellspacing='0' style='font-family: monospace'>";
echo "<tr>";
echo "<td>DATE</td>";
while ($row = mysql_fetch_array($result)) {

if (in_array($row["Field"], array("paddler_id", "practice_id", "p_id"))) continue;

echo "<td>",($row["Field"]), "</td>";
}
echo "</tr>";

while (($data = mysql_fetch_array($r1, MYSQL_ASSOC)) !== FALSE) {
   unset($data["p_id"],$data["paddler_id"]);
echo "<tr>";
   foreach ($data as $k => $v) { 
echo "<td>";
      echo"$v";
echo "</td>";
}

echo "</tr>";
}


echo "</table>";

mysql_free_result($result);
mysql_free_result($r);
mysql_free_result($r1);
mysql_close();



The problem is on line $r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");
I want to put something which makes it paddler_id = X where x = 2,3,4,5... and x exists in database and do not print twice the x (because that database may have rows where x = same id


How do i do that??

I have an array of data in which I want to display in a table with the first row of data to not be formatted. In the second row of data, I want it formatted with the CSS class of "success". When I run this code, I do not get any formatting of any rows in the table. I have tried various different options without success. Any help would be greatly appreciated.

 

<?php
$counter = 0;
      while($row = mysql_fetch_array($query)) {
           if($counter % 2 == 0) {
                 //output data from each row of data with no class of "success"
                 echo "<tr class='text-left'>";
                       if (empty($row[endDate])) {
                          echo "<td>".$row[startDate]."</td>";  /* only one date */
                          } else {
                                echo "<td>".$row[startDate].'-'.$row[endDate]."</td>";  /*date range */
                           }
                 echo "<td>".$row[rideName]."</td>";
                 echo "<td>".$row[rideDesc]."</td>";
                 echo "<td>".$row[location]."</td>";
                 echo "<td><a href='".$row[link]."'>".$row[source]."</a></th>";
                 echo "</tr>";
                $counter++;
           } else {
                           //output data from each row
                 echo "<tr class='text-left success'>";
                                            if (empty($row[endDate])) {
                                                echo "<td>".$row[startDate]."</td>";
                                            } else {
                                                echo "<td>".$row[startDate].'-'.$row[endDate]."</td>";
                                            }
                 echo "<td>".$row[rideName]."</td>";
                 echo "<td>".$row[rideDesc]."</td>";
                 echo "<td>".$row[location]."</td>";
                 echo "<td><a href='".$row[link]."'>".$row[source]."</a></th>";
                 echo "</tr>";    
                $counter++;
           } /* end if else */
      } /* end while */
?>

Edited January 12, 2020 by Wal-Wal-2
Copied wrong set of code

I've built a database based rating system, and till now everything works as expected except of one minor thing that breaks the while rating system.

When you press thumbs up or down it's only adding the vote to the LAST printed table in the while loop, it does NOT add it to the current table where the button was pressed.

This is the while loop:


<?php 
function knuffix_list ($query, $user_name, $avatar_path, $dbc) {

$data = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc));

//Loop through the array of data

while ($row = mysqli_fetch_array ($data)) {

global $con_id;

$con_id = $row['con_id'];

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='$avatar_path' alt='avatar' /></td>";

echo "<td class='knuffix_username'><strong>" . $user_name . " ___ ";

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<button type='submit' name='plusVote' value='like'>Y</button>

<button type='submit' name='minusVote' value='dislike'>N</button>

<input type='hidden' name='hidden_con_id' value='<?= " . $con_id . " ?>' />

</form></td><td class='votes'>Y[ - ] | N[ - ]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";

}

mysqli_close($dbc);

}

?>


The con_id is the value how I wanted to determine which table it is, when I echo $con_id out (inside the while loop) it's showcasing the numbers correctly, but it doesn't work with the buttons, the buttons simply correspond to the last printed table in the while loop. I think it's because the while loop goes through each row until it's finished and it stops.

This is the rating script:



// RATING SYSTEM

$plus_vote = $_POST['plusVote'];
$minus_vote = $_POST['minusVote'];


if ($plus_vote || $minus_vote) {

$query = "SELECT * FROM con WHERE con_id = '$con_id'";
$query = mysqli_query ($dbc, $query) or die (mysqli_error($dbc)); 
$assoc_vote = mysqli_fetch_assoc ($query);

if ($plus_vote) {

$vote_up = $assoc_vote['likes'] + 1;

$query = "UPDATE con SET likes = '$vote_up' WHERE con_id = '$con_id'";

$query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc)); 

mysqli_close($dbc);

echo "test " . $con_id;

} elseif ($minus_vote) {

$vote_down = $assoc_vote['dislikes'] - 1; 

$query = "UPDATE con SET dislikes = '$vote_down' WHERE con_id = '$con_id'";

$query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc)); 

mysqli_close($dbc);

echo "test " . $con_id;

}
}



If I would be able to make the buttons in the while loop to RECOGNIZE the correct con_id of the table the button was being pressed then the script would work as intended and it would add the vote to the correct row in the table.

How could I solve this problem, because I really have no idea?

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display the first column of the array as a header for each foreach loop then i've got the data displayed under each header in the loop but what i am trying to understand here is i am trying to get under each header it to have 4 columns or a number of my choosing. Heres an example of what i am trying to do.

A airlie beach Andergrove Alexandra Armstrong Beach Alligator Creek B Bucasia Blacks Beach Beaconsfield Bakers Creek Balberra Bloomsbury Breadalbane Ball Bay Belmunda
This is an example of how it is being displayed right now

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach   Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek   Balberra   Bloomsbury   Breadalbane   Ball Bay   Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne   Chelona   Campwin Beach   Cape Hillsborough   Conway
Heres The Code i have so far.

Code: [Select]
<?php
$file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}
print_r($outputArray);
echo "\n<br />";
//display
echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
echo "<th><b>" . $alphabetical ."</b></th>";
echo "<tr>";
foreach ($value as $key){
echo "<td>" . $key . "</td>";

}
echo "</tr>";
}
echo "</table>";

echo "\n<br />";

?>
Heres my Csv File which i am using as an array in the code

Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display each Header above each bit of data and spans across 5 columns for each foreach loop but what i am trying to understand here is i am trying to get the header then the data then another header and data and so on but only about 4 or number of my choosing grouped header/data but select how many are in each column up to 5 columns. Heres an example of what i am trying to do.

A D K N S AlexandraHeadlands DickyBeach KingsBeach Nambour SandstonePoint Aroona Diddillibah KielMountain Ninderry ShellyBeach Doonan KundaPark NoosaHeads SippyDowns B Dulong Kuluin Ningi SunriseBeach Beachmere DeceptionBay Kilcoy NorthArm SunshineBeach BanksiaBeach Noosaville Scarborough Beerburrum E L Beerwah EerwahVale Landsborough O T Bellara Elimbah Tanawha Bellmere Eudlo M P TowenMountain Birtinya Eumundi Maleny Petrie Tewantin Bongaree Mapleton Palmview TwinWaters Bokarina F Marcoola Palmwoods BribieIslandArea Flaxton MarcusBeach Parklands U Buddina ForestGlen MaroochyRiver Parrearra UpperCaboolture Burnside Maroochydore PeregianBeach Buderim G Minyama Pinbarren V Burpengary GlassHouseMountains MoffatBeach PointArkwright Valdora BliBli Mons PelicanWaters H Montville PacificParadise W C Highworth Mooloolaba WeybaDowns CoolumBeach Hunchy Mooloolah Q Warana Caboolture MountainCreek WestWoombye CabooltureSouth I MountCoolum R Woombye Caloundra ImageFlat Morayfield Rosemount Woorim CastawaysBeach Mudjimba Redcliffe WamuranBasin Chevallum J Woodford CoesCreek WoodyPoint Cooroy Wamuran Currimundi Wurtulla X Y YandinaCreek Yandina Z


This is an example of how it is being displayed right now

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach
Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek   
Balberra   Bloomsbury   Breadalbane   Ball Bay   Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne   
Chelona   Campwin Beach   Cape Hillsborough   
Conway



Heres The Code i have so far.


Code: [Select]
<?php
  $file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
$count = 0;

while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}

echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
    echo "<th colspan='4'><b>" . $alphabetical ."</b></th>";
    echo "<tr>";
foreach ($value as $key){
$afterkey=preg_replace('/\s+/','-',$key);
    if ($count == 4){
    echo '</tr><tr><td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    $count = 0;
    }else{
    echo '<td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    }
$count++;    
}
    echo "</tr>";
$count = 0;
}
    echo "</table>";

    echo "\n<br />";

?>


Heres my CSV File:


Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,

I want to loop through a MySQL table, and perform a calculation based on the current row the loop is on and the previous loop.

Say my table has 2 columns - Film_id and FilmRelease, how would I loop through and echo out a calculation of the current FilmRelease and the previous row's column value?

Thanks guys

I have got to this stage, but for some reason it's not printing out anything

Code: [Select]
<?php
 mysql_connect("localhost", "****", "*****") or die(mysql_error()); 
 mysql_select_db("*****") or die(mysql_error()); 

 $sql = mysql_query("SELECT FilmRelease FROM Films_Info") 
 or die(mysql_error()); 

 $last_value = null;

while ($row = mysql_fetch_assoc($sql)) {

  if (!is_null($last_value)) {

    print date_diff($row['FilmRelease'], $last_value) . "<BR>";
  }

  $last_value = $row['FilmRelease'];
}