jcbones
Staff Alumni-
Posts
2,653 -
Joined
-
Last visited
-
Days Won
8
Everything posted by jcbones
-
Distinct doesn't like to be coupled with Order by. So, you have to join the table to itself. Try: SELECT DISTINCT sponser FROM (table INNER JOIN table as t ON table.sponser = t.sponser) ORDER BY sponser ASC; Ideally you would join on the PRIMARY KEY, but I dont' know if you have one so I didn't go there.
-
Little Push In The Right Direction With My Simple PHP Script
jcbones replied to notacoder's topic in PHP Coding Help
I would run the sql as: $sql1 = mysql_query("SELECT USER_NAME FROM members WHERE SIGNUP_DATE = CURDATE()); You will also get an error on the last line: echo "$memberseligible"; As that variable is an array. You will need to implode() the data, or run it through a foreach() construct. My question is. How is this any better than just setting the default value of user_balance to 25.00 in the database? Then once a user signs up, they will start off with a balance of 25.00. Edit: I think that query may need to be: $sql1 = mysql_query("SELECT USER_NAME FROM members WHERE DATE(SIGNUP_DATE) = CURDATE()); -
I think he either has a space in his font file name, or his font file doesn't exist. I tried duplicating his error, and that was the only two ways I could get it to return that error.
-
image.php <?php // Set the content-type header('Content-type: image/png'); $text = (isset($_GET['text'])) ? $_GET['text'] : exit(); $font = 'A.C.M.E._Explosive_Bold.ttf'; //location of your true type font. // Create the image $im = imagecreatetruecolor(400, 30); // Create some colors $white = imagecolorallocate($im, 255, 255, 255); $grey = imagecolorallocate($im, 128, 128, 128); $black = imagecolorallocate($im, 0, 0, 0); imagefilledrectangle($im, 0, 0, 399, 29, $white); // Add some shadow to the text imagettftext($im, 20, 0, 11, 21, $grey, $font, $text); // Add the text imagettftext($im, 20, 0, 10, 20, $black, $font, $text); // Using imagepng() results in clearer text compared with imagejpeg() imagepng($im); imagedestroy($im); ?> test.html <img src="image.php?text=This_is_a_test" alt="test" /> Tell us how it goes. Make sure your font file exists, and has no spaces in it.
-
I suppose you are holding the cart and all of the available item info on your site, and only passing the total value to paypal. If so, you can send an 'item_number' over to paypal, which could be your transaction ID. This value will be passed back to you on transaction completion. Paypal variables
-
For glitches we need to see the full script. Partial code does not tell us how the variables are formed, nor if they are defined at all.
-
Using a link like: <a href="modify_form.php"> <input name="button2" type="submit" id="button2" value="Modify Account" /> </a> inside of a form, will not submit the data to that page. It will only link to that page. Forms will only submit the data to that page in the action attribute.
-
select counting of two tables to paginate their query results
jcbones replied to turpentyne's topic in PHP Coding Help
http://www.phpfreaks.com/tutorial/basic-pagination -
http://www.thesitewizard.com/php/create-image.shtml Let us know if you get stuck.
-
Here you go. I added some code to it, both to correct it, and for functionality. All new code has comments, and is marked by //****** <?php date_default_timezone_set('Europe/Helsinki'); // Get... $month = $_POST['ViewMonth']; if($month == ""){ $month = "01"; } $year= $_POST['ViewYear']; if($year == ""){ $year = "2010"; } // Controls ?> <form action="start.monday.php" method="POST"> <select name="ViewMonth"> <?php for($i = 1; $i < 13; $i++) { //******added for loop, so you could keep the last selected month. echo '<option '; echo ($i == (int)$month) ? 'selected="selected"' : NULL; echo '>' . $i . '</option>'; } ?> </select> <select name="ViewYear"> <?php for($i = 2006; $i < 2015; $i++) { //******added teh for loop, so you could keep the last selected year. echo '<option '; echo ($i == (int)$year) ? 'selected="selected"' : NULL; echo '>' . $i . '</option>'; } ?> </select> <input type="submit" value="Go"> </form> <?php //This gets today's date $date =time () ; //This puts the day, month, and year in seperate variables $day = date('d', $date) ; //$month = date('m', $date) ; //$year = date('Y', $date) ; //Here we generate the first day of the month $first_day = mktime(0,0,0,$month, 1, $year) ; //This gets us the month name $title = date('F', $first_day) ; //*****This line had been deleted, making the switch Useless. //Here we find out what day of the week the first day of the month falls on $day_of_week = date('D', $first_day) ; $day_of_week = date('D',$first_day); //Once we know what day of the week it falls on, we know how many blank days occure before it. If the first day of the week is a Sunday then it would be zero switch($day_of_week){ //******days re-ordered. case "Sun": $blank =6; break; case "Mon": $blank = 0; break; case "Tue": $blank = 1; break; case "Wed": $blank = 2; break; case "Thu": $blank = 3; break; case "Fri": $blank = 4; break; case "Sat": $blank = 5; break; } //We then determine how many days are in the current month $days_in_month = cal_days_in_month(0, $month, $year) ; //Here we start building the table heads echo "<table border=1 width=294>"; echo "<tr><th colspan=7> $title $year </th></tr>"; //*******Changed echo string to reflect that 1st day is Monday. echo "<tr><td width=42>M</td><td width=42>T</td><td width=42>W</td><td width=42>T</td><td width=42>F</td><td width=42>S</td><td width=42>S</td></tr>"; //This counts the days in the week, up to 7 $day_count = 1; echo "<tr>"; //first we take care of those blank days while ( $blank > 0 ) { echo "<td></td>"; $blank = $blank-1; $day_count++; } //sets the first day of the month to 1 $day_num = 1; //count up the days, untill we've done all of them in the month while ( $day_num <= $days_in_month ) { echo "<td> $day_num </td>"; $day_num++; $day_count++; //Make sure we start a new row every week if ($day_count > 7) { echo "</tr><tr>"; $day_count = 1; } } //Finaly we finish out the table with some blank details if needed while ( $day_count >1 && $day_count <=7 ) { echo "<td> </td>"; $day_count++; } echo "</tr></table>"; ?> Problems. As suggested re-ordered switch. $day_of_week variable was missing, put it in. re-ordered column names to report Monday as first day of the week. Functionality. Replaced static dropdowns with for loops, so you could keep the last selected month and year.
-
Can't display text from MySQL on page
jcbones replied to brendansingleton's topic in PHP Coding Help
Ensure that the files php_mysql.dll and libmysql.dll can be reached by php by modifying and uncommenting the line: extension_dir = "C:\php\ext\" After that, I'm out of ideas. -
Foreign ID doesn't increment with the other tables.
jcbones replied to Namtip's topic in PHP Coding Help
Try: $query = sprintf("INSERT INTO site_user_info ( name_id, terms_and_conditions, name_on_card, credit_card_number ) VALUES (LAST_INSERT_ID(),'%s','%s','%s')", mysql_real_escape_string($_SESSION['terms_and_conditions']), mysql_real_escape_string($_POST['name_on_card']), mysql_real_escape_string($_POST['credit_card_number'])); Do the same for "card_numbers". This should fix the last inserted ID from the insert into "subscriptions" into the next two tables. -
Display array in order and then reorder array by 1?
jcbones replied to TheBrandon's topic in PHP Coding Help
It is boolean logic for an if/else statement. $var = (condition) ? true : false; -
You didn't write the referrer to the file, you only stored it in a variable. <?php $filename = "hits.txt"; $file = file($filename); $file = array_unique($file); $hits = count($file); echo $hits; echo "$refer"; $fd = fopen ($filename , "r"); $fstring = fread ($fd , filesize ($filename)); fclose($fd); $fd = fopen ($filename , "w"); $fcounted = $fstring."n IP ".getenv("REMOTE_ADDR"); $refer = ' Referrer ' . $_SERVER["HTTP_REFERER"] . "\n"; $fout= fwrite ($fd , $fcounted . $refer); fclose($fd); ?>
-
Display array in order and then reorder array by 1?
jcbones replied to TheBrandon's topic in PHP Coding Help
An interesting problem. I like helping people with interesting problems. So I wrote a little bit of code for you. You will need to make it interact with your javascript, but you can see how it works. <?php session_start(); //Start a session. $images = array('1.jpg','2.jpg','3.jpg','4.jpg','5.jpg'); //An array that holds all of your images. $start = (isset($_SESSION['rotate'])) ? (int)$_SESSION['rotate'] : 0; //if the session is set, then return the session, otherwise return 0. $banner_array = array(); //start a banner array. $image_count = count($images); //count how many images are in the image array. $start = ($start > $image_count) ? 0 : $start; //if our start count is higher than the number of images, reset it back to 0. for($i = $start; $i < $image_count; $i++) { $banner_array[] = $images[$i]; //starting at our count, put the images in the banner array. } if($start > 0) { for($i = 0; $i < $start; $i++) { $banner_array[] = $images[$i]; //if our start count was higher than the first image, then get the remaining images onto the end of the banner array. } } $_SESSION['rotate'] = ($start + 1); //save the new start point to the session. echo '<pre>'; print_r($banner_array); echo '</pre>'; //print the array to the page, and lets see it work. ?> -
SQL errors as I attempt split data from a session into two tables
jcbones replied to Namtip's topic in PHP Coding Help
One error here. "INSERT INTO subscriptions ( name, email_address, membership_type,) //<<remove that nasty , right before the last ) VALUES ('%s','%s','%s')" -
Getting a loop to simply write "static" code ??
jcbones replied to ThunderVike's topic in PHP Coding Help
You are looping through known keys with the foreach(), and when you find a key that starts with the desired criteria, you then check to see if it is NOT set. But, it will be set, because you are looping through those keys. Perhaps you want to check if it is an array. function checkboxloop() { //function start. foreach($_POST as $meta_key => $meta_value) { //loop the $_POST key/values. if(cp_str_starts_with($meta_key, 'cp_checkbox')) { //if the POST key starts with cp_checkbox. if (! isset($_POST[$meta_key])) $_POST[$meta_key] = array(); //if POST[key] is not set <<This condition will always revert to false, because you are checking to see if a set condition is NOT set. } } } function checkboxloop() { //function start. foreach($_POST as $meta_key => $meta_value) { //loop the $_POST key/values. if(cp_str_starts_with($meta_key, 'cp_checkbox')) { //if the POST key starts with cp_checkbox. if (!is_array($_POST[$meta_key])) $_POST[$meta_key] = array(); //if POST[key] is not an array. } } } -
page1.php <?php session_start(); $errors = array(); // set the errors array to empty, by default $fields = array('first_name' => NULL, 'email'=>NULL, 'phone'=>NULL); // stores the field values $success_message = ""; if (isset($_POST['submit'])) { // import the validation library require("validation.php"); $rules = array(); // stores the validation rules // standard form fields $rules[] = "required,first_name,Enter your name."; $rules[] = "required,email,Enter your email address."; $rules[] = "valid_email,email,Please enter a valid email address."; // Length of field input $rules[] = "length=10,phone,Please enter a ten digit Phone number."; $errors = validateFields($_POST, $rules); // if there were errors, re-populate the form fields if (!empty($errors)) { foreach($_POST as $k => $v) { $fields[$k] = $v; } } // no errors! redirect the user to the thankyou page (or whatever) else { $message = "All fields have been validated successfully!"; // here you would either email the form contents to someone or store it in a database. // To redirect to a "thankyou" page, you'd just do this: $to = "info@site.com"; $subject = "Site Info"; $field_first = strip_tags($_POST['first_name']); $field_email = strip_tags($_POST['email']); $field_phone = strip_tags($_POST['phone']); $body = "Name: $field_first\n Email: $field_email\n Phone: $field_phone\n "; // Send the mail using PHPs mail() function mail($to, $subject, $body); $_SESSION['first_name'] = $field_first; $_SESSION['email'] = $field_email; $_SESSION['phone'] = $field_phone; header('Status: 200'); header("Location:customize_search.php"); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Page title</title> <meta name="keywords" content="..." /> <meta name="description" content="..." /> <link href="css/style_reset.css" rel="stylesheet" type="text/css" media="screen" /> <link href="css/style.css" rel="stylesheet" type="text/css" media="screen" /> <link href="css/form_style.css" rel="stylesheet" type="text/css" media="screen" /> <link rel="shortcut icon" href="favicon.ico" type="image/vnd.microsoft.icon" /> </head> <body> <div id="outer"> <div class="conleft"> <div class="conttopad"></div> <div class="continner"> </div><!-- End Content Inner --> </div><!-- End Content Left --> <div class="conright"> <div class="conttopad"></div> <div class="continner"> <p style=" font-size:13px; text-align:center; line-height:16px">Enter your contact information in the form below…</p> <form action="" method="post"> <fieldset> <?php // if $errors is not empty, the form must have failed one or more validation // tests. Loop through each and display them on the page for the user if (!empty($errors)) { echo "<div class='error' style='width:90%;'>Please fix the following errors:\n<ul>"; foreach ($errors as $error) echo "<li>$error</li>\n"; echo "</ul></div>"; } if (!empty($message)) { echo "<div class='notify'>$success_message</div>"; } ?> <label for="first_name">Name * <input type="text" name="first_name" id="first_name" value="<?php echo $fields['first_name']?>" /> </label> <label for="email">Email * <input type="text" name="email" id="email" value="<?php echo $fields['email']?>" /> </label> <label for="phone"><input type="text" name="phone" id="phone" value="<?php echo $fields['phone']?>" /><span style="float:left">Phone *</span><br /> <span style="font-size:9px; float:left; width:100px;">(Ten digits, no dashes)</span> </label> </fieldset> <fieldset style=" clear:both"> <input class="button" type="image" name="submit" id="submit" value="submit" src="images/send.gif" width="192" height="69" /> <input type="hidden" name="submit" value="submit" /> </fieldset> </form> <div style="clear:both"></div> <p style=" font-size:11px; text-align:center; line-height:16px; color:#737373; clear:left; margin-top:12px"><strong>**Please double-check</strong> that your email address is correct or you won't be able to get all the free training material. I take your privacy very seriously - your information is NEVER shared.</p> </div><!-- End Content inner --> </div><!-- End Content Right --> </div><!-- End Outer --> <div style="clear:both;"></div> <div id="footer"> <div id="footerinner" style="width:880px"> <div class="conleft" style="width:530px"> </div> <div class="conright" style="width:350px"></div> <div style="clear:both;"></div> </div><!-- End Footer Inner --> </div><!-- End Footer --> </body> </html> customize_search.php <?php session_start(); $errors = array(); // set the errors array to empty, by default $fields = array('first_name' => NULL, 'email'=>NULL, 'last_name'=>NULL, 'phone'=>NULL); // stores the field values $success_message = ""; if(isset($_SESSION['first_name']) && isset($_SESSION['email']) && isset($_SESSION['phone'])) { $fields['first_name'] = $_SESSION['first_name']; $fields['email'] = $_SESSION['email']; $fields['phone'] = $_SESSION['phone']; } if (isset($_POST['submit'])) { // import the validation library require("validation.php"); $rules = array(); // stores the validation rules // standard form fields $rules[] = "required,first_name,Enter your first name."; $rules[] = "required,last_name,Enter your last name."; $rules[] = "required,email,Enter your email address."; $rules[] = "valid_email,email,Please enter a valid email address."; // Length of field input $rules[] = "length=10,phone,Please enter a ten digit phone number - No dashes."; $errors = validateFields($_POST, $rules); // if there were errors, re-populate the form fields if (!empty($errors)) { foreach($_POST as $k => $v) { $fields[$k] = $v; } } // no errors! redirect the user to the thankyou page (or whatever) else { $message = "All fields have been validated successfully!"; // here you would either email the form contents to someone or store it in a database. // To redirect to a "thankyou" page, you'd just do this: $to = "info@site.com"; $subject = "Customized List"; $field_first = strip_tags($_POST['first_name']); $field_last = strip_tags($_POST['last_name']); $field_email = strip_tags($_POST['email']); $field_phone = strip_tags($_POST['phone']); $body = "First Name: $field_first\n Last Name: $field_last\n Email: $field_email\n Phone: $field_phone\n "; // Send the mail using PHPs mail() function mail($to, $subject, $body); header('Status: 200'); header("Location: thank_you.htm"); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Page Title</title> <meta name="keywords"..." /> <meta name="description" content="..." /> <link href="css/style_reset.css" rel="stylesheet" type="text/css" media="screen" /> <link href="css/style.css" rel="stylesheet" type="text/css" media="screen" /> <link href="css/form_style_p2.css" rel="stylesheet" type="text/css" media="screen" /> <!--[if lt IE 8]> <link rel="stylesheet" type="text/css" href="css/style_ie7.css" /> <![endif]--> <!--[if lte IE 7]> <link rel="stylesheet" type="text/css" href="css/style_ie7.css" /> <![endif]--> <link rel="shortcut icon" href="favicon.ico" type="image/vnd.microsoft.icon" /> </head> <body> <div id="outer"> <div class="consingle"> <div class="conttopad" style="background:url(images/topad.gif) no-repeat top center"></div> <div class="continner"> <div> <form id="fm-form" method="post" action="" > <h4 id="fm-intro" style="background: #666; color: #FFF">Text</h4> <fieldset> <?php // if $errors is not empty, the form must have failed one or more validation // tests. Loop through each and display them on the page for the user if (!empty($errors)) { echo "<div class='error' style='width:90%;'>Please fix the following:\n<ul>"; foreach ($errors as $error) echo "<li>$error</li>\n"; echo "</ul></div>"; } if (!empty($message)) { echo "<div class='notify'>$success_message</div>"; } ?> <label class="fm-req" for="firstname">First name*</label> <input class="fm-req" name="first_name" id="first_name" type="text" value="<?php echo $fields['first_name']?>" > <label class="fm-req" for="lastname">Last name*</label> <input class="fm-req" name="last_name" id="last_name" type="text" value="<?php echo $fields['last_name']?>" > <label class="fm-req" for="email">Email*</label> <input class="fm-req" id="email" name="email" type="text" value="<?php echo $fields['email']?>" > <label class="fm-req" for="phone">Telephone* <span style="font-weight:normal">(10 digits - no dashes)</span></label> <input class="fm-req" id="phone" name="phone" title="10-Digit Phone Number, No Dashes" type="text" value="<?php echo $fields['phone']?>"> </fieldset> <div id="sub"> <input class="fm-req" id="fm-submit" name="submit" value="Send My Info" type="submit"> <input type="hidden" name="submitted" value="TRUE" > </div> </form> </div> <div style="clear:both"></div> <div class="conlist"> </div> </div><!-- End Content Inner --> </div><!-- End Content Single --> </div><!-- End Outer --> <div style="clear:both;"></div> <div id="footer"> <div id="footerinner"> <div class="consingle"> </div> <div style="clear:both;"></div> </div><!-- End Footer Inner --> </div><!-- End Footer --> </body> </html>
-
Your header() function should look like: header('Content-Type: image/jpeg');
-
"Show unread posts since last visit" Forum feature
jcbones replied to adamlacombe's topic in PHP Coding Help
You should be logging the last time the member requested a page, then just check for (member_last_page_request < time_of_post). -
That actually worked for me. Here is the test script I used. <?php $times = "Sunday 12:01 AM Sunday 12:08 AM Sunday 12:15 AM Sunday 12:22 AM Sunday 12:29 AM Sunday 12:36 AM Sunday 12:43 AM Sunday 12:50 AM Sunday 12:57 AM Sunday 1:04 AM Sunday 1:11 AM Sunday 1:18 AM Sunday 1:25 AM Sunday 1:32 AM Sunday 1:39 AM Sunday 1:46 AM Sunday 1:53 AM Sunday 2:00 AM Sunday 2:07 AM Sunday 2:14 AM Sunday 2:21 AM Sunday 2:28 AM Sunday 2:35 AM Sunday 2:42 AM Sunday 2:49 AM Sunday 2:56 AM Sunday 3:03 AM Sunday 3:10 AM Sunday 3:17 AM Sunday 3:24 AM Sunday 3:31 AM Sunday 3:38 AM Sunday 3:45 AM Sunday 3:52 AM Sunday 3:59 AM Sunday 4:06 AM Sunday 4:13 AM Sunday 4:20 AM Sunday 4:27 AM Sunday 4:34 AM Sunday 4:41 AM Sunday 4:48 AM Sunday 4:55 AM Sunday 5:02 AM Sunday 5:09 AM Sunday 5:16 AM Sunday 5:23 AM Sunday 5:30 AM Sunday 5:37 AM Sunday 5:44 AM Sunday 5:51 AM Sunday 5:58 AM Sunday 6:05 AM Sunday 6:12 AM Sunday 6:19 AM Sunday 6:26 AM Sunday 6:33 AM Sunday 6:40 AM Sunday 6:47 AM Sunday 6:54 AM Sunday 7:01 AM Sunday 7:08 AM Sunday 7:15 AM Sunday 7:22 AM Sunday 7:29 AM Sunday 7:36 AM Sunday 7:43 AM Sunday 7:50 AM Sunday 7:57 AM Sunday 8:04 AM Sunday 8:11 AM Sunday 8:18 AM Sunday 8:25 AM Sunday 8:32 AM Sunday 8:39 AM Sunday 8:46 AM Sunday 8:53 AM Sunday 9:00 AM Sunday 9:07 AM Sunday 9:14 AM Sunday 9:21 AM Sunday 9:28 AM Sunday 9:35 AM Sunday 9:42 AM Sunday 9:49 AM Sunday 9:56 AM Sunday 10:03 AM Sunday 10:10 AM Sunday 10:17 AM Sunday 10:24 AM Sunday 10:31 AM Sunday 10:38 AM Sunday 10:45 AM Sunday 10:52 AM Sunday 10:59 AM Sunday 11:06 AM Sunday 11:13 AM Sunday 11:20 AM Sunday 11:27 AM Sunday 11:34 AM Sunday 11:41 AM Sunday 11:48 AM Sunday 11:55 AM Sunday 12:02 PM Sunday 12:09 PM Sunday 12:16 PM Sunday 12:23 PM Sunday 12:30 PM Sunday 12:37 PM Sunday 12:44 PM Sunday 12:51 PM Sunday 12:58 PM Sunday 1:05 PM Sunday 1:12 PM Sunday 1:19 PM Sunday 1:26 PM Sunday 1:33 PM Sunday 1:40 PM Sunday 1:47 PM Sunday 1:54 PM Sunday 2:01 PM Sunday 2:08 PM Sunday 2:15 PM Sunday 2:22 PM Sunday 2:29 PM Sunday 2:36 PM Sunday 2:43 PM Sunday 2:50 PM Sunday 2:57 PM Sunday 3:04 PM Sunday 3:11 PM Sunday 3:18 PM Sunday 3:25 PM Sunday 3:32 PM Sunday 3:39 PM Sunday 3:46 PM Sunday 3:53 PM Sunday 4:00 PM Sunday 4:07 PM Sunday 4:14 PM Sunday 4:21 PM Sunday 4:28 PM Sunday 4:35 PM Sunday 4:42 PM Sunday 4:49 PM Sunday 4:56 PM Sunday 5:03 PM Sunday 5:10 PM Sunday 5:17 PM Sunday 5:24 PM Sunday 5:31 PM Sunday 5:38 PM Sunday 5:45 PM Sunday 5:52 PM Sunday 5:59 PM Sunday 6:06 PM Sunday 6:13 PM Sunday 6:20 PM Sunday 6:27 PM Sunday 6:34 PM Sunday 6:41 PM Sunday 6:48 PM Sunday 6:55 PM Sunday 7:02 PM Sunday 7:09 PM Sunday 7:16 PM Sunday 7:23 PM Sunday 7:30 PM Sunday 7:37 PM Sunday 7:44 PM Sunday 7:51 PM Sunday 7:58 PM Sunday 8:05 PM Sunday 8:12 PM Sunday 8:19 PM Sunday 8:26 PM Sunday 8:33 PM Sunday 8:40 PM Sunday 8:47 PM Sunday 8:54 PM Sunday 9:01 PM Sunday 9:08 PM Sunday 9:15 PM Sunday 9:22 PM Sunday 9:29 PM Sunday 9:36 PM Sunday 9:43 PM Sunday 9:50 PM Sunday 9:57 PM Sunday 10:04 PM Sunday 10:11 PM Sunday 10:18 PM Sunday 10:25 PM Sunday 10:32 PM Sunday 10:39 PM Sunday 10:46 PM Sunday 10:53 PM Sunday 11:00 PM Sunday 11:07 PM Sunday 11:14 PM Sunday 11:21 PM Sunday 11:28 PM Sunday 11:35 PM Sunday 11:42 PM Sunday 11:49 PM Sunday 11:56 PM Monday 12:03 AM Monday 12:10 AM Monday 12:17 AM Monday 12:24 AM Monday 12:31 AM Monday 12:38 AM Monday 12:45 AM Monday 12:52 AM Monday 12:59 AM Monday 1:06 AM Monday 1:13 AM Monday 1:20 AM Monday 1:27 AM Monday 1:34 AM Monday 1:41 AM Monday 1:48 AM Monday 1:55 AM Monday 2:02 AM Monday 2:09 AM Monday 2:16 AM Monday 2:23 AM Monday 2:30 AM Monday 2:37 AM Monday 2:44 AM Monday 2:51 AM Monday 2:58 AM Monday 3:05 AM Monday 3:12 AM Monday 3:19 AM Monday 3:26 AM Monday 3:33 AM Monday 3:40 AM Monday 3:47 AM Monday 3:54 AM Monday 4:01 AM Monday 4:08 AM Monday 4:15 AM Monday 4:22 AM Monday 4:29 AM Monday 4:36 AM Monday 4:43 AM Monday 4:50 AM Monday 4:57 AM Monday 5:04 AM Monday 5:11 AM Monday 5:18 AM Monday 5:25 AM Monday 5:32 AM Monday 5:39 AM Monday 5:46 AM Monday 5:53 AM Monday 6:00 AM Monday 6:07 AM Monday 6:14 AM Monday 6:21 AM Monday 6:28 AM Monday 6:35 AM Monday 6:42 AM Monday 6:49 AM Monday 6:56 AM Monday 7:03 AM Monday 7:10 AM Monday 7:17 AM Monday 7:24 AM Monday 7:31 AM Monday 7:38 AM Monday 7:45 AM Monday 7:52 AM Monday 7:59 AM Monday 8:06 AM Monday 8:13 AM Monday 8:20 AM Monday 8:27 AM Monday 8:34 AM Monday 8:41 AM Monday 8:48 AM Monday 8:55 AM Monday 9:02 AM Monday 9:09 AM Monday 9:16 AM Monday 9:23 AM Monday 9:30 AM Monday 9:37 AM Monday 9:44 AM Monday 9:51 AM Monday 9:58 AM Monday 10:05 AM Monday 10:12 AM Monday 10:19 AM Monday 10:26 AM Monday 10:33 AM Monday 10:40 AM Monday 10:47 AM Monday 10:54 AM Monday 11:01 AM Monday 11:08 AM Monday 11:15 AM Monday 11:22 AM Monday 11:29 AM Monday 11:36 AM Monday 11:43 AM Monday 11:50 AM Monday 11:57 AM Monday 12:04 PM Monday 12:11 PM Monday 12:18 PM Monday 12:25 PM Monday 12:32 PM Monday 12:39 PM Monday 12:46 PM Monday 12:53 PM Monday 1:00 PM Monday 1:07 PM Monday 1:14 PM Monday 1:21 PM Monday 1:28 PM Monday 1:35 PM Monday 1:42 PM Monday 1:49 PM Monday 1:56 PM Monday 2:03 PM Monday 2:10 PM Monday 2:17 PM Monday 2:24 PM Monday 2:31 PM Monday 2:38 PM Monday 2:45 PM Monday 2:52 PM Monday 2:59 PM Monday 3:06 PM Monday 3:13 PM Monday 3:20 PM Monday 3:27 PM Monday 3:34 PM Monday 3:41 PM Monday 3:48 PM Monday 3:55 PM Monday 4:02 PM Monday 4:09 PM Monday 4:16 PM Monday 4:23 PM Monday 4:30 PM Monday 4:37 PM Monday 4:44 PM Monday 4:51 PM Monday 4:58 PM Monday 5:05 PM Monday 5:12 PM Monday 5:19 PM Monday 5:26 PM Monday 5:33 PM Monday 5:40 PM Monday 5:47 PM Monday 5:54 PM Monday 6:01 PM Monday 6:08 PM Monday 6:15 PM Monday 6:22 PM Monday 6:29 PM Monday 6:36 PM Monday 6:43 PM Monday 6:50 PM Monday 6:57 PM Monday 7:04 PM Monday 7:11 PM Monday 7:18 PM Monday 7:25 PM Monday 7:32 PM Monday 7:39 PM Monday 7:46 PM Monday 7:53 PM Monday 8:00 PM Monday 8:07 PM Monday 8:14 PM Monday 8:21 PM Monday 8:28 PM Monday 8:35 PM Monday 8:42 PM Monday 8:49 PM Monday 8:56 PM Monday 9:03 PM Monday 9:10 PM Monday 9:17 PM Monday 9:24 PM Monday 9:31 PM Monday 9:38 PM Monday 9:45 PM Monday 9:52 PM Monday 9:59 PM Monday 10:06 PM Monday 10:13 PM Monday 10:20 PM Monday 10:27 PM Monday 10:34 PM Monday 10:41 PM Monday 10:48 PM Monday 10:55 PM Monday 11:02 PM Monday 11:09 PM Monday 11:16 PM Monday 11:23 PM Monday 11:30 PM Monday 11:37 PM Monday 11:44 PM Monday 11:51 PM Monday 11:58 PM Tuesday 12:05 AM Tuesday 12:12 AM Tuesday 12:19 AM Tuesday 12:26 AM Tuesday 12:33 AM Tuesday 12:40 AM Tuesday 12:47 AM Tuesday 12:54 AM Tuesday 1:01 AM Tuesday 1:08 AM Tuesday 1:15 AM Tuesday 1:22 AM Tuesday 1:29 AM Tuesday 1:36 AM Tuesday 1:43 AM Tuesday 1:50 AM Tuesday 1:57 AM Tuesday 2:04 AM Tuesday 2:11 AM Tuesday 2:18 AM Tuesday 2:25 AM Tuesday 2:32 AM Tuesday 2:39 AM Tuesday 2:46 AM Tuesday 2:53 AM Tuesday 3:00 AM Tuesday 3:07 AM Tuesday 3:14 AM Tuesday 3:21 AM Tuesday 3:28 AM Tuesday 3:35 AM Tuesday 3:42 AM Tuesday 3:49 AM Tuesday 3:56 AM Tuesday 4:03 AM Tuesday 4:10 AM Tuesday 4:17 AM Tuesday 4:24 AM Tuesday 4:31 AM Tuesday 4:38 AM Tuesday 4:45 AM Tuesday 4:52 AM Tuesday 4:59 AM Tuesday 5:06 AM Tuesday 5:13 AM Tuesday 5:20 AM Tuesday 5:27 AM Tuesday 5:34 AM Tuesday 5:41 AM Tuesday 5:48 AM Tuesday 5:55 AM Tuesday 6:02 AM Tuesday 6:09 AM Tuesday 6:16 AM Tuesday 6:23 AM Tuesday 6:30 AM Tuesday 6:37 AM Tuesday 6:44 AM Tuesday 6:51 AM Tuesday 6:58 AM Tuesday 7:05 AM Tuesday 7:12 AM Tuesday 7:19 AM Tuesday 7:26 AM Tuesday 7:33 AM Tuesday 7:40 AM Tuesday 7:47 AM Tuesday 7:54 AM Tuesday 8:01 AM Tuesday 8:08 AM Tuesday 8:15 AM Tuesday 8:22 AM Tuesday 8:29 AM Tuesday 8:36 AM Tuesday 8:43 AM Tuesday 8:50 AM Tuesday 8:57 AM Tuesday 9:04 AM Tuesday 9:11 AM Tuesday 9:18 AM Tuesday 9:25 AM Tuesday 9:32 AM Tuesday 9:39 AM Tuesday 9:46 AM Tuesday 9:53 AM Tuesday 10:00 AM Tuesday 10:07 AM Tuesday 10:14 AM Tuesday 10:21 AM Tuesday 10:28 AM Tuesday 10:35 AM Tuesday 10:42 AM Tuesday 10:49 AM Tuesday 10:56 AM Tuesday 11:03 AM Tuesday 11:10 AM Tuesday 11:17 AM Tuesday 11:24 AM Tuesday 11:31 AM Tuesday 11:38 AM Tuesday 11:45 AM Tuesday 11:52 AM Tuesday 11:59 AM Tuesday 12:06 PM Tuesday 12:13 PM Tuesday 12:20 PM Tuesday 12:27 PM Tuesday 12:34 PM Tuesday 12:41 PM Tuesday 12:48 PM Tuesday 12:55 PM Tuesday 1:02 PM Tuesday 1:09 PM Tuesday 1:16 PM Tuesday 1:23 PM Tuesday 1:30 PM Tuesday 1:37 PM Tuesday 1:44 PM Tuesday 1:51 PM Tuesday 1:58 PM Tuesday 2:05 PM Tuesday 2:12 PM Tuesday 2:19 PM Tuesday 2:26 PM Tuesday 2:33 PM Tuesday 2:40 PM Tuesday 2:47 PM Tuesday 2:54 PM Tuesday 3:01 PM Tuesday 3:08 PM Tuesday 3:15 PM Tuesday 3:22 PM Tuesday 3:29 PM Tuesday 3:36 PM Tuesday 3:43 PM Tuesday 3:50 PM Tuesday 3:57 PM Tuesday 4:04 PM Tuesday 4:11 PM Tuesday 4:18 PM Tuesday 4:25 PM Tuesday 4:32 PM Tuesday 4:39 PM Tuesday 4:46 PM Tuesday 4:53 PM Tuesday 5:00 PM Tuesday 5:07 PM Tuesday 5:14 PM Tuesday 5:21 PM Tuesday 5:28 PM Tuesday 5:35 PM Tuesday 5:42 PM Tuesday 5:49 PM Tuesday 5:56 PM Tuesday 6:03 PM Tuesday 6:10 PM Tuesday 6:17 PM Tuesday 6:24 PM Tuesday 6:31 PM Tuesday 6:38 PM Tuesday 6:45 PM Tuesday 6:52 PM Tuesday 6:59 PM Tuesday 7:06 PM Tuesday 7:13 PM Tuesday 7:20 PM Tuesday 7:27 PM Tuesday 7:34 PM Tuesday 7:41 PM Tuesday 7:48 PM Tuesday 7:55 PM Tuesday 8:02 PM Tuesday 8:09 PM Tuesday 8:16 PM Tuesday 8:23 PM Tuesday 8:30 PM Tuesday 8:37 PM Tuesday 8:44 PM Tuesday 8:51 PM Tuesday 8:58 PM Tuesday 9:05 PM Tuesday 9:12 PM Tuesday 9:19 PM Tuesday 9:26 PM Tuesday 9:33 PM Tuesday 9:40 PM Tuesday 9:47 PM Tuesday 9:54 PM Tuesday 10:01 PM Tuesday 10:08 PM Tuesday 10:15 PM Tuesday 10:22 PM Tuesday 10:29 PM Tuesday 10:36 PM Tuesday 10:43 PM Tuesday 10:50 PM Tuesday 10:57 PM Tuesday 11:04 PM Tuesday 11:11 PM Tuesday 11:18 PM Tuesday 11:25 PM Tuesday 11:32 PM Tuesday 11:39 PM Tuesday 11:46 PM Tuesday 11:53 PM Wednesday 12:00 AM Wednesday 12:07 AM Wednesday 12:14 AM Wednesday 12:21 AM Wednesday 12:28 AM Wednesday 12:35 AM Wednesday 12:42 AM Wednesday 12:49 AM Wednesday 12:56 AM Wednesday 1:03 AM Wednesday 1:10 AM Wednesday 1:17 AM Wednesday 1:24 AM Wednesday 1:31 AM Wednesday 1:38 AM Wednesday 1:45 AM Wednesday 1:52 AM Wednesday 1:59 AM Wednesday 2:06 AM Wednesday 2:13 AM Wednesday 2:20 AM Wednesday 2:27 AM Wednesday 2:34 AM Wednesday 2:41 AM Wednesday 2:48 AM Wednesday 2:55 AM Wednesday 3:02 AM Wednesday 3:09 AM Wednesday 3:16 AM Wednesday 3:23 AM Wednesday 3:30 AM Wednesday 3:37 AM Wednesday 3:44 AM Wednesday 3:51 AM Wednesday 3:58 AM Wednesday 4:05 AM Wednesday 4:12 AM Wednesday 4:19 AM Wednesday 4:26 AM Wednesday 4:33 AM Wednesday 4:40 AM Wednesday 4:47 AM Wednesday 4:54 AM Wednesday 5:01 AM Wednesday 5:08 AM Wednesday 5:15 AM Wednesday 5:22 AM Wednesday 5:29 AM Wednesday 5:36 AM Wednesday 5:43 AM Wednesday 5:50 AM Wednesday 5:57 AM Wednesday 6:04 AM Wednesday 6:11 AM Wednesday 6:18 AM Wednesday 6:25 AM Wednesday 6:32 AM Wednesday 6:39 AM Wednesday 6:46 AM Wednesday 6:53 AM Wednesday 7:00 AM Wednesday 7:07 AM Wednesday 7:14 AM Wednesday 7:21 AM Wednesday 7:28 AM Wednesday 7:35 AM Wednesday 7:42 AM Wednesday 7:49 AM Wednesday 7:56 AM Wednesday 8:03 AM Wednesday 8:10 AM Wednesday 8:17 AM Wednesday 8:24 AM Wednesday 8:31 AM Wednesday 8:38 AM Wednesday 8:45 AM Wednesday 8:52 AM Wednesday 8:59 AM Wednesday 9:06 AM Wednesday 9:13 AM Wednesday 9:20 AM Wednesday 9:27 AM Wednesday 9:34 AM Wednesday 9:41 AM Wednesday 9:48 AM Wednesday 9:55 AM Wednesday 10:02 AM Wednesday 10:09 AM Wednesday 10:16 AM Wednesday 10:23 AM Wednesday 10:30 AM Wednesday 10:37 AM Wednesday 10:44 AM Wednesday 10:51 AM Wednesday 10:58 AM Wednesday 11:05 AM Wednesday 11:12 AM Wednesday 11:19 AM Wednesday 11:26 AM Wednesday 11:33 AM Wednesday 11:40 AM Wednesday 11:47 AM Wednesday 11:54 AM Wednesday 12:01 PM Wednesday 12:08 PM Wednesday 12:15 PM Wednesday 12:22 PM Wednesday 12:29 PM Wednesday 12:36 PM Wednesday 12:43 PM Wednesday 12:50 PM Wednesday 12:57 PM Wednesday 1:04 PM Wednesday 1:11 PM Wednesday 1:18 PM Wednesday 1:25 PM Wednesday 1:32 PM Wednesday 1:39 PM Wednesday 1:46 PM Wednesday 1:53 PM Wednesday 2:00 PM Wednesday 2:07 PM Wednesday 2:14 PM Wednesday 2:21 PM Wednesday 2:28 PM Wednesday 2:35 PM Wednesday 2:42 PM Wednesday 2:49 PM Wednesday 2:56 PM Wednesday 3:03 PM Wednesday 3:10 PM Wednesday 3:17 PM Wednesday 3:24 PM Wednesday 3:31 PM Wednesday 3:38 PM Wednesday 3:45 PM Wednesday 3:52 PM Wednesday 3:59 PM Wednesday 4:06 PM Wednesday 4:13 PM Wednesday 4:20 PM Wednesday 4:27 PM Wednesday 4:34 PM Wednesday 4:41 PM Wednesday 4:48 PM Wednesday 4:55 PM Wednesday 5:02 PM Wednesday 5:09 PM Wednesday 5:16 PM Wednesday 5:23 PM Wednesday 5:30 PM Wednesday 5:37 PM Wednesday 5:44 PM Wednesday 5:51 PM Wednesday 5:58 PM Wednesday 6:05 PM Wednesday 6:12 PM Wednesday 6:19 PM Wednesday 6:26 PM Wednesday 6:33 PM Wednesday 6:40 PM Wednesday 6:47 PM Wednesday 6:54 PM Wednesday 7:01 PM Wednesday 7:08 PM Wednesday 7:15 PM Wednesday 7:22 PM Wednesday 7:29 PM Wednesday 7:36 PM Wednesday 7:43 PM Wednesday 7:50 PM Wednesday 7:57 PM Wednesday 8:04 PM Wednesday 8:11 PM Wednesday 8:18 PM Wednesday 8:25 PM Wednesday 8:32 PM Wednesday 8:39 PM Wednesday 8:46 PM Wednesday 8:53 PM Wednesday 9:00 PM Wednesday 9:07 PM Wednesday 9:14 PM Wednesday 9:21 PM Wednesday 9:28 PM Wednesday 9:35 PM Wednesday 9:42 PM Wednesday 9:49 PM Wednesday 9:56 PM Wednesday 10:03 PM Wednesday 10:10 PM Wednesday 10:17 PM Wednesday 10:24 PM Wednesday 10:31 PM Wednesday 10:38 PM Wednesday 10:45 PM Wednesday 10:52 PM Wednesday 10:59 PM Wednesday 11:06 PM Wednesday 11:13 PM Wednesday 11:20 PM Wednesday 11:27 PM Wednesday 11:34 PM Wednesday 11:41 PM Wednesday 11:48 PM Wednesday 11:55 PM Thursday 12:02 AM Thursday 12:09 AM Thursday 12:16 AM Thursday 12:23 AM Thursday 12:30 AM Thursday 12:37 AM Thursday 12:44 AM Thursday 12:51 AM Thursday 12:58 AM Thursday 1:05 AM Thursday 1:12 AM Thursday 1:19 AM Thursday 1:26 AM Thursday 1:33 AM Thursday 1:40 AM Thursday 1:47 AM Thursday 1:54 AM Thursday 2:01 AM Thursday 2:08 AM Thursday 2:15 AM Thursday 2:22 AM Thursday 2:29 AM Thursday 2:36 AM Thursday 2:43 AM Thursday 2:50 AM Thursday 2:57 AM Thursday 3:04 AM Thursday 3:11 AM Thursday 3:18 AM Thursday 3:25 AM Thursday 3:32 AM Thursday 3:39 AM Thursday 3:46 AM Thursday 3:53 AM Thursday 4:00 AM Thursday 4:07 AM Thursday 4:14 AM Thursday 4:21 AM Thursday 4:28 AM Thursday 4:35 AM Thursday 4:42 AM Thursday 4:49 AM Thursday 4:56 AM Thursday 5:03 AM Thursday 5:10 AM Thursday 5:17 AM Thursday 5:24 AM Thursday 5:31 AM Thursday 5:38 AM Thursday 5:45 AM Thursday 5:52 AM Thursday 5:59 AM Thursday 6:06 AM Thursday 6:13 AM Thursday 6:20 AM Thursday 6:27 AM Thursday 6:34 AM Thursday 6:41 AM Thursday 6:48 AM Thursday 6:55 AM Thursday 7:02 AM Thursday 7:09 AM Thursday 7:16 AM Thursday 7:23 AM Thursday 7:30 AM Thursday 7:37 AM Thursday 7:44 AM Thursday 7:51 AM Thursday 7:58 AM Thursday 8:05 AM Thursday 8:12 AM Thursday 8:19 AM Thursday 8:26 AM Thursday 8:33 AM Thursday 8:40 AM Thursday 8:47 AM Thursday 8:54 AM Thursday 9:01 AM Thursday 9:08 AM Thursday 9:15 AM Thursday 9:22 AM Thursday 9:29 AM Thursday 9:36 AM Thursday 9:43 AM Thursday 9:50 AM Thursday 9:57 AM Thursday 10:04 AM Thursday 10:11 AM Thursday 10:18 AM Thursday 10:25 AM Thursday 10:32 AM Thursday 10:39 AM Thursday 10:46 AM Thursday 10:53 AM Thursday 11:00 AM Thursday 11:07 AM Thursday 11:14 AM Thursday 11:21 AM Thursday 11:28 AM Thursday 11:35 AM Thursday 11:42 AM Thursday 11:49 AM Thursday 11:56 AM Thursday 12:03 PM Thursday 12:10 PM Thursday 12:17 PM Thursday 12:24 PM Thursday 12:31 PM Thursday 12:38 PM Thursday 12:45 PM Thursday 12:52 PM Thursday 12:59 PM Thursday 1:06 PM Thursday 1:13 PM Thursday 1:20 PM Thursday 1:27 PM Thursday 1:34 PM Thursday 1:41 PM Thursday 1:48 PM Thursday 1:55 PM Thursday 2:02 PM Thursday 2:09 PM Thursday 2:16 PM Thursday 2:23 PM Thursday 2:30 PM Thursday 2:37 PM Thursday 2:44 PM Thursday 2:51 PM Thursday 2:58 PM Thursday 3:05 PM Thursday 3:12 PM Thursday 3:19 PM Thursday 3:26 PM Thursday 3:33 PM Thursday 3:40 PM Thursday 3:47 PM Thursday 3:54 PM Thursday 4:01 PM Thursday 4:08 PM Thursday 4:15 PM Thursday 4:22 PM Thursday 4:29 PM Thursday 4:36 PM Thursday 4:43 PM Thursday 4:50 PM Thursday 4:57 PM Thursday 5:04 PM Thursday 5:11 PM Thursday 5:18 PM Thursday 5:25 PM Thursday 5:32 PM Thursday 5:39 PM Thursday 5:46 PM Thursday 5:53 PM Thursday 6:00 PM Thursday 6:07 PM Thursday 6:14 PM Thursday 6:21 PM Thursday 6:28 PM Thursday 6:35 PM Thursday 6:42 PM Thursday 6:49 PM Thursday 6:56 PM Thursday 7:03 PM Thursday 7:10 PM Thursday 7:17 PM Thursday 7:24 PM Thursday 7:31 PM Thursday 7:38 PM Thursday 7:45 PM Thursday 7:52 PM Thursday 7:59 PM Thursday 8:06 PM Thursday 8:13 PM Thursday 8:20 PM Thursday 8:27 PM Thursday 8:34 PM Thursday 8:41 PM Thursday 8:48 PM Thursday 8:55 PM Thursday 9:02 PM Thursday 9:09 PM Thursday 9:16 PM Thursday 9:23 PM Thursday 9:30 PM Thursday 9:37 PM Thursday 9:44 PM Thursday 9:51 PM Thursday 9:58 PM Thursday 10:05 PM Thursday 10:12 PM Thursday 10:19 PM Thursday 10:26 PM Thursday 10:33 PM Thursday 10:40 PM Thursday 10:47 PM Thursday 10:54 PM Thursday 11:01 PM Thursday 11:08 PM Thursday 11:15 PM Thursday 11:22 PM Thursday 11:29 PM Thursday 11:36 PM Thursday 11:43 PM Thursday 11:50 PM Thursday 11:57 PM Friday 12:04 AM Friday 12:11 AM Friday 12:18 AM Friday 12:25 AM Friday 12:32 AM Friday 12:39 AM Friday 12:46 AM Friday 12:53 AM Friday 1:00 AM Friday 1:07 AM Friday 1:14 AM Friday 1:21 AM Friday 1:28 AM Friday 1:35 AM Friday 1:42 AM Friday 1:49 AM Friday 1:56 AM Friday 2:03 AM Friday 2:10 AM Friday 2:17 AM Friday 2:24 AM Friday 2:31 AM Friday 2:38 AM Friday 2:45 AM Friday 2:52 AM Friday 2:59 AM Friday 3:06 AM Friday 3:13 AM Friday 3:20 AM Friday 3:27 AM Friday 3:34 AM Friday 3:41 AM Friday 3:48 AM Friday 3:55 AM Friday 4:02 AM Friday 4:09 AM Friday 4:16 AM Friday 4:23 AM Friday 4:30 AM Friday 4:37 AM Friday 4:44 AM Friday 4:51 AM Friday 4:58 AM Friday 5:05 AM Friday 5:12 AM Friday 5:19 AM Friday 5:26 AM Friday 5:33 AM Friday 5:40 AM Friday 5:47 AM Friday 5:54 AM Friday 6:01 AM Friday 6:08 AM Friday 6:15 AM Friday 6:22 AM Friday 6:29 AM Friday 6:36 AM Friday 6:43 AM Friday 6:50 AM Friday 6:57 AM Friday 7:04 AM Friday 7:11 AM Friday 7:18 AM Friday 7:25 AM Friday 7:32 AM Friday 7:39 AM Friday 7:46 AM Friday 7:53 AM Friday 8:00 AM Friday 8:07 AM Friday 8:14 AM Friday 8:21 AM Friday 8:28 AM Friday 8:35 AM Friday 8:42 AM Friday 8:49 AM Friday 8:56 AM Friday 9:03 AM Friday 9:10 AM Friday 9:17 AM Friday 9:24 AM Friday 9:31 AM Friday 9:38 AM Friday 9:45 AM Friday 9:52 AM Friday 9:59 AM Friday 10:06 AM Friday 10:13 AM Friday 10:20 AM Friday 10:27 AM Friday 10:34 AM Friday 10:41 AM Friday 10:48 AM Friday 10:55 AM Friday 11:02 AM Friday 11:09 AM Friday 11:16 AM Friday 11:23 AM Friday 11:30 AM Friday 11:37 AM Friday 11:44 AM Friday 11:51 AM Friday 11:58 AM Friday 12:05 PM Friday 12:12 PM Friday 12:19 PM Friday 12:26 PM Friday 12:33 PM Friday 12:40 PM Friday 12:47 PM Friday 12:54 PM Friday 1:01 PM Friday 1:08 PM Friday 1:15 PM Friday 1:22 PM Friday 1:29 PM Friday 1:36 PM Friday 1:43 PM Friday 1:50 PM Friday 1:57 PM Friday 2:04 PM Friday 2:11 PM Friday 2:18 PM Friday 2:25 PM Friday 2:32 PM Friday 2:39 PM Friday 2:46 PM Friday 2:53 PM Friday 3:00 PM Friday 3:07 PM Friday 3:14 PM Friday 3:21 PM Friday 3:28 PM Friday 3:35 PM Friday 3:42 PM Friday 3:49 PM Friday 3:56 PM Friday 4:03 PM Friday 4:10 PM Friday 4:17 PM Friday 4:24 PM Friday 4:31 PM Friday 4:38 PM Friday 4:45 PM Friday 4:52 PM Friday 4:59 PM Friday 5:06 PM Friday 5:13 PM Friday 5:20 PM Friday 5:27 PM Friday 5:34 PM Friday 5:41 PM Friday 5:48 PM Friday 5:55 PM Friday 6:02 PM Friday 6:09 PM Friday 6:16 PM Friday 6:23 PM Friday 6:30 PM Friday 6:37 PM Friday 6:44 PM Friday 6:51 PM Friday 6:58 PM Friday 7:05 PM Friday 7:12 PM Friday 7:19 PM Friday 7:26 PM Friday 7:33 PM Friday 7:40 PM Friday 7:47 PM Friday 7:54 PM Friday 8:01 PM Friday 8:08 PM Friday 8:15 PM Friday 8:22 PM Friday 8:29 PM Friday 8:36 PM Friday 8:43 PM Friday 8:50 PM Friday 8:57 PM Friday 9:04 PM Friday 9:11 PM Friday 9:18 PM Friday 9:25 PM Friday 9:32 PM Friday 9:39 PM Friday 9:46 PM Friday 9:53 PM Friday 10:00 PM Friday 10:07 PM Friday 10:14 PM Friday 10:21 PM Friday 10:28 PM Friday 10:35 PM Friday 10:42 PM Friday 10:49 PM Friday 10:56 PM Friday 11:03 PM Friday 11:10 PM Friday 11:17 PM Friday 11:24 PM Friday 11:31 PM Friday 11:38 PM Friday 11:45 PM Friday 11:52 PM Friday 11:59 PM Saturday 12:06 AM Saturday 12:13 AM Saturday 12:20 AM Saturday 12:27 AM Saturday 12:34 AM Saturday 12:41 AM Saturday 12:48 AM Saturday 12:55 AM Saturday 1:02 AM Saturday 1:09 AM Saturday 1:16 AM Saturday 1:23 AM Saturday 1:30 AM Saturday 1:37 AM Saturday 1:44 AM Saturday 1:51 AM Saturday 1:58 AM Saturday 2:05 AM Saturday 2:12 AM Saturday 2:19 AM Saturday 2:26 AM Saturday 2:33 AM Saturday 2:40 AM Saturday 2:47 AM Saturday 2:54 AM Saturday 3:01 AM Saturday 3:08 AM Saturday 3:15 AM Saturday 3:22 AM Saturday 3:29 AM Saturday 3:36 AM Saturday 3:43 AM Saturday 3:50 AM Saturday 3:57 AM Saturday 4:04 AM Saturday 4:11 AM Saturday 4:18 AM Saturday 4:25 AM Saturday 4:32 AM Saturday 4:39 AM Saturday 4:46 AM Saturday 4:53 AM Saturday 5:00 AM Saturday 5:07 AM Saturday 5:14 AM Saturday 5:21 AM Saturday 5:28 AM Saturday 5:35 AM Saturday 5:42 AM Saturday 5:49 AM Saturday 5:56 AM Saturday 6:03 AM Saturday 6:10 AM Saturday 6:17 AM Saturday 6:24 AM Saturday 6:31 AM Saturday 6:38 AM Saturday 6:45 AM Saturday 6:52 AM Saturday 6:59 AM Saturday 7:06 AM Saturday 7:13 AM Saturday 7:20 AM Saturday 7:27 AM Saturday 7:34 AM Saturday 7:41 AM Saturday 7:48 AM Saturday 7:55 AM Saturday 8:02 AM Saturday 8:09 AM Saturday 8:16 AM Saturday 8:23 AM Saturday 8:30 AM Saturday 8:37 AM Saturday 8:44 AM Saturday 8:51 AM Saturday 8:58 AM Saturday 9:05 AM Saturday 9:12 AM Saturday 9:19 AM Saturday 9:26 AM Saturday 9:33 AM Saturday 9:40 AM Saturday 9:47 AM Saturday 9:54 AM Saturday 10:01 AM Saturday 10:08 AM Saturday 10:15 AM Saturday 10:22 AM Saturday 10:29 AM Saturday 10:36 AM Saturday 10:43 AM Saturday 10:50 AM Saturday 10:57 AM Saturday 11:04 AM Saturday 11:11 AM Saturday 11:18 AM Saturday 11:25 AM Saturday 11:32 AM Saturday 11:39 AM Saturday 11:46 AM Saturday 11:53 AM Saturday 12:00 PM Saturday 12:07 PM Saturday 12:14 PM Saturday 12:21 PM Saturday 12:28 PM Saturday 12:35 PM Saturday 12:42 PM Saturday 12:49 PM Saturday 12:56 PM Saturday 1:03 PM Saturday 1:10 PM Saturday 1:17 PM Saturday 1:24 PM Saturday 1:31 PM Saturday 1:38 PM Saturday 1:45 PM Saturday 1:52 PM Saturday 1:59 PM Saturday 2:06 PM Saturday 2:13 PM Saturday 2:20 PM Saturday 2:27 PM Saturday 2:34 PM Saturday 2:41 PM Saturday 2:48 PM Saturday 2:55 PM Saturday 3:02 PM Saturday 3:09 PM Saturday 3:16 PM Saturday 3:23 PM Saturday 3:30 PM Saturday 3:37 PM Saturday 3:44 PM Saturday 3:51 PM Saturday 3:58 PM Saturday 4:05 PM Saturday 4:12 PM Saturday 4:19 PM Saturday 4:26 PM Saturday 4:33 PM Saturday 4:40 PM Saturday 4:47 PM Saturday 4:54 PM Saturday 5:01 PM Saturday 5:08 PM Saturday 5:15 PM Saturday 5:22 PM Saturday 5:29 PM Saturday 5:36 PM Saturday 5:43 PM Saturday 5:50 PM Saturday 5:57 PM Saturday 6:04 PM Saturday 6:11 PM Saturday 6:18 PM Saturday 6:25 PM Saturday 6:32 PM Saturday 6:39 PM Saturday 6:46 PM Saturday 6:53 PM Saturday 7:00 PM Saturday 7:07 PM Saturday 7:14 PM Saturday 7:21 PM Saturday 7:28 PM Saturday 7:35 PM Saturday 7:42 PM Saturday 7:49 PM Saturday 7:56 PM Saturday 8:03 PM Saturday 8:10 PM Saturday 8:17 PM Saturday 8:24 PM Saturday 8:31 PM Saturday 8:38 PM Saturday 8:45 PM Saturday 8:52 PM Saturday 8:59 PM Saturday 9:06 PM Saturday 9:13 PM Saturday 9:20 PM Saturday 9:27 PM Saturday 9:34 PM Saturday 9:41 PM Saturday 9:48 PM Saturday 9:55 PM Saturday 10:02 PM Saturday 10:09 PM Saturday 10:16 PM Saturday 10:23 PM Saturday 10:30 PM Saturday 10:37 PM Saturday 10:44 PM Saturday 10:51 PM Saturday 10:58 PM Saturday 11:05 PM Saturday 11:12 PM Saturday 11:19 PM Saturday 11:26 PM Saturday 11:33 PM Saturday 11:40 PM Saturday 11:47 PM Saturday 11:54 PM"; $times = explode("\n", $times); date_default_timezone_set('America/Los_Angeles'); include_once "times.php"; //set $times function changeTime(&$val, $key){ $val = strtotime($val) + 53; } array_walk($times, 'changeTime'); sort($times); echo '<pre>'; print_r($times); echo '</pre>'; //$currentTime = strtotime(date("l h:i:s A")); $currentTime = strtotime("Monday 11:59:50 PM"); $intCount = 0; while($times[$intCount] < $currentTime) { $intCount++; } echo date("l g:i:53 A", $times[$intCount]); ?> Ahhh, refresh after testing, and before posting will save you from looking like an idiot <<
-
Getting a loop to simply write "static" code ??
jcbones replied to ThunderVike's topic in PHP Coding Help
So you want code to be written dynamically, from static, that doesn't display, but processes. But then you are having an issue that echo is returning errors on some dynamically created PHP code, that is written from a static point of view. And that is about as confusing as your post is... 1. Do you want the PHP code written to the page? 2. You want $_POSTED data, to be evaluated by the PHP interpreter, processed, then the results echo'd back to the page? IF it is not 1, I suggest you re-think what exactly you want to do. 2 is very dangerous, and can read('will') lead to a compromised server. -
Using jQuery, we can use a different method of getting HTTPrequests. Based on this I have re-done the file. Just make sure you have all of the needed .js files for the tablesorter. Obtainable in your link. <?php include('config.php'); //Include the database connections in it's own file, for easy integration in multiple pages. $lastname_result = mysql_query("SELECT lastname FROM user GROUP BY lastname"); $result = mysql_query("SELECT * FROM user"); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="../themes/style.css" rel="stylesheet" type="text/css" media="print, projection, screen" /></link> <link href="../common.css" rel="stylesheet" type="text/css"></link> <script type="text/javascript" src="jquery-latest.js"></script> <script type="text/javascript" src="jquery.tablesorter.js"></script> <script type="text/javascript"> $(document).ready(function() { $("#myTable").tablesorter(); } ); function reSort(par) { $("#tableBody").empty(); var vfrom = document.getElementById('from').value; var vto = document.getElementById('to').value; $.get('table.list.php?from='+vfrom+'&to='+vto+'&lastname='+par,function(html) { // append the "ajax'd" data to the table body $("#tableBody").append(html); // let the plugin know that we made a update $("#myTable").trigger("update"); // set sorting column and direction, this will sort on the first and third column var sorting = [[2,1],[0,0]]; // sort on the first column $("#myTable").trigger("sorton",[sorting]); }); } function getNames() { var vfrom = document.getElementById('from').value; var vto = document.getElementById('to').value; $("#selectbox").empty(); $.get('select.list.php?from='+vfrom+'&to='+vto,function(html) { $("#selectbox").append(html); }); } </script> </head> <body> <table width="100%" border="0" cellspacing="0" cellpadding="5" class="main"> <tr> <td width="160" valign="top"></td> <td width="732" valign="top"> <table width="90%" border="0" align="center"> <form action="test3.php" method="post"> <label for="from">From</label> <input type="text" id="from" name="from" onkeyup="getNames();"/> <label for="to">to</label> <input type="text" id="to" name="to" onkeyup="getNames();"/> <?php //added javascript function call to function located in "ajax.js" ?> <select id="selectbox" name="area" onchange="reSort(this.value);"> <?php //added javascript function call to function located in "ajax.js", and changed the id for content change via javascript. ?> <option value="">Select an lastname</option> <option value=""></option> <?php while(list($lastname)=mysql_fetch_array($lastname_result)) { echo "<option value='$lastname'>$lastname</option>"; } ?> </select> </form> </table> <table id="myTable" class="tablesorter" border="1" cellpadding="5" cellspacing="1"> <thead> <tr> <th>First Name</th> <th>Last Name</th> <th>Age</th> <th>Birthday</th> <th>Hometown</th> <th>Job</th> </tr> </thead> <tbody id="tableBody"> <?php //added id to the tbody so we could change the content via javascript ?> <?php while($row=mysql_fetch_assoc($result)){ ?> <tr> <td><?php echo $row['firstname']; ?></td> <td><?php echo $row['lastname']; ?></td> <td><?php echo $row['age']; ?></td> <td><?php echo $row['birthday']; ?></td> <td><?php echo $row['hometown']; ?></td> <td><?php echo $row['job']; ?></td> </tr> <?php } // End while loop. ?> </tbody> </table> <p> </p> <p> </p> <p align="right"> </p> </td> <td width="196" valign="top"> </td> </tr> </table> </body> </html> P.S. I'll let you do the datepicker.
-
Try $id = 'member_id'; //members id you are searching for. $sql = "SELECT a.*,b.* FROM member_topics as a, friends_table as b WHERE (a.member_id = b.member_id OR a.member_id = b.friend_id) AND ((b.member_id = '$id' OR b.friend_id = '$id') AND b.is_friend = 1)"; UN-TESTED.
-
hcdarkmage, I'm not sure I understand what you're saying here. Are you saying you have to declare the variables in advance to using them? Like using DIM in visual basic? When I added the missing semicolon after the $errorstring statement, the script started working so I'm not sure how your explanation helps me. Do you think you could clarify your meaning? Thanks a lot! Rob No what he is saying is, if $_POST['submit'] was not set, you would always get the $errorstring for fname. Moving it inside of the $_POST if statement would only return the error string, IF the form had been posted.