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!

  • Congratulations strongm 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. Septimius

    Date comparison help

    haha - I'll refrain from further complaints then :D Thanks again for the help. I'll likely be back, but I've got plenty to keep me going for 30 more minutes today till I get off work.
  2. Septimius

    Date comparison help

    No, they really are bad. We also host a ton of domains, but we have this particular project outsourced - It's been nothing but trouble with them unfortunately :( they're running version 3.23.56 - that's not TOO old is it?
  3. Septimius

    Date comparison help

    haha - yeah, our host is terrible, so an old version of MySQL would not be that shocking. Oh well, gotta work with what they give me I suppose.
  4. Septimius

    Date comparison help

    Never mind.... 'DAYOFMONTH(startDate)' did it. Thanks for the help - I'm sure I'll be back :p
  5. Septimius

    Date comparison help

    Awesome idea... I had thought of trying to add the years using timestamp seconds, but this is much better. However, I'm running into an issue. I can query the MONTH(startDate) and it works fine, but if I attempt to use DAY(startDate), it gives an error: "You have an error in your SQL syntax...
  6. Septimius

    Date comparison help

    Ok, well, currently I'm bringing in the full date using the query below: $query = mysql_query("SELECT emID, startDate FROM Eval") or die("Error retrieving data from Eval table."); $queryResults = mysql_fetch_array($query); My questions are now: 1) How can I edit this query to return JUST the...
  7. Septimius

    Date comparison help

    Well, I basically need to just bring in an employee ID (emID) and the Month and Day of a field labled 'StartDate' in the DB. Currently I'm saying: $query = mysql_query("SELECT emID, startDate FROM Eval") or die("Error retrieving data from Eval table."); $queryResults =...
  8. Septimius

    Date comparison help

    Hello all, I'm currently having to teach myself PHP on the fly for a project, and have run into a tough problem. Was hoping I could get some assistance. Currently, I am writing a page that will be taking a Date field from a MySQL Database (datatype of Date), and comparing it to the current...
  9. Septimius

    Primary Master disk fails!

    Hi! After using my computer in the current configuration for two years now I suddenly get the following error message and the comp. will not boot : Primary master disk fails. It happened after a crash of my TNT 2 driver related to OpenGL while starting medal of honour. Hardware: Maxtor 30Gb...

Part and Inventory Search

Back
Top