Advertisement

04.18.2008 at 02:35AM PDT, ID: 23333618
[x]
Attachment Details

Find Birthdays in next 7 days

Asked by amilan in MySQL, PHP Scripting Language, PHP and Databases

Tags: MySQL, MySql, 4.1, PHP

I have a members table in MySql, here members date of birth is NOT date type but CHAR(10) with british date format (i.e. dd/mm/yyyy). I want to build a query that can list members whose birhdays are within this week (today and next 6 days). I can not change dob field to date type as it holds some birthdays whose year is not known like '15/07' '24/11' etc. (this is why this is a CHAR field)

Thanks in advance
Start Free Trial
 
Keywords: Find Birthdays in next 7 days
Title
1 Birthdays
2 Birthday Calculation
3 Birthday Poinks..
4 Showing Birthdays
5 birthday script
6 Birthday Query
 
Loading Advertisement...
 
[+][-]04.18.2008 at 02:41AM PDT, ID: 21384347

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 02:50AM PDT, ID: 21384388

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 02:55AM PDT, ID: 21384404

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 03:10AM PDT, ID: 21384471

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 03:12AM PDT, ID: 21384478

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 04:24AM PDT, ID: 21384804

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 05:08AM PDT, ID: 21385007

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, PHP Scripting Language, PHP and Databases
Tags: MySQL, MySql, 4.1, PHP
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 2
Solution Grade: B
 
 
[+][-]04.18.2008 at 05:14AM PDT, ID: 21385052

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 05:21AM PDT, ID: 21385098

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 05:40AM PDT, ID: 21385203

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 06:28AM PDT, ID: 21385521

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 06:42AM PDT, ID: 21385621

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628