PHP - Php Loop/star Menu Help

Hey guys,

Got another question im hoping someone can help me with.

I have a foreach loop (for use in a mysql query):

   foreach ($interests as $interest) {
       $query .= "($id, $interest), ";
   }

problem is i do not want the comma(,) in the last loop.

Is there some kinda of function i can use so it does not insert it on last loop?

Or should i just use a for loop with a nested if loop? something like ;

   for($i=0; $i < count($interests); $i++){
      $query .=
      "($id, '$interests[$i]')";
      if($i + 1 < count($interests)) {
         $query .= ", ";
      }
      }


Cheers guys

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

Good Evening -  I am in the process of trying to call back a list of categories and sub categories using a WHILE LOOP inside of a WHILE LOOP. It works on a different part of the site within the admin panel but not here. Here it only calls one sub category and moves on to the next parent category instead of finishing the loop and pulling all sub categories out...

// CATEGORIES

$query  = "SELECT * FROM cat";
$result = mysql_query($query);



while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$catid = $row['id'];
$catname = $row['name'];

$output .= "<li class=\"level0 nav-2 parent\" onmouseover=\"toggleMenu(this,1)\" onmouseout=\"toggleMenu(this,0)\">
<a href=\"product.php?cat=$catid\">
<span>$catname</span>
</a>\n";


$querynav = "SELECT * FROM subcat WHERE pid = '$catid'";
$resultnav = mysql_query($querynav);

while($array = mysql_fetch_array($resultnav, MYSQL_ASSOC))
{

$subcatid = $row['id'];
$subcatname = $row['name'];

$output .= "<ul class=\"level0\">
<li class=\"level1 nav-2-1 first\">
<a href=\"product.php?cat=$catid&subid=$subcatid\">
<span>$subcatname</span>
</a>
</li>
</ul>
</li>";
}

}

Code: [Select]
<?php 
$hierachy = new hierachy;
$iterator = new RecursiveIteratorIterator(new recursiveArrayIterator($hierachy->getLocalSubNodes($name1)));
try {
    foreach($iterator as $key=>$value)
        {
        echo $value = substr($value,0,-1).'<br />';
        }
    }
catch(Exception $e)
    {
    echo $e->getMessage();
    }?>

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 *

Hi..
I have while loop inside while loop but I encountered problem in displaying data inside while loop or the second while loop.

here is my code:

Code: [Select]
<?php
  error_reporting(0);
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
?>
<script type="text/javascript">
function showDetails(pcode) {
 
 var clickElement = pcode.value;
 var click_id = pcode.id;
               
// var value_ =  document.getElementById(click_id).checked
 //    =  document.getElementById(clickElement).checked;   
 //var Table = (document.getElementsByName('list')[0].value);     
 
 var Table = document.getElementById('kanban_list');

 var rows = Table.rows;   
 
 var strSelect = document.getElementById(click_id).value;
 //alert(strSelect)
 
 for (var i = 0; i < rows.length; i++) {     
      var row = rows[i];     
    //row.style.display = (row.id.substr(0,3) == strSelect) ?      'none'         :          '';   
    //row.style.display = (row.id.substr(0,3) == strSelect) ?
   // row.style.display = 'none';
   // row.style.display = '';
   
    if (row.id.substr(0,3) == strSelect) {
        row.style.display = ((document.getElementById(click_id).checked) == false) ?  'none' : ''
    }
    //(document.getElementById(click_id).checked == false) ?  'none'               : '' : '';   
 
 } 
   
}

</script>
<?php
$sql = "SELECT kc.PCODE, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion, 
kc.count_wip_forming, kc.count_wip_deflashing, kc.kanban, kc.virtual, p.max_lot, p.min_lot FROM kanban_checker kc 
JOIN plan p ON kc.PCODE = p.PCODE ORDER BY p.PCODE";    
$result = mysql_query($sql, $con);       
?><label>Display Details:</label><input  onclick='showDetails(this);' id='chkDetail'   type='checkbox' checked='checked' value='wip'/>
<?php
echo "<table id='kanban_list'>";
echo "<tr>
        <th> PCODE </th>
        <th> LOT CODE </th>
        <th> CHEMICAL WEIGHING </th>
        <th> COMPOUNDING </th>
        <th> EXTRUSION </th>
        <th> FORMING </th>
        <th> DEFLASHING </th>
        <th> KANBAN </th>
        <th> VIRTUAL </th>
        <th> MAX LOT </th>
        <th> MIN LOT </th>
     </tr>";
