[SOLVED - DB, Arrays and counting.]

Probably not the pretty way of getting it to work .. but it does now :)

$R21a_1=0;
$R21a_2=0;
$R21a_3=0;
$R21a_4=0;
$R21a_5=0;
$R21b_1=0;
$R21b_2=0;
$R21b_3=0;
$R21b_4=0;
$R21b_5=0;
$R21c_1=0;
$R21c_2=0;
$R21c_3=0;
$R21c_4=0;
$R21c_5=0;
$R21d_1=0;
$R21d_2=0;
$R21d_3=0;
$R21d_4=0;
$R21d_5=0;
$piece=3;


$query2="SELECT R21 FROM pn_survey_2";
$result2 = mysql_query($query2);
while ($row=mysql_fetch_array($result2, MYSQL_ASSOC)){

$piece1 = substr($row['R21'],0,$piece);
$piece2 = substr($row['R21'],3,$piece);
$piece3 = substr($row['R21'],6,$piece);
$piece4 = substr($row['R21'],9,$piece);
$piece5 = substr($row['R21'],12,$piece);

if ($piece1=="V01") { $R21a_1++; }
if ($piece1=="V02") { $R21a_2++; }
if ($piece1=="V03") { $R21a_3++; }
if ($piece1=="V04") { $R21a_4++; }
if ($piece1=="V05") { $R21a_5++; }

if ($piece2=="V01") { $R21b_1++; }
if ($piece2=="V02") { $R21b_2++; }
if ($piece2=="V03") { $R21b_3++; }
if ($piece2=="V04") { $R21b_4++; }
if ($piece2=="V05") { $R21b_5++; }

if ($piece3=="V01") { $R21c_1++; }
if ($piece3=="V02") { $R21c_2++; }
if ($piece3=="V03") { $R21c_3++; }
if ($piece3=="V04") { $R21c_4++; }
if ($piece3=="V05") { $R21c_5++; }

if ($piece4=="V01") { $R21d_1++; }
if ($piece4=="V02") { $R21d_2++; }
if ($piece4=="V03") { $R21d_3++; }
if ($piece4=="V04") { $R21d_4++; }
if ($piece4=="V05") { $R21d_5++; }

} # close while R21

[SOLVED - DB, Arrays and counting.]

Thanks Ken,

--

[b]Got another problem [/b] now (keep digging myself holes :))

This one kinda kinda hard to explain, but here i go :)

I have strings coming like before, but this time each V## corresponds to one answer of the 5 part question (rate how you like each of the 5 shows listed), you can see some example of the form code below (the 5 V## are combined b4 being entered into the database).  

  1   2    3   4   5
V01V02V04V05V03
V04V04V04V05V01
V02V05V03V01V04
----
1 x V01
1 x V04
1 x V02

--------------

HOT 20 -

<select name="R14a" id="R14a">
  <option value="V05">5 - Favourite</option>
  <option value="V04">4 - Above Average</option>
  <option value="V03">3 - Average</option>
  <option value="V02">2 - Below Average</option>
  <option value="V01">1 - Least Favourite</option>
</select>

----------

Here is what i have so far, it's not working, but again I think I'm close:

$R14a_1=0;
$R14a_2=0;
$R14a_3=0;
$R14a_4=0;
$R14a_5=0;
$R14b_1=0;
$R14b_2=0;
$R14b_3=0;
$R14b_4=0;
$R14b_5=0;
$R14c_1=0;
$R14c_2=0;
$R14c_3=0;
$R14c_4=0;
$R14c_5=0;
$R14d_1=0;
$R14d_2=0;
$R14d_3=0;
$R14d_4=0;
$R14d_5=0;
$R14e_1=0;
$R14e_2=0;
$R14e_3=0;
$R14e_4=0;
$R14e_5=0;



