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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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. -
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? -
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. -
Date comparison help
Never mind.... 'DAYOFMONTH(startDate)' did it. Thanks for the help - I'm sure I'll be back :p -
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... -
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... -
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 =... -
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... -
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...- Septimius
- Thread
- Replies: 4
- Forum: PC hardware - General discussion