while($row = mysql_fetch_assoc($result)){ 
    echo "<tr>
        <td>$row[PCODE]</td>
        <td>&nbsp;</td>
       <!-- <td>$row[LOT_CODE]</td>   -->
        <td>$row[count_wip_chemical_weighing]</td>
        <td>$row[count_wip_compounding]</td>
        <td>$row[count_wip_extrusion]</td>
        <td>$row[count_wip_forming]</td>
        <td>$row[count_wip_deflashing]</td>
        <td>$row[kanban]</td>
        <td>$row[virtual]</td>
        <td>$row[max_lot]</td>
        <td>$row[min_lot]</td>
        </tr>";     
$sql = "SELECT kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming, kd.wip_deflashing 
FROM kanban_data kd JOIN plan p ON kd.PCODE = p.PCODE ORDER BY p.PCODE "; 
$result_kanban_data = mysql_query($sql, $con);   

while($row_data = mysql_fetch_assoc($result_kanban_data)){    
    echo "<tr id='wip'>
    <td></td>
    <td>&nbsp;$row_data[LOT_CODE]</td>
    <td>&nbsp;$row_data[wip_chemicalweighing]</td>
    <td>&nbsp;$row_data[wip_compounding]</td>
    <td>&nbsp;$row_data[wip_extrusion]</td>
    <td>&nbsp;$row_data[wip_forming]</td>
    <td>&nbsp;$row_data[wip_deflashing]</td>
    </tr>"; 
}       
}
echo "</table>";
     
?>
I attach the image of result from this code

But the output that I want is all LOT_CODE with P35 PCODE will only display below P35
and all LOTCODE with P35M PCODE will only display below P35M.

Thank you

I hope somebody can help me..

Hi,

I am new to PHP. Can someone explain me clearly how to use while loop inside while loop to print "*" in square shape.

Thank you for your help.

I'm having a really bad brain fart and I cannot get the logic correct here lol.

I need divs wrapped around every set of 5 images so if there is a total of 8 images then there would be 2 sets of divs (first with 5 images, second with 3 images) and if there was 12 images then there would be 3 sets of divs (first two with five images, last one with 2 images) etc etc What am I doing wrong and is there an easier way to do this?

http://pastebin.com/QfsFxe4G


Thanks!

So I have a PHP parent page that is accesses that scans the database for the passed token in the URL and then replaces content on the template page using a loop. My issue is that I am trying to use a loop on the secondary page which causes the white screen of death. From what I can tell the loop inside a loop is causing the issue.
I'll paste the code below, let a newbie know if you have any ideas or can point me in the right direction.

Thanks everyone!


Here is the chunk of code from the parent page with the loop function....


// output pre content
eval("\$preContent = \"$preContent\";");
print_r( replaceChar($preContent) );

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS;
$resultSearch = mysql_query($sqlSearch);

while($displayrows = mysql_fetch_assoc($resultSearch)) {
   $display = replaceTokens($loopTemplate);
   $display = str_replace('\\', '[backslash]', $display);
   $display = str_replace('[%', '$displayrows[', $display);
   $display = addslashes(str_replace('%]', ']', $display));
   $display = replaceTokens($display);
   $display = changeCase($display);

   eval("\$display = \"$display\";");

   $display = stripslashes($display);
   $display = str_replace('[backslash]', '\\', $display);
   $display = replaceChar($display);

   print_r( $display );

}
// output post content


And here is the loop function from the page that the above code loops through replacing tokens in.



<?php
$mySQLServer = "xxxxxxxxx";
$mySQLUser = "xxxxxxxxxx";
$mySQLPass = "xxxxxxxx";
$mySQLDB = "xxxxxxxxxxxxx";
$SQLToday = date("m/d/y") . "<br />";
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y"));
$SQLsevenname = (date("l", $SQLsevendays));
$SQLsevennumber = (date("jS", $SQLsevendays));
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass)
  or die("Couldn't connect to SQL Server on $myServer");
$selected = mssql_select_db($mySQLDB, $dbhandle)
  or die("Couldn't open database $myDB");
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8";
$data = mssql_query($query);
$result = array();

while ($row = mssql_fetch_object($data))
{
       $result[] = $row;
       $returnedresults = (97*($row->TotalApprovals)) ;
 }

$englishreturnedresults = number_format($returnedresults);
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . '  has delivered ';
echo $englishreturnedresults;
echo '  Here are just a few people ';

