PHP - Multiple <ul> Lists Php Loop

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

I have a code that I am using to update multiple products at one time instead of one at a time. It works great except that my processing page is not updating the very last product. My process page is receiving all of my products as I know how many products that I am updating and I have my process page tell me how many products are updated as well as listing the name of each product updated. It is always the last product that is not updated.
Here is my process update code.
Code: [Select]
<?php

$size = count($_POST['casketid']);
//$size = 306;
$i = 1;
while ($i < $size) {

$product=$_POST['productid'][$i];//getting case #
$price=$_POST['price'][$i];
$model=$_POST['model'][$i];
$active=$_POST['active'][$i];

//Getting pricerange
if(($price > "0") && ($price <= "1000.00"))
$pricerange = "1";
elseif(($price >= "1001.00") && ($price <= "1500.00"))
$pricerange = "2";
elseif(($price >= "1501.00") && ($price <= "2000.00"))
$pricerange = "3";
elseif(($price <= "2001.00") && ($price <= "2500.00"))
$pricerange = "4";
elseif(($price <= "2501.00") && ($price <= "3000.00"))
$pricerange = "5";
elseif(($price >= "3001.00") && ($price <= "3500.00"))
$pricerange = "6";
elseif(($price >= "3501.00") && ($price <= "4000.00"))
$pricerange = "7";
elseif(($price >= "4001.00") && ($price <= "4500.00"))
$pricerange = "8";
elseif(($price >= "4501.00") && ($price <= "4500.00"))
$pricerange = "9";
elseif($price >= "5001.00")
$pricerange = "10";

$query = "UPDATE products SET price='$price', pricerange='$pricerange', active='$active' WHERE productid='$product'";
mysql_query($query) or die ("Error in query: $query");
echo "$model = $price & active = $active</em><br />$size<br />";
++$i;
}


?>

I have done select statements where you loop through all the records.
But what I need to do is pull record from one database than insert parts of that record
into the second. The issue I have is no knowing how to select a different db with out
stopping the loop of the first.

Thanks in advance. 

So here is what I a trying to do:

Code: [Select]

<?php

/**
 * @author 
 * @copyright 2010
 */
$res = mysql_query("SELECT * FROM `planetsTable` WHERE `section` = '1' LIMIT 9 ASC");
while($row = mysql_fetch_array($res)){ ?>
 
 
            <li>
            <span id="sun">Solar System Star</span>
            <p>The Sun is a star, a hot ball of glowing gases at the heart of our solar system. Its influence extends far beyond the orbits of distant Neptune and Pluto. Without the Sun's intense energy and heat, there would be no life on Earth. And though it is special to us, there are billions of stars like our Sun scattered across the Milky Way galaxy.</p>
            </li>
 
        <li>
            <span id="mercury"><?php echo $row[0]['name']; ?></span>
            <p>Sun-scorched Mercury is only slightly larger than Earth's Moon. Like the Moon, Mercury has very little atmosphere to stop impacts and it is covered with craters. Mercury's dayside is super heated by the Sun, but at night temperatures drop hundreds of degrees below freezing. Ice may even exist in craters. Mercury's egg-shaped orbit takes it around the Sun every 88 days.</p>

            </li>
           
            <li>
            <span id="venus"><?php echo $row[1]['name']; ?></span>
            <p>Venus is a dim world of intense heat and volcanic activity. Similar in structure and size to Earth, Venus' thick, toxic atmosphere traps heat in a runaway 'greenhouse effect.' The scorched world has temperatures hot enough to melt lead. Glimpses below the clouds reveal volcanoes and deformed mountains. Venus spins slowly in the opposite direction of most planets.</p>
            </li>
           
            <li>
            <span id="earth"><?php echo $row[3]['name']; ?></span>

            <p>Earth is an ocean planet. Our home world's abundance of water - and life - makes it unique in our solar system. Other planets, plus a few moons, have ice, atmospheres, seasons and even weather, but only on Earth does the whole complicated mix come together in a way that encourages life - and lots of it.</p>
            </li>
           
            <li>
            <span id="mars"><?php echo $row[4]['name']; ?></span>
            <p>Though details of Mars' surface are difficult to see from Earth, telescope observations show seasonally changing features and white patches at the poles. For decades, people speculated that bright and dark areas on Mars were patches of vegetation, that Mars could be a likely place for life-forms, and that water might exist in the polar caps. When the Mariner 4 spacecraft flew by Mars in 1965, many were shocked to see photographs of a bleak, cratered surface. Mars seemed to be a dead planet. Later missions, however, have shown that Mars is a complex member of the solar system and holds many mysteries yet to be solved.</p>
            </li>
           
            <li>

            <span id="jupiter"><?php echo $row[5]['name']; ?></span>
            <p>The most massive planet in our solar system, with four large moons and many smaller moons, Jupiter forms a kind of miniature solar system. Jupiter resembles a star in composition. In fact, if it had been about 80 times more massive, it would have become a star rather than a planet.</p>
            </li>
           
            <li>
            <span id="saturn">Saturn</span>
            <p>Saturn was the most distant of the five planets known to the ancients. Like Jupiter, Saturn is made mostly of hydrogen and helium. Its volume is 755 times greater than that of Earth. Winds in the upper atmosphere reach 500 meters (1,600 feet) per second in the equatorial region. These super-fast winds, combined with heat rising from within the planet's interior, cause the yellow and gold bands visible in the atmosphere.</p>
            </li>

           
            <li>
            <span id="uranus">Uranus</span>
            <p>The first planet found with the aid of a telescope, Uranus was discovered in 1781 by astronomer William Herschel. The seventh planet from the Sun is so distant that it takes 84 years to complete one orbit.</p>
            </li>
           
            <li>
            <span id="neptune">Neptune</span>
            <p>Nearly 4.5 billion kilometers (2.8 billion miles) from the Sun, Neptune orbits the Sun once every 165 years. It is invisible to the naked eye because of its extreme distance from Earth. Interestingly, the unusual elliptical orbit of the dwarf planet Pluto brings Pluto inside Neptune's orbit for a 20-year period out of every 248 Earth years</p>

            </li>
           
            <li>
            <span id="pluto">Pluto</span>
            <p>Tiny, cold and incredibly distant, Pluto was discovered in 1930 and long considered to be the ninth planet. But after the discoveries of similar intriguing worlds even farther out, Pluto was reclassified as a dwarf planet. This new class of worlds may offer some of the best evidence of the origins of our solar system.</p>
            </li>
        </ul>
   
<?}

