Search results for 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'"...

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 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...

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 =...

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...

I have an iframe with nothing but a form inside it and for some strange reason, the form won't submit in IE. It works fine in Firefox, but hangs in IE. iframe: <iframe id="info" src="moreinfo.php" frameborder="0" width="500" height="410" scrolling="no"></iframe> form: $submitFormAction =...

I have created a calendar with PHP and i have a MySQL query that I would like to loop through the rows as each day is added to the page. I wasn't sure if this post needed to go into the MySQL forum, but what I would like to do is while my days are outputting, i'd like to see if the day of the...

How do I get the first day of the week's day integer (0 for Sunday and 6 for Saturday) for a particular month? php manual says date("w") returns today, but how do I return the first day of June, 2006 or something?

I have a main page that has a query to get all my clients in alphabetical order. "SELECT * FROM clients ORDER BY cname ASC" This obviously mixes up their IDs. So when I click on a client's name "Goofy" (id = 6), I need the next client "Mickey Mouse" (id = 2), and "Donald Duck" (id = 9) to be...

I'm trying a "do" loop to list out a list from a query. I want the list to wrap into the next cell when it gets halfway finished. This is the code I'm using, but for some reason, it's not calculating correctly and it's duplicated the record that is at the halfway point. <table cellpadding="1"...

I have a div floating absolutely to the bottom and right of the page. I have an image inside the div and it has a link on it. <div style="right:0px; bottom:0px; width:141px; height:141px; position:absolute;"><a href="shows.php"><img src="img/nextshow.gif" width="141" height="141" border="0"...

I have a subdomain with the same company and if I ftp into my host, all my domains/subdomains are listed in the same directory. So i figured i can use: mkdir("../../../sub.domain.com/files/".$directory,0777); (where "../../../" gets me out of the current folder and into the one above the root...

I'm trying to write "user-added" fields to MySQL and can't figure out how to go about this. The form has dynamically added fields and they're added in this method: field2 <- starts at 2 field3 field4 When a field is added or removed from the page, i update a hidden input (visibleFields) with...

I am working on a phone number validator and have an input that has maxChars = 12. The format i'm going for is 999.999.9999 There's also a part that validates if it's a numeral. I've tried this:(called by onkeypress="return doPhone(this.value, event, 0)") function doPhone(currv, evt...