Ask a Question related to Macromedia Dynamic HTML, Design and Development.

  1. #1

    Default Date Math

    In MySQL/PHP

    I convert a MySQL date from a query and just do not know the syntax to add say "1 month" to this date ...

    <?php echo date("m/d/Y",strtotime($row_query['date'])); ?>

    How can I add 1 month to this? ...

    Thanks

    ----
    Rob Maguire
    Web Development
    bigforehand Guest

  2. Similar Questions and Discussions

    1. Math opreation with DATE
      hi, anyone hav idea how can i do math operation with date in flash?
    2. math problem will Math.floor help
      I have the following code that at first sight should return a value of zero but does not always. What can be done about this. The following code...
    3. Math::GMP tests and Crypt::Random fail on Compaq (Math::Pari related ??)
      Hi, I've been compiling Math::GMP for different OS's in order to use Net::SFTP and I have successfully compiled and used it for Solaris,...
    4. HELP! Needed with Fox Pro date math
      I am accessing a Fox Pro database through ODBC in ASP. I have a table with two dates in it. A start date and an end date. I need to create a...
    5. OT: Math help
      Just divide the width of the page by 2. Then divide the width of the image by 2. Then subtract the length of half of the image from the length of...
  3. #2

    Default Date Math

    All:

    Using PHP and MySQL, I want to be able to add 2 months (or whatever time I want) to a queried date. Here is my code:

    <?php echo date ("m/d/Y",strtotime($row_gethistory['date'] +2 months")); ?>

    This returns an error ... what am I missing?

    Thanks!


    ----
    Rob Maguire
    Web Development
    bigforehand Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139