PHP - Moved: Div Loop Onclick Show Recordsets Results

Hello all,

I am making a database with all the Boeing deliveries sorted by month. I made a index with all the months and when you click on a month you will get a full list of the type and quantity of aircraft that has been deliverd.

I have two problems and I can't figure it out.
The first problem I have, is that I want to show the visitors which airline has bougt which type of aircraft and how many.
The second problem I have is a want to show them the total amount of deliveries, not just per type of aircraft, but a total number.

Here are some shots of my problem and what I have:

This is how my MYSQL-database lookes like. The columns I have a id, day, month, year, airline, aircraft, amount (just a simple translation of the Dutch words ).
As you can see, there are some airlines that received one type of aircraft two times (TUI Travel PLC has received 2x Boeing 737-800). Keep this in mind, I will get back to this.


This is the table on my website. The first column shows the type of aircraft. The secon column shows us how many of that type has been deliverd. In the last column I want to have all the airlines that has received that type of aircraft. As I mentioned above, TUI Travel PLC has received 2x B737-800, so in the row of B737-800 I want to have TUI Travel PLC (2x). If the airline received more then 1 aircraft, I would like to have (.....x) (and the amount on the dots --> TUI example: 2 aircraft, so 2x). So you will get TUI Travel PLC (2x).

This is the code I have so far (sorry I am a real noobie in PHP/MYSQL so my programming ain't that great )

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

$maand = $_GET['maand'];
$jaar = $_GET['jaar'];


$query = "SELECT aircraft, jaar, maatschappij, COUNT(maatschappij) FROM deliveries_orders_boeing WHERE maand = '$maand' AND jaar = '$jaar' GROUP BY aircraft"; 
 
$result = mysql_query($query) or die(mysql_error());

// Print out result
echo "<br /><h3>Boeing deliveries ".$maand." ".$jaar."</h3><br />
<table border='0' width='700'>";
while($row = mysql_fetch_array($result)){

echo "<tr><td id='aircraft'>". $row['aircraft']. "</td><td id='aantal'>". $row['COUNT(maatschappij)'] ."</td><td id='maatschappijen'>different companies</td></tr>";
}
echo "<tr><td id='totaal'>Totaal</td><td id='totaal_aantal'>....</td><td></td></tr></table>";

?>
</td>
</tr>
</table>

Maybe a little confusing, but I hope someone can help me with this.

Kind regards,
Flyboeing

Hello dear friends,

I've made littel code that fetch the categories name from an software website


$text= file_get_contents('http://win.softpedia.com/');
// it make win.softpedia as text code

$start =  strstr("$text",'<ul id="windows_cat">');
// search inside to that start point

$end = strpos("$start",'" title="');
// end at it to that end point

$cat = substr($start,66,$end-66);
echo "$cat<hr>";

it will show now the categories but it only shows the 1st one
Antivirus/

how then loop it to find next and next and so on to show me the list of the categories !

thanks

Hi All,   I need to get a small function working for a site I need to build for a group of friends.   I was able to get a login page, and a way to add data to the data base.   Now I am stuck on the search and show results fuctionalities.   I have found tens of scripts on the internet, but most of them are outdated, or I cant get them to work, either it sends me back a blank page, does nothing or sends me to an error page   The GOAL User Inputs text in a text box, clicks submit, the data in the text box is looked for in the second collumn of the DB, The information of the collumns 2 to 7 of the DB for the name search are displayed either on the same page or on a new page.   Is there any chance you could hel me with that, taken into account that I dont need the html part of the code, I only need help with the php part...   Thanks in advance to all the people reading this and the ones helping me...

hi guys

i am building a voting system for my gaming website

people sign up for matches, and those will be played at 3-5 different maps
people can vote for wich maps they want to play

each player can choose 3 maps, also 3 x the same map

now the results of that voting system are shown on the page like this

There is 1 vote for Map 1
There are 5 votes for Map 2
There is 1 vote for Map 3
There are 2 votes for Map 7
There is 1 vote for Map 4
There is 1 vote for Map 5
There are 8 votes for Map 8

now i want to make a script that picks the maps that will be played, so only show the 3-5 best results

in the example above it woud be 2 x map 8 and 1x map 2
but im not sure how to start on this

the db table of the votes is built like this

id    matchid    playerid    mapid    mapname
1    113    195    1    NukeTown
2    113    195    2    Grid
3    113    195    1    NukeTown
4    114    195    1    NukeTown
5    114    195    1    NukeTown

any advice or thoughts on this?

thanks

Hello,

Here's the weird thing, some of the pages shows the results, and some pages just won't show results at all, and I'm not getting any errors

here is the one that doesn't

Code: [Select]
<?
function display_mptt($user) {
global $db;
// retrieve the left and right value of the $root node

$sql2 = "SELECT * from mptt where id='25'";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Users List</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE 'left' BETWEEN '".$row2['left']."' AND '".$row2['right']."' ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)or die(mysql_error())) {
  // only check stack if there is one
  $count = mysql_num_rows($result);
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
 
 // add this node to the stack

 
  $var3 = '10';
    echo "<table width='589' border='1'>
<tr>
<th>ID</th>
<th>Name</th>
</tr>";
 
 echo  "<tr><td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>";
echo "<td>" . $row['title'] ." </td>";

echo   "</tr>";
 
 echo "</table>";
  $right[] = $row['right'];
  }
 }
 
 

   display_mptt(1);     ?> 

