Need help with coding...

[madd_mike]

If anyone could help me out with this code...I'd get you a couple of concert tickets or make a donation to paypal for you. I broke my right shoulder and can now only code with one hand...
I have one table called events with three fields, dateofevent, artist and venue. i want my output to look like the list below:
Date Artist Venue
3-Aug-04 Lawrence Arms Agora Theatre
3-Aug-04 Pipedown Agora Theatre
3-Aug-04 Scattered Fall Agora Theatre
3-Aug-04 Tsunami Bomb Agora Theatre
3-Aug-04 Joe Bonamassa Beachland Ballroom & Tavern
3-Aug-04 DJ Logic Blossom Music Center
3-Aug-04 John Mayer Blossom Music Center
3-Aug-04 Maroon5 Blossom Music Center
4-Aug-04 Pete Rock Grog Shop
4-Aug-04 Truth Hurts Grog Shop
4-Aug-04 Electric Six Rock & Roll Hall Of Fame
5-Aug-04 Projekt Revolution Blossom Music Center
5-Aug-04 Funeral For A Friend Blossom Music Center
5-Aug-04 Korn Blossom Music Center
5-Aug-04 Less Than Jake Blossom Music Center
5-Aug-04 Linkin Park Blossom Music Center
5-Aug-04 Snoop Dogg Blossom Music Center_

I would like the dates to have alternating colors (green for even and white for odd). I can get the output okay but can't get the dates to alternate colors. If someone can show me how to code or would e-mail me, I can provide more details....
[e-mail]

Thank you!

[Pig]

You need to check the date field in order to alternate colors, and that would really depend on how you are storing your dates. IMNSHO, a unix timestamp is the most superior method, so I will go with that.

You also have 2 options. If you go with alternating based on odd/even, you could have to different days with the same color right next 2 each other (eg: the 4th and the 6th).

$sql = "SOME SELECT STATEMENT HERE...";
$result = mysql_query($sql);
if( mysql_num_rows($result) == 0 ) echo("No events found");
else
{
     while( $row = mysql_fetch_array($result) )
     {
          if( is_int( date("d", $row['date'])/2 ) ) $class = "even";
          else $class == "odd";

      echo("<div class='$class'>" . date('d-M-y', $row['date']) . " " . $row['artist'] . " " . $row['venue'] . "</div>");
      ");
 }
}

Your other option is to base it off of a change in days, so that regardless of whether it is odd or even, every new day would have an alternate color.

[madd_mike]

Thanks for trying but all dates are now DEC-31-69...here is the code I used:

$sql = "SELECT artist ,venue ,dateofevent FROM newevents where dateofevent >= curdate()";
$result = mysql_query($sql);

if( mysql_num_rows($result) == 0 ) echo("No events found");
else
{
while( $row = mysql_fetch_array($result) )
{
if( is_int( date("d", $row['date'])/2 ) ) $class = "even";
else $class == "odd";

      echo("<div class='$class'>" . date('M-d-y', $row['date']) . " " . $row['artist'] . " " . $row['venue'] . "</div>"); 

// ");
}

}

mysql_close(); // Close the database

If you want to see the real data as its run then:Events

This is starting to be no fun...

[TheDefender]

The [man]date()[/man] function does not like that type of date input format for the date, so that's why the date is getting screwed up. Now, I am not 100% certain if the [man]strtotime()[/man] function can use that format either, since I can't get to the manual at gnu.org to find out, but try changing your code to something like this, and see if that works any better for you.

$sql = "SELECT artist ,venue ,dateofevent FROM newevents where dateofevent >= curdate()"; 
$result = mysql_query($sql); 

if( mysql_num_rows($result) == 0 ) echo("No events found"); 
else 
{ 
while($row = mysql_fetch_array($result)) 
{ 
if(is_int(date("d", strtotime($row['date']))/2)) $class = "even"; 
else $class == "odd"; 

echo("<div class='$class'>" . date('M-d-y', strtotime($row['date'])) . " " . $row['artist'] . " " . $row['venue'] . "</div>"); 
// "); 
} 

} 


mysql_close(); // Close the database 

Otherwise, you may want to consider storing your date in a different (more conventional) format like YYYY-MM-DD or Unix Timestamp (seconds since the Epoch, January 1, 1970)

[Pig]

Correct, date() expects a unix timestamp. You cannot just send it a date string. How are your dates stored in there now?

In general, it is easiest to store your dates as unix timestamps, so you can easily manipulate them however you like.

[madd_mike]

Well, date should have been dateofevent and now it echos okay. The original problem still haunts me. I wanted every even day table cell light green and every odd one white...still all white..

here are my tables:

Events1

This sites help with color cells by date

Thanks!

[eriksmoen]

color problem:

try something like:

$bg1 = "xxxxx"; // light green
$bg2 = "xxxxx"; // the other color
$bg0 = $bg1;

this will then go in your loop:

$bg0 = ($bg0 == $bg1)? $bg2 : $bg1;

hope that helps.

[bigswifty]

now why can't the others be like you?

simple elegant solution to the result colors question.

whats with these guys pushing that whole 40 lines of code to do simple color alternation? when 4 lines will do the trick.

bad enough that ALL the alternating color requests result in that monster chunk of code being pasted into a reply.

why does everyone here think more complex is better?

why is:
color="#000000"> color="#0000BB"><?

$query color="#007700">= color="#0000BB">mysql_querycolor="#007700">(color="#DD0000">"SELECT * FROM your_table"color="#007700">);
color="#0000BB">$num_rows color="#007700">= color="#0000BB">mysql_num_rowscolor="#007700">(color="#0000BB">$querycolor="#007700">);

color="#FF8000">// row colors
color="#0000BB">$row_colorcolor="#007700">=color="#DD0000">"#F7F7FF"color="#007700">;

color="#0000BB">$count_rows color="#007700">= color="#DD0000">"0"color="#007700">;

while (color="#0000BB">$row color="#007700">= color="#0000BB">mysql_fetch_arraycolor="#007700">(color="#0000BB">$querycolor="#007700">)) {

       color="#0000BB">$count_rowscolor="#007700">++;  
             if (color="#0000BB">$count_rowscolor="#007700">%color="#0000BB">2color="#007700">==color="#0000BB">0color="#007700">)  
                 { color="#0000BB">$row_colorcolor="#007700">=color="#DD0000">"#F7F7FF"color="#007700">; } color="#FF8000">// Even-numbered rows 
             color="#007700">else  
                 { color="#0000BB">$row_colorcolor="#007700">=color="#DD0000">"#A7BBE3"color="#007700">; } color="#FF8000">// Odd-numbered rows 



      color="#007700">print color="#DD0000">"<tr bgcolor=" color="#007700">. color="#0000BB">$row_color color="#007700">. color="#DD0000">"><td width=300>" color="#007700">. color="#0000BB">$rowcolor="#007700">[color="#DD0000">"bla"color="#007700">] . color="#DD0000">"</td>\n"color="#007700">; 
      print color="#DD0000">"</tr>\n"color="#007700">; 

color="#FF8000">// end while loop
color="#007700">}

color="#0000BB">?>

better then:

$bg1 = "";
$bg2 = "";
$bg0 = $bg1;

$bg0 = ($bg0 == $bg1)? $bg2 : $bg1;

what am i missing here?