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 Chriss Miller 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: *

  1. matthewralston

    Adding 1 month to a date

    Thank you. That'll do.
  2. matthewralston

    Adding 1 month to a date

    I want to get the date 1 month from now. So if today is 11/11/2002, I want to get 11/12/2002. If today is 30/01/2003 I want to get (I suppose) 02/03/2003...something like that. In VBScript there is DateAdd(). Is there something similar in PHP?
  3. matthewralston

    Getting at headers when requesting a URL

    Thanks very much. That does exactly what I need. :)
  4. matthewralston

    Getting at headers when requesting a URL

    I want to fetch a URL in PHP with fopen or popen or something. Getting the main content of the page is fine, but I want to access the headers that the server sends back with the page. I'm sure it can be done with popen (or some command to open a tcp/ip connection to port 80?)
  5. matthewralston

    Comparing the values returned by two sub-queries

    GROUP BY clause not being something I understand, I normally just group by everything in the SELECT fields...normally works!
  6. matthewralston

    Comparing the values returned by two sub-queries

    The ON clause of the FROM statement does this. Putting in in the WHERE statement makes no difference.
  7. matthewralston

    Comparing the values returned by two sub-queries

    It wanted a GROUP BY clause, so I put one in. Then it would run, but returns zero records. I tried using an outer join but still no luck. This is what I've got at the moment... SELECT p.product_id, p.title, p.description, p.image, p.price, p.start_date...
  8. matthewralston

    Comparing the values returned by two sub-queries

    MySQL doesn't like the @ (and possibly the := ) operator. I don't think it has an equivalent.
  9. matthewralston

    Comparing the values returned by two sub-queries

    I need it to only return the records where count(o.order_id) < p.quantity And if I put that into the WHERE clause MySQL won't run it.
  10. matthewralston

    Comparing the values returned by two sub-queries

    I've got a MySQL database, with two tables that we're interested in: products product_id (PK), category_id (FK), title, description, image, price, quantity, start_date, lifetime, renewal_date orders order_id (PK), product_id (FK), user_id (FK), order_date, eta, payment_method, status products...
  11. matthewralston

    PHP is what word's summery ?

    Originally it was Rasmus Lerforf's &quot;Personal Home Page Tools version 1.0&quot; but it's advanced so much since then that that title no longer (erm...what's a good word?) fully encapsulates everything that PHP does...so nowadays it's just PHP. :)
  12. matthewralston

    Get the title from an HTML page

    I'll be loading the contents of an HTML page into a variable and I need to get the title of the from that variable. Basically I need to ge the text from in between the <title> tags. Any ideas? Thanks, Matt matthew.ralston@haltoncollege.ac.uk < www.mralston.co.uk />

Part and Inventory Search

Back
Top