and here is the page that does

Code: [Select]
<?
function display_mptt($user) {
global $db;
$id = $_GET['id'];
// retrieve the left and right value of the $root node
$sql2 = "SELECT * from mptt where id= ".$id."";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Your Tree</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE `left` BETWEEN ".$row2['left']." AND ".$row2['right']." ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)) {
  // only check stack if there is one
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
  echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right)).$row['title']."<br>";
 // add this node to the stack
  $right[] = $row['right'];
  }
 }
 
  display_mptt(1);
  ?>

I know the php is basic and not completed yet, but I am working on that. My next step I want the result to show on index.php when a form is submitted to calculator2.php. I just cant seem to get it. Please help!

index.php
Code: [Select]
<div class="post">
        <h2 class="title">Calculator</h2>
<hr />
         <form method="post" action="calculator2.php">
Fireplace Front Width: <input type="text" name="fw">
<br />
Fireplace Back Width: <input type="text" name="bw">
<br />
Fireplace Depth: <input type="text" name="fd">
<br />
<input type="submit" name="Submit" value="Submit">
</form>
            Pounds Of Glass Needed: <?php echo $res1; ?>

      </div>

calculator2.php
Code: [Select]
<?php
$frontwidth = $_POST['fw'];
$backwidth = $_POST['bw'];
$firedepth = $_POST['fd'];
$x = $frontwidth + $backwidth+ $firedepth;
$y = ($x / 3) * .6667; 
$res1 = $y *2;
echo $res1;
?>

Hello,

I have a database that contains a column with a int value for number of slots reserved, and what I want to do is fetch the value of each column and add them together to create one whole number. For example, in my database under preserved I have two separate values of 2 and 4.. I would like to take those two values and add them up into 6 through php... here is what I have so far:


$slots = mysql_query("SELECT * FROM treservations WHERE reservation_date='$reservation_date' AND reservation_hour='$reservation_hour'") or die(mysql_error());
while ($row = mysql_fetch_assoc($slots)) {
     $row["preserved"];
}

mysql_free_result($slots);

Any help would be GREATLY appreciated.. if I need to add additional code please let me know. Thank you!

Hello all,

I've built a database of coupons. Each coupon is assigned to a category (so all electronics coupons display under electronics). On my category list I'd like to display how many coupons is in each category.

