PHP - Php Display Bookings Loop

Hi, I would like to ask, how to display the while loop result 3 per row with the following code below:
  $startDate = strtotime($datefrom);  

I can't seem to get the math right!

I have a function, pulling 13 states (canadian provinces) from the database and I can't seem to get them all to show in 5 columns. Where am I doing this wrong. The code below only shows 7 of 13... I just can't seem to get where I am off!

PHP CODE:
function map_showCA()
{
global $db, $tpl;

// ShowLocalResources

$sSQL = "SELECT * FROM states_canada ORDER BY state;";
$db->query($sSQL);
$next_record = $db->next_record();

while ($next_record)
{
$state_id = $db->f("id");
$state = $db->f("state");
$statename = $db->f("statename");
$statename_html = $db->f("statename_html");

$next_record = $db->next_record();
if (!USE_SEO_LINKS) { $statename_html = $state_id; }
$vendors_states[] = array("name" => $statename, "id" => $state_id, "state_html" => $statename_html);
}

$vendors_states_col = array_chunk($vendors_states, 5, true);

$loop = (int)(count($vendors_states) / 5);
if(count($vendors_states) % 5 > 0) $loop++;

$j = 0;

for($i = 0; $i < $loop; $i++)
{
$parameters = 'http://'.$vendors_states_col[0][$j]["state_html"].'.ilocalize.com';
// $first_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("first_column_link", $parameters);
$tpl->set_var("first_column", tohtml($vendors_states_col[0][$j]["name"]));

$parameters = 'http://'.$vendors_states_col[1][$j+6]["state_html"].'.ilocalize.com';
// $second_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("second_column_link", $parameters);
$tpl->set_var("second_column", tohtml($vendors_states_col[1][$j+6]["name"]));

$parameters = 'http://'.$vendors_states_col[2][$j+12]["state_html"].'.ilocalize.com';
// $threeth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("threeth_column_link", $parameters);
$tpl->set_var("threeth_column", tohtml($vendors_states_col[2][$j+12]["name"]));

$parameters = 'http://'.$vendors_states_col[3][$j+18]["state_html"].'.ilocalize.com';
// $fourth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fourth_column_link", $parameters);
$tpl->set_var("fourth_column", tohtml($vendors_states_col[3][$j+18]["name"]));

$parameters = 'http://'.$vendors_states_col[4][$j+24]["state_html"].'.ilocalize.com';
// $fifth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fifth_column_link", $parameters);
$tpl->set_var("fifth_column", tohtml($vendors_states_col[4][$j+24]["name"]));

$tpl->parse("ShowLocalResourcesCA", true);
$j++;
}
}

HTML CODE:
Code: [Select]
<table border="0" cellpadding="1" cellspacing="1"  class="description_text2"  style="padding-bottom:6px;" width="100%" id="dashed_box_gray">
             <!--BeginShowLocalResourcesCA-->
                <tr>
                    <td width="110" align="left" style="padding-left:6px; padding:6px;"><a href="{first_column_link}" class="user_blue_14px">{first_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{second_column_link}" class="user_blue_14px">{second_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{threeth_column_link}" class="user_blue_14px">{threeth_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{fourth_column_link}" class="user_blue_14px">{fourth_column}</a></td>
                    <td width="108" align="left" style="padding-right:6px; padding:6px;"><a href="{fifth_column_link}" class="user_blue_14px">{fifth_column}</a></td>
                </tr>
                <!--EndShowLocalResourcesCA-->
                </table>

 what I need is for a loop to run to make tabbed pannels according to categories.  then I need the buttons to be put into the correct tab based on the category it falls under.  then a subcategory tabs inside the other tabs for products that have that specific sub category.

here is what I sorta made....it doesn't work though....

Code: [Select]
<div id="TabbedPanels1" class="TabbedPanels">
        <ul class="TabbedPanelsTabGroup"><?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
         
<li class="TabbedPanelsTab" tabindex="0"><?php echo $category; ?></li>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
 <?php
// set layout vars
$x = 1; // set $x
$start = array ('1', '10', '19', '28', '37', '46', '55', '64', '73', '82', '91', '100', '109', '118', '127', '135'); //columns will be started at each of these numbers
$end = array( '9', '18', '27', '36', '45', '54', '63', '72', '81', '90', '99','108','117', '126' ); // set numbers to end columns at
?>

        <?php echo '<table border="1px" cellpadding="0px" cellspacing="0px" ><tr height=\'50px\'>'; //start the table, and the row.
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products where category=".$category."");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
$id =$row["id"];
$price =$row["price"];
if (in_array($x, $start)) { // if x equals a number in the start array
echo '<td width="100">';                   // start a column
} ?>

     <?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
         
<?php
}
?>
     
       
    <div id="products">
      <form action="" method="POST" name="myform<?php echo $id; ?>" class="myform<?php echo $id; ?>">
        <input type="hidden" name="hiddenField" class="hiddenField" value="<?php echo $product; ?>" />
        <input type="hidden" name="hiddenField2" class="hiddenField2" value="<?php echo $id; ?>" />
        <input type="hidden" name="hiddenField1" class="hiddenField1" value="<?php echo $price; ?>" />
      <input type="submit" name="submit" class="submit" value="<?php echo $product; ?>" style="background-color:lightgreen; height:50px; padding: 0px; margin:0px; width:100px;">   </form>
    </div>   
<?php
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - put in a line break
} else { // else if it DOES equal 9, 18 ,etc end the column
echo '</td>';
}
$x ++; // increase x to keep count
} // while loop ends
//now outside of the loop, 
$x = $x - 1; //subtract the last $X++ so you know exactly how many buttons were added
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - end the column as it wouldn't have ended itself
echo '</td>';
}
echo '</tr></table>'; // close the row and table

