Recent content by tektipsismyfavorite

i re-ran the query and outputted the result using the exact same loop later down the page. //i leave the value of the query set to what it was before. mysql_select_db($database_ra_connect, $ra_connect); $alerts = mysql_query($query_alerts, $ra_connect) or die(mysql_error()); $totalRows_alerts =...

well, the problem I'm having is it only goes through the mail script once, just for the first record. here's my code: //set variables for this minute $todayDay = date("d"); $todayMonth = date("m"); $todayYear = date("Y"); $todayHour = date("H"); $todayMinute = date("i"); $alertStart =...

I've tried doing while loops in the past, it just doesn't seem to be working. I'm new to PHP5, is there something pertaining to anything i'm doing different than 4?

It's not actually my column name, but just for simplicity purposes i used that. I'm sure that it's pulling records because if i comment that mailer out, and output the loop into HTML, i see all the records i'm supposed to. So, do I need to get rid of the first one? ($row_query =...

I'm using PHPMailer to send out emails based on what comes up in the Query. Using a do { } while ( ); seems to only send out the first record. I'm using: mysql_select_db($database, $connection); $query = "SELECT * FROM events WHERE date BETWEEN '2006-06-26 00:00:00' AND '2006-07-26 23:59:59'"...

Great, thanks.

Does that include the first and last values?

you have a comma after static_name

I have a cron job setup to run every minute and I want it to retrieve records for that minute. My query is setup like this: SELECT * FROM stuff WHERE datetime >= '".$startdate."' AND datetime <= '".$enddate."' startdate and enddate get the current date/time and format it in the MySQL Date...

I'm assuming your data is stored: website_id website score month_or_date Is it that you need to find last month's score based on it being the most recent score in the table (besides the current month)? You could use SELECT DISTINCT for that and sort it by date, only if your date field is...

I'm having the hardest time trying to do a "page view style switch" where the user can view a page 1 of 2 ways. Basically, if there is no "view" variable set in the URL, then the view is "normal", but if $_GET['view] == "list", then it's list view. The problem is switching them back and forth...

how many rows are in your table? make sure there aren't other rows with no colspan or colspan="5" or something like that. I know for a fact colspan works in Firefox. With tables, IE tends to fill in missing cells, where Firefox takes what you give it literally. so if you have row,cell,cell, and...

I want to put the year in the background of a table cell using either a dynamic gif or CSS. I've seen it done before but not sure how to do it. I tried: style="background:url(year_bg.php?year=<?php echo $theyear; ?>); background-position:center; background-repeat:no-repeat;" and year_bg.php =...

awesome. Thanks. I had thought of the cron job idea, but how do suggest explaining to the user? Ie. Please don't expect recurring events to show up past 2 years in the calendar because they haven't been created yet... ? Thanks again.

I built a custom calendar and i've successfully been able to list out events on it based on the date (YYYY-MM-DD), however my next obstacle is allowing events to re-occur more than once. For instance, if something needs to happen the 3rd Friday of every month. Or repeating an event on the 15th...