Currently this function displays my category list:
function fetch_categories() {
mysql_connect(SQL_HOST_NAME, SQL_USER_NAME, SQL_PASSWORD) or die(mysql_error());
mysql_select_db(SQL_DATABASE) or die(mysql_error());
$result = mysql_query("SELECT * FROM categories ORDER BY category_name")or die(mysql_error());

echo '<div id="category_list">';
echo '<ul class="cat_list">';

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

//get total of discounts in each category
$count_result = mysql_query("SELECT * FROM category_relations, discounts WHERE category_relations.member_of = '$row[id]' AND discounts.active = '1'")or die(mysql_error());
$num_rows = mysql_num_rows($count_result);
echo '<span class="numrows">('.$num_rows.')</span>';

echo '<li><a href="index.php?cat_ID='.$row['id'].'">'.$row['category_name'].'  </a></li>';
}

echo '</ul>';
echo '</div>';
}

The above is a debug version so it's not all formatted correctly.

However right now, that exports "3" for Airlines when right now, I have only one discount in the entire database.

This is my category_relations table:
Code: [Select]
--
-- Table structure for table `category_relations`
--

CREATE TABLE IF NOT EXISTS `category_relations` (
  `id` int(10) NOT NULL,
  `member_of` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_relations`
--

INSERT INTO `category_relations` (`id`, `member_of`) VALUES
(2, 2),
(1, 1),
(3, 1),
(4, 1);

And this is my discounts table:
Code: [Select]
--
-- Table structure for table `discounts`
--

CREATE TABLE IF NOT EXISTS `discounts` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `redeem` tinyint(3) NOT NULL,
  `discount_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `short_description` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `eligibility` blob NOT NULL,
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `coupon_code` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `long_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `business_name` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `store_location_street` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `store_location_city` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `store_location_state` char(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `store_location_zip` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `categories` blob NOT NULL,
  `level` tinyint(5) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `user_id` varchar(2555) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `level` (`level`,`active`),
  KEY `user_id` (`user_id`(333))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `discounts`
--

INSERT INTO `discounts` (`id`, `redeem`, `discount_title`, `short_description`, `eligibility`, `url`, `coupon_code`, `start_date`, `end_date`, `long_description`, `logo`, `business_name`, `phone`, `store_location_street`, `store_location_city`, `store_location_state`, `store_location_zip`, `categories`, `level`, `active`, `user_id`) VALUES
(1, 0, '$2.00 Off Transportation', '', 0x4172726179, 'www.baysideshuttle.com', '', '2010-01-01 00:00:00', '2011-01-01 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer varius ipsum id justo pellentesque laoreet. Curabitur tempus tincidunt...', NULL, 'Bayside Airport Shuttle', '850-123-3456', NULL, NULL, NULL, NULL, 0x4172726179, 0, 1, '24');

It seems to be completely ignoring my active check. How can I fix this, or is there a better way to do this query?

I am using a foreach loop to get the results of an array. My problem is that I need the results combined into one string. How can I accomplish this?

Hi, I'm developing a "gallery" script so that I can manage my photos online, and I'm having a problem I can't seem to figure out. Hoping someone can help...

So here's my problem.

I have two main tables for my application (amongst several others but for all intents and purposes they aren't needed). One is "albums" and the other "photos".

Here's the structure for both:
Code: [Select]
Albums

CREATE TABLE IF NOT EXISTS `kill4silence_photos_albums` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `parent_id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `cover` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL,
  `time` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `last_updated_date` varchar(50) NOT NULL,
  `last_updated_time` varchar(50) NOT NULL,
  `last_updated_timestamp` int(255) NOT NULL,
  `views` int(255) NOT NULL,
  `tags` longtext NOT NULL,
  `downloads` int(255) NOT NULL,
  `download_disabled` int(1) NOT NULL,
  `comments_disabled` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=156 ;

-----------------------------------------------------------------------------------------
Photos

CREATE TABLE IF NOT EXISTS `kill4silence_photos_photos` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `album_id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `caption` varchar(200) NOT NULL,
  `time` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `file_name` varchar(5000) NOT NULL,
  `file_type` varchar(100) NOT NULL,
  `file_ext` varchar(25) NOT NULL,
  `location` varchar(200) NOT NULL,
  `photo_time` varchar(50) NOT NULL,
  `photo_date` varchar(50) NOT NULL,
  `views` int(255) NOT NULL,
  `tags` longtext NOT NULL,
  `downloads` int(255) NOT NULL,
  `downloads_disabled` int(1) NOT NULL,
  `comments_disabled` int(1) NOT NULL,
  `visible` int(1) NOT NULL,
  `last_updated_date` varchar(50) NOT NULL,
  `last_updated_time` varchar(50) NOT NULL,
  `last_updated_timestamp` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=204 ;

Now basically how this works is when a new album is created, it is given a parent_id of '0' where the parent_id is the identifer of it's "parent" album.

Say, I have five albums, each nested within each other like so.

1, 2, 3, 4, 5.

On the page, it would look like,

Album 1 (link that takes you to Album 2)

Album 2 (link that takes you to Album 3)

And so on...

I use $_GET to send you to the next nested album.

Each album's query string looks like this:
Code: [Select]
photos.php?album={$id}

No matter what album you're in (be it the "father" parent album or a nested album)

Now, what I want to do is construct a method to add to my "photos" class, that creates an array of all parent album id's depending on the current nested album, so I can use that array to display a "navigation" type thingy-ma-jigger at the top of each page. For example:

Current album is "Ghosts"

Navigation would look like: Paranormal Activity -> Experiences -> Ghosts

Where "Ghosts" and "Experiences" are albums nested in "Paranormal Activity"

I figure you'd have to go about this using a loop of some kind, but I can't for the life of me figure it out. The only thing I can think of to do that doesn't entirely solve this problem is get the parent id of the current album. So as of right now, if "Ghosts" is currently being displayed, I can output a link taking you to "Experiences", but I can't do so to get "Paranormal Activity". I mean I could, but I'd have to loop through twice to get both ID's. I need a method that will loop through infinitely until there are no more parent albums to be found.

Hope this all makes sense.

Here's my code for viewing an album, just so you can get a clear picture (I'm using the Smarty extension case the HTML code confuses you)
Code: [Select]
<div id='view_album'>
    <!--<a href='photos.php?album={$PARENT_ALBUM_ID}'>&laquo; Back to {$PARENT_ALBUM_NAME}</a>-->
    <div class='album_name'>
        {$ALBUM_NAME}
    </div>
    <div class='album_info'>
        Created by <a href=''>{$USERNAME}</a> (<a href="photos.php?album={$PARENT_ALBUM_ID}">{$PARENT_ALBUM_NAME}</a>) {$DATE_FANCY} &bull; Updated {$LAST_DATE_FANCY}
        {if strlen($LOCATION) > 0}
         &bull; Taken at {$LOCATION}
        {/if}
        {if $smarty.const.PHOTOS_ADMIN_ACCESS == true}
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=edit'>Edit Album</a>
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=delete'>Delete Album</a>
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=upload&max=1&submit=false'>Upload Photos</a>
        {/if}
    </div>

<!--Start albums-->
    {$i= 0}
    {$max_columns = 5}
    {$column_width = 100 / {$max_columns}}
    <table width='100%'>
        {foreach $ALBUMS_ARRAY as $id => $id}
        {if $i == 0}
            <tr>
            {/if}
                <td width='20%' align='center'>
                    <div class='album_graphic_container'><a href='photos.php?album={$id}'>
                    {if {albums::info ("id", "=", {$id}, "cover")} == 0}
                            <a href="photos.php?album={$id}"><img src='photos/images/icons/album_default.png'></a>
                        {else}
                        <img src='photos/covers/{$id}/default.jpg' style="width: 100%;"/>
                        {/if}
                    </div>
                    <div class='album_graphic_info'>
                        <a href='photos.php?album={$id}'>{albums::info ("id", "=", {$id}, "name")}</a>
                        <br>
                        {albums::info ("id", "=", {$id}, "num_albums")} Albums &bull; {albums::info ("id", "=", {$id}, "num_photos")} Photos
                        <br>
                        <a href='' style='font-size: 100%;'>{albums::info ("id", "=", {$id}, "num_comments")} Comments</a>
                    </div>
                </td>
            {$i = $i + 1}
            {if $i == $max_columns}
                </tr>
                {$i = 0}
            {/if}
        {/foreach}
        {if $i < $max_columns}
            {$j = 0}
            {for $k = $i; $k < $max_columns - 1; $k++}
                {if $j == 0}
                    <td width='{$column_width}%' align='center'>
                        <div class='album_graphic_container'>
                            <a href='photos.php?album={$ALBUM_ID}&action=compose'>
                            <img src='photos/images/icons/album_default.png'>
                            </a>
                        </div>
                        <div class='album_graphic_info'>
                            <a href='photos.php?album={$ALBUM_ID}&action=compose'>+ Add New Album</a>
                            <br>
                            &nbsp;
                            <br>
                            &nbsp;
                        </div>
                    </td>
                {/if}
                {$j = 1}
                <td width='{$column_width}%' align='center'>&nbsp;</td>
            {/for}
        {else}
        {/if}
</table>

<!--Start photos-->
    <div class='view_album_lft'>
        {if {albums::info ("id", "=", {$ALBUM_ID}, "num_photos")} == 0}
        &nbsp;
        {else}
            <!--<div class='view_album_photos_header'>";
            Photos In <a href=''>" . albums::info ("id", "=", $_GET["album"], "name") . "</a> (" . albums::info ("id", "=", $_GET["album"], "num_photos") . ")";
            </div>";-->
            {$p = 0}
            {$p_max_columns = 6}
            {$p_column_width = 100 / $p_max_columns}
            <table width='100%'>
                {foreach $PHOTOS_ARRAY as $id => $id}
                {if $p == 0}
                    <tr>
                    {/if}
                    <td width='{$p_column_width}%' align='center'>
                        <div class='album_graphic_container'>
                        <a href='photos.php?album={$ALBUM_ID}&photo={$id}'><img src='{photos::info ("id", "=", $id, "src_thumb_medium")}' style='width: 100%;'></a>
                        </div>
                        <div class='album_graphic_info'>
                            {photos::info ("id", "=", {$id}, "views")} Views
                            <br>
                            {photos::info ("id", "=", {$id}, "num_comments")} Comments
                        </div>
                    </td>
                    {$p = $p + 1}
                    {if $p == $p_max_columns}
                        </tr>
                        {$p = 0}
                    {/if}
                {/foreach}
                {if $p < $p_max_columns}
                    {for $q = $p; $q < $p_max_columns; $q++}
                        <td width='{$p_column_width}%'>&nbsp;</td>
                    {/for}
                {/if}
            </table>
        {/if}
    </div>
   
    <div class='album_info_2_lft'>
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == -1}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=like">Like this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=dislike">Dislike this album</a>
        {/if}
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == 1}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=unlike">Unlike this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=dislike">Dislike this album</a>
        {/if}
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == 0}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=like">Like this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=undislike">Undislike this album</a>
        {/if}
    </div>
    <div class='album_info_2_rt'>
    {$DOWNLOADS} Downloads &bull; <a href="photos.php?album={$ALBUM_ID}&action=download">Download this album</a>
    </div>
    <br clear="all" />

    <!--<div class='view_album_rt'>
        <div class='view_album_rt_header'>
            Share This Album
        </div>
        <div class='view_album_rt_header'>
            Download This Album
        </div>
        <a href=''>Low Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_low")})</a>
        <br>
        <a href=''>Medium Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_medium")})</a>
        <br>
        <a href=''>High Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_high")})</a>
        <br>
        <a href=''>Full Size Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_full")})</a>
    </div>
   
    <br clear='all'>-->
   
    <div class='view_album_comments_container'>
        <div class='view_album_comments_header'>
            All Comments ({$ALBUM_NUM_COMMENTS})
        </div>
   
        <div class='view_album_comments_add'>
            {if !{$PHOTOS_USER_LOGGED}}
                You must <a href='login.php'>login</a> or <a href='register.php'>sign up</a> in order to post comments
            {else}
                {if $COMMENTS_DISABLED == 0}
                    <div class='view_album_comments_single_wrapper'>
                        <div class='view_album_comments_single_lft'>
                            <img src='members/{users::info ($smarty.const.PHOTOS_MEMBERS_FIELD_ID, "=", $smarty.const.PHOTOS_USER_ID, "avatar_src")}'>
                        </div>
                        <div class='view_album_comments_single_rt'>
                        <form action='photos.php?album={$ALBUM_ID}&comment=new&action=add' method='post'>
                            <input type='hidden' name='parent_id' value='0' />
                            <textarea name='body' placeholder="Write your response" class='view_album_comments_add_textarea'></textarea>
                            <span style="float: right;"><input type="submit" class="fb_button_blue" value="Post Comment" /></span>
                            </form>
                        </div>
                        <br clear='all'>
                    </div>
                {else}
                    Comments for <a href=''>{$ALBUM_NAME}</a> has been disabled
                {/if}
            {/if}
        </div>

        {foreach $COMMENTS_ARRAY as $id => $id}
            <div class='view_album_comments_single_wrapper'>
                <div class='view_album_comments_single_lft'>
                    <img src='members/{users::info ($smarty.const.PHOTOS_MEMBERS_FIELD_ID, "=", {comments::info ("id", "=", {$id}, "user_id")}, "avatar_src")}'>
                </div>
                <div class='view_album_comments_single_rt'>
                    <div class='view_album_comments_single_rt_username'><a href=''>{comments::info ("id", "=", {$id}, "username")}</a></div>
                    <div class='view_album_comments_single_rt_body'>{comments::info ("id", "=", {$id}, "body")}</div>
                    <div class='view_album_comments_single_rt_info'>
                        {comments::info ("id", "=", {$id}, "date_fancy")}
                        &bull; <a href="">Like</a> | <a href="">Dislike</a>
                        {if $smarty.const.PHOTOS_USER_LOGGED == true}
                            {if $smarty.const.PHOTOS_ADMIN_ACCESS || $smarty.const.PHOTOS_USER_ID == {comments::info ("id", "=", {$id}, "user_id")}}
                                &bull; <a href="">Delete</a>
                            {/if}
                        &bull; <a href="">Report</a>
                       {/if}
                    </div>
                </div>
                <br clear="all" />
            </div>
        {/foreach}
       
        <div id='view_album_comment_report'>
        <div id='view_album_comment_report_body'>
            <span class='view_album_comment_report_body_header'>Report Comment</span>
            </div>
        </div>
       
    </div>
   
</div>

Need more info, just ask. Thanks.

I have a script that runs a MySQL query and loops through a bunch of results.   For each person's name, I have a short bio that I want to show/hide by clicking on the person's name.  I have a basic start, but I can't figure out how to show/hide them individually. When I click on someone's name, it shows/hides all of the bio's.  I do have an individual ID for each person, and could use that somehow, but I'm scratching my head trying to figure out how to accomplish that.  Any ideas?   http://jsfiddle.net/APA2S/3644/  

Hello:

I'm trying to figure out how to NOT show emailed results if the checkbox is empty (not checked).

I only want it included in the message of the email if the checkbox was checked.

It is writing the data to the email properly, but it is including some of the code as well.

This is my email code:
Code: [Select]
mail( "me@digital.com", "Sign-up Sheet Request",


"Date Sent: $myDate\n

Parent's Name: $ParentsName
Best Phone: $BestPhone
Email: $Email
Student's Name: $StudentsName
Student's School: $StudentsSchool\n\n



if(trim($SATTest1) != \"\" ) {
echo \"$SATTest1\";
}



",

"From: $Email"


);

The "$SATTest1" data is displaying properly in the emails, but so is some of the code.
Like this:
Code: [Select]
if(trim(Reading and Math Classes for March 10) != "" ) { echo "Reading and Math Classes for March 10"; }

Any idea how to correct this?

Thanks!

Hi again PhpFreaks, yet again I got a problem regarding coding.

Hey guys, I'm building an E-commerce store for a T-Shirt selling company, I've assembled the shopping cart etc correctly but I am having problems within building a forum based system for the site admin to post Bulletins and Notices to the homepage + a blogging page.
I am using a while loop which should iterate the results at the end of each cycle through my variable $postResult

Here is my code...

<?php

include_once "../scripts/db_connect.php"; // Connect to the database
// Get the section ID from the url variable coming in
$sqlout = mysql_query("SELECT * FROM blog_posts ORDER BY ordered ASC LIMIT 10");

if (isset($_GET['id']) && $_GET['id'] != "") {
   $sid = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter all characters except numbers for security
} else {
   echo "ERROR: Variables to run this script have been removed from the URL.";
   exit();
}
// Query the database for that section id, make sure it exists and get the section title
$sql = mysql_query("SELECT * FROM blog_category WHERE forum_id='$sid' LIMIT 1");
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
   echo "ERROR: That section deos not exist you have tampered with our URLs.";
   exit();
}
while($row = mysql_fetch_array($sql)){
   $sectionTitle = $row["forum_title"];
}
// Use the section ID to query the "forum_posts" table in the database to get all the threads for this section
$sql = mysql_query("SELECT * FROM blog_posts WHERE type='a' AND section_id='$sid' ORDER BY date_time DESC LIMIT 10");
$postResult = '';
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
   $postResult = "There are no threads in this section yet. You can be the first to post.";
} else {
   while($row = mysql_fetch_array($sql)){
       $thread_id = $row["id"];
      $post_author = $row["post_author"];
      $post_author_id = $row["post_author_id"];
      $date_time = $row["date_time"];
      $convertedTime = ($myAgoObject -> convert_datetime($date_time));
        $whenPost = ($myAgoObject -> makeAgo($convertedTime));
      $thread_title = $row["thread_title"];
      $dynamicList .= '<img src="style/threadPic.jpg" width="26" height="18" alt="Topic" /> ' . $post_author . ' - <a href="view_thread.php?id=' . $thread_id . '">' . $thread_title . '</a> - ' . $whenPost . '<br />';
   }
}
?>

And here is a snippet of where I echo the results in my HTML:

      <br /><br />
      <div style="margin-left:12px; "><?php echo $postResult; ?></div>
    <br /><br /><br /></td>

I have been slaving over this for hours now, the first $postResult variable will always iterate its text of "There are no threads in this section yet. You can be the first to post.", I can't see anything wrong in my SQL syntax as I have a similar set up to iterate my products to different pages and that has always worked fine

Any input on this would be great

Kind Regards

Alex.

So I have 2 queries, that has the potential to return alot of data, foreach loops running. The first shows each group heading, and the foreach nested is calling another query specific to the group heading. The result currently is a lengthy delay in results showing. (Now this may/may not be the most ideal code practise in this instance however... short term solution discussion please).

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
   Next
Next

Is there a command or other where I can say, Display HTML page as it stands while it continues to process the FOREACH loops?

EG:

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
      REFRESH HTML DISPLAYED
   Next
Next