echo '<ul class="BulletCheck">';

mssql_next_result($data);


while ($row = mssql_fetch_object($data))
{
       $result[] = $row;
       echo '<li>' . '  ' . $row->FirstName  . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>';
 }


mssql_close($dbhandle);
?>   

So i have a <drop down> menu, and a <nav> menu on my left side of the page. I have a problem when i click at the first column of my drop down menu and it explores submenu, the submenu mixes with the nav menu that is under the drop down menu on the left. i could solve it with margin-top of the nav menu but i don't like the empty space beetwen them. I tried with putting overflow:visible; in CSS of my dropdown menu but it is still the same. drop down menu is seen but there is stil seen nav menu under and they are mixed. So basicly i want my dropdown menu to be priority,  so when i clicks on my first column (only first column is problem because there under is nav menu the other are open nice) it will explore submenu and the part of nav menu that covers the submenu will be hidden.   Here is the screen shot:     Here is the code of head <dropdown> menu if someone finds the problem.

#menu, #menu ul {
	 
    margin: 0;
    padding: 0;
    list-style: none;
}

#menu {
	 
    width: 900px;
	margin-top:20px;
    margin-left:auto;
	margin-right:auto;
    border: 1px solid #222;
    background-color: #111;
    background-image: linear-gradient(#444, #111);
    border-radius: 6px;
    box-shadow: 0 1px 1px #777;
}

#menu:before,
#menu:after {
    content: "";
    display: table;
}

#menu:after {
    clear: both;
}

#menu {
    zoom:1;
}

#menu li {
	 
    float: left;
    border-right: 1px solid #222;
    box-shadow: 1px 0 0 #444;
    position: relative;
}

#menu a {
	 
    float: left;
    padding: 12px 30px;
    color: #999;
    text-transform: uppercase;
    font: bold 12px Arial, Helvetica;
    text-decoration: none;
    text-shadow: 0 1px 0 #000;
}

#menu li:hover > a {
    color: #fafafa;
}

*html #menu li a:hover { /* IE6 only */
    color: #fafafa;
}

#menu ul {
	
    margin: 20px 0 0 0;
    _margin: 0; /*IE6 only*/
    opacity: 0;
    visibility: hidden;
    position: absolute;
    top: 38px;
    left: 0;
    z-index: 1;    
    background: #444;   
    background: linear-gradient(#444, #111);
    box-shadow: 0 -1px 0 rgba(255,255,255,.3);  
    border-radius: 3px;
    transition: all .2s ease-in-out;
}

#menu li:hover > ul {
	
    opacity: 1;
    visibility: visible;
    margin: 0;
}

#menu ul ul {
	 
    top: 0;
    left: 150px;
    margin: 0 0 0 20px;
    _margin: 0; /*IE6 only*/
    box-shadow: -1px 0 0 rgba(255,255,255,.3);      
}

#menu ul li {
	 
    float: none;
    display: block;
    border: 0;
    _line-height: 0; /*IE6 only*/
    box-shadow: 0 1px 0 #111, 0 2px 0 #666;
}

#menu ul li:last-child {  
  
    box-shadow: none;    
}

#menu ul a { 
    
    padding: 10px;
    width: 130px;
    _height: 10px; /*IE6 only*/
    display: block;
    white-space: nowrap;
    float: none;
    text-transform: none;
}

#menu ul a:hover {
    background-color: #0186ba;
    background-image: linear-gradient(#04acec, #0186ba);
}

#menu ul li:first-child > a {
    border-radius: 3px 3px 0 0;
}

#menu ul li:first-child > a:after {
	 
    content: '';
    position: absolute;
    left: 40px;
    top: -6px;
    border-left: 6px solid transparent;
    border-right: 6px solid transparent;
    border-bottom: 6px solid #444;
}

#menu ul ul li:first-child a:after {
	 
    left: -6px;
    top: 50%;
    margin-top: -6px;
    border-left: 0; 
    border-bottom: 6px solid transparent;
    border-top: 6px solid transparent;
    border-right: 6px solid #3b3b3b;
}

#menu ul li:first-child a:hover:after {
    border-bottom-color: #04acec; 
}

#menu ul ul li:first-child a:hover:after {
    border-right-color: #0299d3; 
    border-bottom-color: transparent;   
}

#menu ul li:last-child > a {
    border-radius: 0 0 3px 3px;
}

Here is the code of <nav> menu if someone finds the problem.