?><?php
}
?>             </div>     

   </ul>
       
      </div> 
any help is greatly appreciated.

I am trying to create 3 columns of data from a query.  I have used this code before for 2 columns but and now wanting to use for three columns.   There are 5 records from a join query.  The first two columns display the results, 2 results in the left column and 3 results in the center column.  The right column displayw empyt text used in displaying the results, there is no data to populate and it seems to mimic the the number from the center, 3.   Here is the URL to see the problem   http://specialslocat...ignID=1IBu3992p   Here is the Code for the query and the 3 column results.

<?php
$UN_URL = $_GET['un'];
$mS_MGMTcampaignID_URL = $_GET['mS_MGMTcampaignID'];
?>

<table width="944" border="1" align="center" cellpadding="0" cellspacing="0">

<?php 

$result = mysql_query( "SELECT * FROM manager_Specials_company_mgmt MSCM LEFT JOIN b2c_coupons B2CC ON (MSCM.mS_MGMT_id = B2CC.m_primeID )WHERE mS_MGMTcampaignID = '$mS_MGMTcampaignID_URL' ORDER BY mS_MGMT_m_company ASC" );
		$num_results = mysql_num_rows($result);
		$numb_tb_rows= ceil($num_results/3)
?>

<?
if ( $numb_tb_rows > 0 ) {
?>
	<tr >
	      <td colspan="4" valign="top"  class="body_text_10_Center"><strong><?=$mS_campaignName_mS?> is proud to sponsor <?=$num_results?> 
<?		
if ( $num_results == 1 ) {
?>
company:</strong>
<?
} elseif ( $num_results > 1 ) {
?>
companies:</strong>
<?
} 
?>

</td>


	</tr>


	<tr class="body_text_10_Center">

<!-- Column 1 -->
	<td width="320" class="body_text_10_Center" valign="top">


<? // column #1
	if($num_results>=1)
	{
		for($i=0; $i<$numb_tb_rows; $i++)
		{
			$row= mysql_fetch_array($result);
?>



<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />



<?	// END column #1		
		}
	}
?>		

	</td>
		
		
		


		
<!-- Column 2 -->
		<td width="320" class="body_text_10_Center"  valign="top">
		
		
<? // column #2
	if($num_results>=2)
	{
		for($i=($numb_tb_rows); $i<$num_results; $i++)
		{
			$row= mysql_fetch_array($result);
?>

<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />	

<?	// END column #2		
		}
	}
?>	
		</td>
		
		
		


<!-- Column 3 -->
		<td width="320" class="body_text_10_Center"  valign="top">
		
		
<? // column #3
	if($num_results>=3)
	{
		for($i=($numb_tb_rows); $i<$num_results; $i++)
		{
			$row= mysql_fetch_array($result);
?>
<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />

<?	// END column #3		
		}
	}
?>		
		</td>

	</tr>


 <?	
} else {
	echo "";
}
?>



</table>

Thanks for any help in advance. Mike

I am trying to return all  the photos in the database that has the albumid associated with that table info. I can echo the $album->id (albumid) no problem, but my query it think is somewhat off. Please anyone.

Code: [Select]
<div id="photo-items" class="photo-list-item">
<?php
echo $album->id.'<br>';

// fetch album photos and ids
$database    =& JFactory::getDBO();
$query  = "SELECT * FROM jos_photos where albumid  = ".$album->id." ORDER BY ASC";
$photos = mysql_query($query);  //This returns and array of photos, but then needs to display all the photos in loop below, but it not retuning none, even if there is 100 photos in table and in the folder directory

if($photos)
{
for( $i=0; $i<count($photos); $i++ ){
$row =& $photos[$i];
?>
<div class="photo-item" id="photo-<?php echo $i;?>" title="<?php echo $this->escape($row->caption);?>">
<a href="<?php echo $row->link;?>"><img class="" src="<?php echo $row->getThumbURI();?>" alt="<?php echo $this->escape($row->caption);?>" id="photoid-<?php echo $row->id;?>" /></a>
<?php
if( $isOwner )
{
?>
<div class="photo-action">
<a href="javascript:void(0);('<?php echo $row->id;?>');" class="remove"><?php echo JText::_('CC REMOVE');?></a>
</div>
<?php
}
?>
</div>
<?php
}
}
else
{
?>
<div class="empty-list"><?php echo JText::_('CC NO PHOTOS UPLOADED YET');?>   <button class="button button-upload" href="javascript: void(0);&amp;userid=88" id="upload-photos-button">Start Uploading</button></div>
<?php
}
?>
</div>