$query2="SELECT R14 FROM bpm_survey_2";
$result2 = mysql_query($query2);
while ($row=mysql_fetch_array($result2, MYSQL_ASSOC)){

$array = spliti ("V", $row['R14']);
for ($i_R14 = 0; $i_R14 < count($array); ++$i_R14) {

if ($array[1]=="01") { $R14a_1++; }
if ($array[1]=="02") { $R14a_2++; }
if ($array[1]=="03") { $R14a_3++; }
if ($array[1]=="04") { $R14a_4++; }
if ($array[1]=="05") { $R14a_5++; }

if ($array[2]=="01") { $R14b_1++; }
if ($array[2]=="02") { $R14b_2++; }
if ($array[2]=="03") { $R14b_3++; }
if ($array[2]=="04") { $R14b_4++; }
if ($array[2]=="05") { $R14b_5++; }

if ($array[3]=="01") { $R14c_1++; }
if ($array[3]=="02") { $R14c_2++; }
if ($array[3]=="03") { $R14c_3++; }
if ($array[3]=="04") { $R14c_4++; }
if ($array[3]=="05") { $R14c_5++; }

if ($array[4]=="01") { $R14d_1++; }
if ($array[4]=="02") { $R14d_2++; }
if ($array[4]=="03") { $R14d_3++; }
if ($array[4]=="04") { $R14d_4++; }
if ($array[4]=="05") { $R14d_5++; }

if ($array[5]=="01") { $R14e_1++; }
if ($array[5]=="02") { $R14e_2++; }
if ($array[5]=="03") { $R14e_3++; }
if ($array[5]=="04") { $R14e_4++; }
if ($array[5]=="05") { $R14e_5++; }

}

} # close while R14

[SOLVED - DB, Arrays and counting.]

Thanks, i just got it now ...

$R6_1=0;
$R6_2=0;
$R6_3=0;
$R6_4=0;
$R6_5=0;
$R6_6=0;
$R6_7=0;

$query2="SELECT R6 FROM bpm_survey_2";
$result2 = mysql_query($query2);
while ($row=mysql_fetch_array($result2, MYSQL_ASSOC)){

$array = spliti ("V", $row['R6']);
#print_r($array);

for ($i_R6 = 0; $i_R6 < count($array); ++$i_R6) {

if ($array[$i_R6]=="01") { $R6_1++; }
if ($array[$i_R6]=="02") { $R6_2++; }
if ($array[$i_R6]=="03") { $R6_3++; }
if ($array[$i_R6]=="04") { $R6_4++; }
if ($array[$i_R6]=="05") { $R6_5++; }
if ($array[$i_R6]=="06") { $R6_6++; }
if ($array[$i_R6]=="07") { $R6_7++; }

}

} # close while R6

[SOLVED - DB, Arrays and counting.]

see problem 2 below .. thanks :)

[Case of the mondays]

Thanks obsidian and kenrbnsn.

obsidian already have yours in testing .. should be up and working tomorrow ... man you saved me so much time :)

thanks

[Case of the mondays]

Hey all,

Our website has chart (top 20 kinda thing) and its updated every Monday, I don't have any problem with getting the database working and having the chart up to update on the Mondays etc. But the boss wants to see past charts posted, this isn't a big deal, but doing it dynamically could be a problem. Here is what i have going on now:

$sql_week=date ('W');

if ($sql_week == 42) {
$weekof="week of October 16th";
$show_week="42";
}

I have one of these for each week, 42 to 45, but i now need to go back to week 32 and that’s a lot of typing. I was wondering if someone could help me out and make a script based on the week of the year that would bring up the date of each Monday (base on that week of the year) .. like $show_week="42" and $monday_date="16" ... and this would be dynamic based on $sql_week. 

Anyone ? ..

[XML, PHP - getting specific data out]

Hey all,

I did some searching and really didn't find anything that helped. I know somewhat how to get an xml file to show on the page, but not how to get a specific part of the data out.

Here is what i'm looking for:

--

On Now

$show_name_on_now

Coming Up

3:30pm - $show_name_30min
4:00pm - $show_name_1hr
4:30pm - $show_name_130min
5:00pm - $show_name_2hr

--

Here is the format of my XML file. I've got the time and date formated and rounding correctly, no problem there .. but searching through an XML file ... i got nothing  ???

<synweek>
<starttime>06:00:00</starttime>
<title>Good Dog</title>
<subepis>Preventing Problems</subepis>
<air_date>08/28/06</air_date>
<house>G</house>
<synopsis>Great show bah bah..</synopsis>
</synweek>

--

I need to be able to continually pick out the show title based on the current date/time of the day. The sql file holds an entire week of data... anyone have any thoughts ?  I could do this in a second if it was just an SQL database, but with XML I'm totally lost :(