#cssmenu {
	
	
	width:15%;
  padding: 0;
  margin-top: 50px;
  margin-left:auto;
  margin right:auto;
  float:left;
  border: 0;
  line-height: 1;
}
#cssmenu ul,
#cssmenu ul li,
#cssmenu ul ul {
  list-style: none;
  margin: 0;
  padding: 0;
}
#cssmenu ul {
  position: relative;
  z-index: 597;
  float: left;
}
#cssmenu ul li {
  float: left;
  min-height: 1px;
  line-height: 1em;
  vertical-align: middle;
  position: relative;
}
#cssmenu ul li.hover,
#cssmenu ul li:hover {
  position: relative;
  z-index: 599;
  cursor: default;
}
#cssmenu ul ul {
  visibility: hidden;
  position: absolute;
  top: 100%;
  left: 0px;
  z-index: 598;
  width: 100%;
}
#cssmenu ul ul li {
  float: none;
}
#cssmenu ul ul ul {
  top: -2px;
  right: 0;
}
#cssmenu ul li:hover > ul {
  visibility: visible;
}
#cssmenu ul ul {
  top: 1px;
  left: 99%;
}
#cssmenu ul li {
  float: none;
}
#cssmenu ul ul {
  margin-top: 1px;
}
#cssmenu ul ul li {
  font-weight: normal;
}
/* Custom CSS Styles */
#cssmenu {
  width: 200px;
  background: #333333;
  font-family: 'Oxygen Mono', Tahoma, Arial, sans-serif;
  zoom: 1;
  font-size: 12px;
}
#cssmenu:before {
  content: '';
  display: block;
}
#cssmenu:after {
  content: '';
  display: table;
  clear: both;
}
#cssmenu a {
  display: block;
  padding: 15px 20px;
  color: #ffffff;
  text-decoration: none;
  text-transform: uppercase;
}
#cssmenu > ul {
  width: 200px;
}
#cssmenu ul ul {
  width: 200px;
}
#cssmenu > ul > li > a {
  border-right: 4px solid #1b9bff;
  color: #ffffff;
}
#cssmenu > ul > li > a:hover {
  color: #ffffff;
}
#cssmenu > ul > li.active a {
  background: #1b9bff;
}
#cssmenu > ul > li a:hover,
#cssmenu > ul > li:hover a {
  background: #1b9bff;
}
#cssmenu li {
  position: relative;
}
#cssmenu ul li.has-sub > a:after {
  content: '+';
  position: absolute;
  top: 50%;
  right: 15px;
  margin-top: -6px;
}
#cssmenu ul ul li.first {
  -webkit-border-radius: 0 3px 0 0;
  -moz-border-radius: 0 3px 0 0;
  border-radius: 0 3px 0 0;
}
#cssmenu ul ul li.last {
  -webkit-border-radius: 0 0 3px 0;
  -moz-border-radius: 0 0 3px 0;
  border-radius: 0 0 3px 0;
  border-bottom: 0;
}
#cssmenu ul ul {
  -webkit-border-radius: 0 3px 3px 0;
  -moz-border-radius: 0 3px 3px 0;
  border-radius: 0 3px 3px 0;
}
#cssmenu ul ul {
  border: 1px solid #0082e7;
}
#cssmenu ul ul a {
  font-size: 12px;
  color: #ffffff;
}
#cssmenu ul ul a:hover {
  color: #ffffff;
}
#cssmenu ul ul li {
  border-bottom: 1px solid #0082e7;
}
#cssmenu ul ul li:hover > a {
  background: #4eb1ff;
  color: #ffffff;
}
#cssmenu.align-right > ul > li > a {
  border-left: 4px solid #1b9bff;
  border-right: none;
}
#cssmenu.align-right {
  float: right;
}
#cssmenu.align-right li {
  text-align: right;
}
#cssmenu.align-right ul li.has-sub > a:before {
  content: '+';
  position: absolute;
  top: 50%;
  left: 15px;
  margin-top: -6px;
}
#cssmenu.align-right ul li.has-sub > a:after {
  content: none;
}
#cssmenu.align-right ul ul {
  visibility: hidden;
  position: absolute;
  top: 0;
  left: -100%;
  z-index: 598;
  width: 100%;
}
#cssmenu.align-right ul ul li.first {
  -webkit-border-radius: 3px 0 0 0;
  -moz-border-radius: 3px 0 0 0;
  border-radius: 3px 0 0 0;
}
#cssmenu.align-right ul ul li.last {
  -webkit-border-radius: 0 0 0 3px;
  -moz-border-radius: 0 0 0 3px;
  border-radius: 0 0 0 3px;
}
#cssmenu.align-right ul ul {
  -webkit-border-radius: 3px 0 0 3px;
  -moz-border-radius: 3px 0 0 3px;
  border-radius: 3px 0 0 3px;
}

