Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tektipsismyfavorite
  • Order by date
  1. tektipsismyfavorite

    Using the Right Loop with PHPMailer

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

    Using the Right Loop with PHPMailer

    ...".$todayHour.":".$todayMinute.":59"; mysql_select_db($database_ra_connect, $ra_connect); $query_alerts = "SELECT * FROM alerts, reminders, ra_users, providers WHERE alerts.userid = ra_users.userid AND alerts.active = '1' AND alerts.reminderid = reminders.reminderid AND ra_users.providerid =...
  3. tektipsismyfavorite

    Using the Right Loop with PHPMailer

    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?
  4. tektipsismyfavorite

    Using the Right Loop with PHPMailer

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

    Using the Right Loop with PHPMailer

    ...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'"; $sql = mysql_query($query, $connection) or die(mysql_error())...
  6. tektipsismyfavorite

    Issue with Date values

    Great, thanks.
  7. tektipsismyfavorite

    Issue with Date values

    Does that include the first and last values?
  8. tektipsismyfavorite

    whats wrong with this sql

    you have a comma after static_name
  9. tektipsismyfavorite

    Issue with Date values

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

    Query with previous results

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

    Extracting 1 $_GET value and leave the rest

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

    Firefox ignores colspan=&quot;2&quot;

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

    Using Dynamic Text as background in TD

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

    Reoccuring dates on custom calendar

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

    Reoccuring dates on custom calendar

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

    Image Upload Script Problems

    Have you tried this one? http://www.finalwebsites.com/snippets.php?id=7 It's a PHP class. It's by far my favorite. Not only is it customizable, allows single or multiple files, but it also leaves a blank line of code allowing you to do more with the files when it's done uploading. It even...
  17. tektipsismyfavorite

    Iframe won't submit in IE

    ok, well, i got rid of the 2 lines to disable the button. it works, but button doesn't disable :(... if(errStr == null){ //document.develop.Submit2.value = "Sending..."; //document.develop.Submit2.disabled = true; return true; } else { alert("There were some errors:\n"+errStr); return...
  18. tektipsismyfavorite

    Iframe won't submit in IE

    I've tried that and it causes the function to not even work in IE. I've designed hundreds of forms with similar javascript validation code, but never in an iFrame. I'm not sure why IE is having problems with it.
  19. tektipsismyfavorite

    Iframe won't submit in IE

    <input type="submit" name="Submit2" value="Request the Info" onclick="return checkForm();" />
  20. tektipsismyfavorite

    Iframe won't submit in IE

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

Part and Inventory Search

Back
Top