?>

What I need to know is if this is possible and if so how would I got about doing this?
Code: [Select]
<?php 
$row['0']['name']; // Main Issue.
?>
McBryver

Let me explain my problem. I have an array with dates and numbers in format ($cronograma)

Ex:

Array ( [2020-09-21] => Array ( [0] => 2020-09-21 [1] => 2 [2] => 2 [3] => 2 ) [2020-09-28] => Array ( [0] => 2020-09-28 [1] => 2 [2] => 2 [3] => 4 )

Then i have another array with 2 ids (in this case 58,60) ($id)

Finally i have a third array with numbers only (in this case 34,34) $tot

So what i want is cross information beween them, for example for id 58 I must get dates (first element and last element when $tot = 34) for id 60 I must get dates (first element after $tot =34 and last element of array)

Whath i have so far is this

foreach ($id as $idPlan) { foreach ($cronograma as $c) { $t1 = 0; foreach ($tot as $d) { $t1 += (int)$d['tempos']; if ($c[3] == $t1) { $newAr[] =$idPlan; $newAr[] = $c[0]; } } } }

My response

array(8) { [0]=> string(2) "58" [1]=> string(10) "2021-02-01" [2]=> string(2) "58" [3]=> string(10) "2021-06-14" [4]=> string(2) "60" [5]=> string(10) "2021-02-01" [6]=> string(2) "60" [7]=> string(10) "2021-06-14" } null

So it's clear that i have all repeated

I should have a line like:

58 - 2020-09-21 -2021-02-01

Any help?

Hi iam currently writing some code for my website and i have a number of records that i simply want to display in a table format, i have done this in a while loop and it works well, however i only want to display a maximum of 10 records per page as my div needs to be a fixed height and was wondering how i could include a next button that would act as like a page number. The thing is at any given point there could be from 1 record to display to 500, so i need a way of allowing the user to quickly navigate to the other records. How can i do this without using mulitple pages.

Hope this makes sense.

Heres my code

Code: [Select]
<?php echo"<table width='100%' border='1' align='center'><tr><th>Referal Name</th><th>Amount Received</tr>";
while ($row = mysql_fetch_array($sql_info))
{
extract($row);
echo "<tr><td align='center'>".$username."</td><td align='center'>".$cumulative_referral."</td></tr>";
}
echo "</table>";


?>
Thanks for your help

Hello,

I'm working on a script which should read lines from a file keyword.txt create a new file with that variable name, insert the content close and loop through all the lines in the keyword file. The loop itself works but now that i'm adding the fopen fwrite and fclose i'm running into trouble. I'm not that great a coder and have pieced this together so far. I'd appreciate any suggestions on how to fix the fopen and other file functions to create unique files using the keywords from the file

Thanks in advance


<?php
$read_file = file('keywords.txt');
foreach($read_file as $var)
    {
    $file = fopen($var, "x");
$content = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />
<title>This is the title</title>
</head>
<body>
<h2>The keyword is $var</h2>
<p><p>
</body>
</html>";
fwrite($file, $content);
fclose($file);
    }
?>

good day dear community,

i am workin on a Curl loop to fetch multiple pages:

i have some examples - and a question:

Example: If we want to get information from 3 sites with CURL we can do it like so:


$list[1] = "http://www.example1.com";
$list[2] = "ftp://example.com";
$list[3] = "http://www.example2.com";


After creating the list of links we should initialize the cURL multi handle and adding the cURL handles.


$curlHandle = curl_multi_init();
for ($i = 1;$i <= 3; $i++)
 $curl[$i] = addHandle($curlHandle,$list[$i]);


Now we should execute the cURL multi handle retrive the
content from the sub handles that we added to the cURL multi handle.

ExecHandle($curlHandle);
for ($i = 1;$i <= 3; $i++)
{
 $text[$i] =  curl_multi_getcontent ($curl[$i]);
 echo $text[$i];
}

In the end we should release the handles from the cURL multi handle by calling curl_multi_remove_handle and close the cURL multi handle!

If we want to another Fetch of sites with cURL-Multi - since this is the most pretty way to do it!
Well I am not sure bout the string concatenation. How to do it - Note I want to fetch several hundred pages:
see the some details for this target-server sites - /(I have to create a loop over several hundred sites).

    * siteone.example/?show_subsite=9009
    * siteone.example/?show_subsite=9742
    * siteone.example/?show_subsite=9871

.... and so on and so forth Question: How to appy this loop into the array of the curl-multi?



<?php
/************************************\
* Multi interface in PHP with curl  *
* Requires PHP 5.0, Apache 2.0 and  *
* Curl         *
*************************************
* Writen By Cyborg 19671897         *
* Bugfixed by Jeremy Ellman         *
\***********************************/

$urls = array(
   "siteone",
   "sitetwo",
   "sitethree"
   );

$mh = curl_multi_init();

foreach ($urls as $i => $url) {
       $conn[$i]=curl_init($url);
       curl_setopt($conn[$i],CURLOPT_RETURNTRANSFER,1);//return data as string 
       curl_setopt($conn[$i],CURLOPT_FOLLOWLOCATION,1);//follow redirects
       curl_setopt($conn[$i],CURLOPT_MAXREDIRS,2);//maximum redirects
       curl_setopt($conn[$i],CURLOPT_CONNECTTIMEOUT,10);//timeout
       curl_multi_add_handle ($mh,$conn[$i]);
}

do { $n=curl_multi_exec($mh,$active); } while ($active);

foreach ($urls as $i => $url) {
       $res[$i]=curl_multi_getcontent($conn[$i]);
       curl_multi_remove_handle($mh,$conn[$i]);
       curl_close($conn[$i]);
}
curl_multi_close($mh);


print_r($res);

?>





I look forward to your ideas.

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

Hi guys,

I would like to display data from MySQL in the format of 5 lists (of one column each) one next to each other on a webpage

I am quite good with SQL, but I  lack knowledge about php and displaying data.

SQL version: 5.1

Does anyone have any good website that would show how to do such a thing?






 

Hi,
for uni i've got to make a shopping cart application in php/mysql. I'm almost done with it, managed to teach myself some nifty jquery and have been able to learn loads more PHP, I'm really enjoying it. I've come to a bit of a stand still though, I showed my application as it is to my lecturer and he had one little point.
My application, you have lists, each list has its own categories (users can add, edit, delete their own) and in each category, there are items (which like categorys can be added, edited or deleted).

So basically, you have a browse_list.php, which browses all the lists, each list has it's own unique hyperlink to browse_list_category.php?list_id= using the get method, it selects all the categories associated with that list, which, like browse_list.php have their own hyperlinks, but this time they link to browse_category_item.php?category_id= and they list what ever items are associated with that category. Sounds a mouth full, but it's really quite simple.

I showed my lecturer that and he wasn't happy with the whole category/item layout. He said it would be better if the category list had a nested item list underneath it. He was happy with the whole list to category part with the hyperlink, though.
Kinda like:

Quote

-list
-------category
-------item
-list1
------category1
------item1
------category2
------item2
------category3
------item3


My database layout is
tbllist -main list table, list_id, list_name
tblcategory - main category table, category_id, category_name
tblcategory_list - link table for list and category (many-many) list_id, category_id
tblitem - main item table, item_id, item_name
tbl_category_item - link table for category and item (many-many) category_id, item_id

So, now you've kinda got the gist of what I'm doing.. I just need help with displaying each item in a category, under the category.. like a nested list
<ul>
<li>category 1</li>
<ul>
<li> item 1</li>
<li> item 2</li>
<li> item 3</li>
</ul>
</ul>

I did try and have a go earlier, kinda rushed and managed to come up with this:
<ul id="sortme" class="shoppinglist">
<?php
// Split records in $result by table rows and put them in $row.
while($row = mysql_fetch_array($result)) {
echo '<li class="list" id="' . $row['category_id'] . '"><div class="text"><a href="browse_item_category.php?category_id=' .  $row['category_id'] . '">' . $row['category_name'] . "</a></div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"categoryupdater.php?category_id=" . $row['category_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}
?><ul id="sortme" class="shoppinglist">
<?php
while($row = mysql_fetch_array($resultitem)) {
echo '<li class="list" id="' . $row['item_id'] . '"><div class="text">' . $row['item_name'] . "</div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"itemupdater.php?item_id=" . $row['item_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}

?>
</ul>
</ul>

but this i get this

not the whole list nested'ness


it's a bit long winded I know but could anyone possible give me a hand? i've done pretty well so far not asking for help, but I think this is going to be the end of me!