Edited by Dorkmind, 26 November 2014 - 05:00 PM.

Hi All, Am sure this is simple but can't work it out. I have the following which creates 3 menus:

<p>Drag items from one menu to another</p>
<table>
	<tr>
		<td valign="top">Menu 1</td>
		<td valign="top">Menu 2</td>
		<td valign="top">Menu 3</td>
	</tr>
	<tr>
		<td valign="top">
		<ul class="sortable" id="menu1">
			<li id="id_1">Item 1</li>
			<li id="id_2">Item 2</li>
		</ul>		
		</td>
		<td valign="top">
		<ul class="sortable" id="menu2">
			<li id="id_3">Item 3</li>
			<li id="id_4">Item 4</li>
		</ul>		
		</td>
		<td valign="top">
		<ul class="sortable" id="menu3">
			<li id="id_5">Item 5</li>
			<li id="id_6">Item 6</li>
		</ul>		
		</td>
	</tr>
</table>

This uses the following to show an array of each menu:

$(function() {
 $("ul.sortable").sortable({
    connectWith: '.sortable',
    update: function(event, ui) {
    $('#menu_choice').empty().html( $('.sortable').serial() );
    }
  });
});

(function($) {
$.fn.serial = function() {
 var array = [];
 var $elem = $(this); 
    $elem.each(function(i) {
      var menu = this.id;
        $('li', this).each(function(e) {
                array.push( menu + '['+e+']=' + this.id  );
        });
    });
    return array.join('&');      
    }
 
})(jQuery);

What I'd like is to simply grab the values of menu 1 only, as the array shows all menus. What am I doing wrong as can't seem to just return menu1. Going forward, I then want to store the returned array into a PHP cookie if this is possible?   Many thanks

The output for the below code is;

the for loop number is 0
the for loop number is 1
the for loop number is 2
the for loop number is 3
the for loop number is 4
the for loop number is 5
the while loop number 7
the while loop number 8
the while loop number 9

Code: [Select]
$i = 0;
for ($i=0; $i<6; $i++)
{echo "the for loop number is $i <br/>";}

while ($i<9)
{$i++ ;
echo "the while loop  number $i <br/>";}
If at the end of my for loop $i = 5, and then in my while loop 1 is added to $i  ($i++) then why doesnt my while loop
output begin with;     the while loop number 6   ?

Code: [Select]
<table>
<tr>
<td align="center">
<?PHP

$b = 1;
for ($a=1; $a<=16; $a++)
{
        echo str_repeat($a, $b);
        $b++;
        echo "<br>";
}
$b = 17;
for ($a=1; $a<=26; $a++)
{
        echo str_repeat($a, $b);
        $b--;
        echo "<br>";
}
?>
</td>
</tr>
</table>

I am trying to make something like this:
                   1
                  23
                 456
             7891011
          1213141516
            17181920
              212223
                2425
                  26


But i have managed what I've shown above. Anyone have any help on this?

I'm trying to grab the data for several products, then list the attributes for each product. I'm ending up with the same attributes from Attribute id="259". Can anyone fix my problem?
XML example
Code: [Select]
<RelatedAttributes>
<Attribute id="259">
<name>Brand</name>
<AttributeValues>
<AttributeValue id="258888">
<name>HON</name>
</AttributeValue>
<AttributeValue id="276682">
<name>Office Star</name>
</AttributeValue>

<Attribute id="296935">
<name>Stores</name>
<AttributeValues>
<AttributeValue id="18893">
<name>Test</name>
</AttributeValue>
</AttributeValues>
</Attribute>
</RelatedAttributes>

php Code
Code: [Select]
foreach($xml->RelatedAttributes->Attribute as $attribute){
echo $attribute->name; //main Attribute Name

foreach($xml->RelatedAttributes->Attribute->AttributeValues->AttributeValue as $attribute_values){
echo $attribute_values->name; //subtopic for main Attribute

}}

The individual while loops work, but when I embed it within a while the parent loop runs, but the inner loop doesn't execute at all

Code: [Select]

while ($set3 = mysql_fetch_array($query2)){
while ($set2 = mysql_fetch_array($query)){
echo $set2['EmailAddress'];
}
}