Hi guys.  So I have a little coding down but I am stuck on this problem:

/* Using only a array and a foreach loop, write a program that prints the days of the week *\

$days = array {
         'Monday',
         'Tuesday',
         'Wednesday',
         'Thursday',
         'Friday',
         'Saturday',
         'Sunday',
};

//This is where I need help with the code

          echo  "$day \r\n";

?>

Thanks in advance!

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'm trying to get a simple table to display and am not sure how to make it happen.  Table will have just 2 columns.  A TIME and an EVENT.  What I want to have happen is for the first row to show the TIME and next to that, the EVENT.  If a TIME has more than one event going I want the next row to show an empty first cell and then the second event below the first.

If I set up the loop the only way I know how (so far) it would also output the TIME value again and again as many times as there were events for that same time.  For example what I don't want is:

9:15  Sunday School
9:15 Nursery Available

What I do want is:

9:15 Sunday School
        Nursery Available

Thanks.

Hey.   So the issue I'm having is consecutive loops on semi-large arrays, over and over. Consider this array:

$firstArray = array(
'row1' => array(
'dates' => array(
'2014-01-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
),
'row2' => array(
'dates' => array(
'2014-02-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-08' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-09' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
)
);

Originally the data comes from ~2-3 database tables, of course. But to ilustrate the point, this is how the main array looks like. This array usually contains anywhere between 10-50 rows, each row containing at least 10 dates, with 10 key/values each.   And after setting up all the data, it needs to be processed. Currently this is how a friend of mine did it..

$placeDataHere = array();
foreach($firstArray as $key => $dates) {
foreach($dates as $date => $values) {
foreach($values as $key => $value) {
$placeDataHere['DV_' . $date]['SM_' . $key] = 'KS_' . $value;
//Followed by another ~50-70 lines of processing the 3 loop's data..
...
...
....
....
....
....
....
....
}
}
}

Obviously this isn't good practise, but we can't seem to figure out a better way of doing it, since both the data and the loops are horribly nested.   This loop and setup of $firstArray is run anywhere between 10-20 times/request, due to amount of users we wish to process. So, the result is that this code can take up to over 2-3 minutes to complete, which isn't really optimal performance.   In short my question is, are there any better methods of handling this with the data setup we currently have?

Below is my output on the browser:

    Student: Kevin Smith (u0867587)
    Course: INFO101 - Bsc Information Communication Technology Course Mark 70 Grade
    Year: 3
   
   
    Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B
   
    Session: AAB Session Mark: 72 Session Weight Contribution 20%
   
    Session: AAE Session Mark: 67 Session Weight Contribution 40%


    Module: CHI2513 - Systems Strategy Module Mark: 31 Mark Percentage: 62 Grade: B
   
    Session: AAD Session Mark: 61 Session Weight Contribution 50%

Now where it says course mark above it says 70. This is incorrect as it should be 65 (The average between the module marks percentage should be 65 in the example above) but for some stange reason I can get the answer 65. I have a variable called $courseMark and that does the calculation. Now if the $courseMark is echo outside the where loop, then it will equal 65 but if it is put in while loop where I want the variable to be displayed, then it adds up to 70. Why does it do this.
   
    Below is the code:

Code: [Select]
    $sessionMark = 0;
    $sessionWeight = 0;
    $courseMark = 0;
   
    $output = "";
   
    $studentId = false;
    $courseId  = false;
    $moduleId  = false;
   
    while ($row = mysql_fetch_array($result))
    {
   
   
    $sessionMark += round($row['Mark'] / 100 * $row['SessionWeight']);
    $sessionWeight  += ($row['SessionWeight']);
        $courseMark = ($sessionMark /  $sessionWeight * 100);
   
          if($studentId != $row['StudentUsername'])
        {
   
            //Student has changed
            $studentId = $row['StudentUsername'];
   
            $output .= "<p><strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";
   
        }
             
        if($courseId != $row['CourseId'])
        {
   
            //Course has changed
            $courseId = $row['CourseId'];
   
            $output .= "<br><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Course Mark</strong>" round($courseMark) "<strong>Grade</strong>  <br><strong>Year:</strong> {$row['Year']}</p>\n";
   
        }
   
        if($moduleId != $row['ModuleId'])
        {
   
            //Module has changed
            if(isset($sessionsAry)) //Don't run function for first record
            {
   
                //Get output for last module and sessions
                $output .= outputModule($moduleId, $moduleName, $sessionsAry);
            }
   
            //Reset sessions data array and Set values for new module
   
            $sessionsAry = array();
            $moduleId    = $row['ModuleId'];
            $moduleName  = $row['ModuleName'];
        }
             
        //Add session data to array for current module
             
        $sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);
             
    }    //Get output for last module
   
    $output .= outputModule($moduleId, $moduleName, $sessionsAry);
   
    //Display the output
    echo $output;
I think the problem is that it is outputting the answer of the calculation only for the first session mark. How in the while loop can I do it so it doesn't display it for the first mark only but for all the session marks so that it ends up showing the correct answer 65 and not 72?

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();
    }?>

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..